Exam 1: Access 2019

To set a startup form, click the File tab, and then click _____.

The first step in the Form Wizard is to _____.

You can add a line to a report to indicate a subtotal.

What is the result of selecting a text box in Report Design view and then clicking the Center button on the Home tab?

Entering an expression such as =[Price]*[Quantity] in a text box creates a calculated control.

To run a macro from a form, add a check box control to the form.

Changing the title of a report in Report Layout view also changes the name of the report.

A form selects a subset of fields and records from one or more tables, and then presents the selected data as a single datasheet.

What must you use in a macro that performs an action if an employee's salary is greater than $50,000 and the performance rating is greater than 5?

Which Access tool studies the structure and size of a database and recommends how to improve its speed?

Query for zero-length values by entering Is Null as the criterion.

Because the _____ section prints once for each record in the record source, you often shorten the section in Report Design view.

Class modules most commonly run in response to an event, such as a user clicking a command button.

To resize a selected control in Report Design view, you can use the _____.

To query for null values, use Is Null as the criterion.

The _____ refers to the data you would edit if you started typing.

An HTML document is a text file that uses _____ to mark up content stored in the file.

A Make-Table query is a type of _____.

How can you select all the labels in a report section when working in Report Design view?

You can use the _____ to copy data from Excel to Access.