Exam 1: Access 2019

To create an Update query in Query Design view, you use the Add to row in the query design grid.

When you select a control in Form Design view and then press an arrow key, you _____ the control.

To decrease the decimal places in a Number field in Table Datasheet view, you can use the Decrease Decimals button.

Besides reducing file size, what other benefit does compacting an Access database provide?

You can remove a control layout from a form in Form Design view or Form Layout view.

Which of the following does NOT save changes made to a record?

When you add a Yes/No field in Report Design view, what control(s) does Access typically add to the report?

If you select 25 in the Top Values list, Access displays _____ in the query results.

In Query Design view, use the COUNT aggregate function when you want to find the number of values in a field.

Sorting records in ascending order based on a Short Text field arranges them in alphabetic order from Z to A.

To center the text in a selected form control in Form Layout view, you _____.

What type of query should you create if you want to change a manager's name from "Jones" to "Ames" for all selected records?

_____ are statements in the code that document the code and do not affect how it runs.

After you freeze a field in a query datasheet, you must run the query again before you can unfreeze the field.

To resize the Detail section in Report Design view, you _____.

Compacting a database rearranges the data and objects in a database to decrease its file size.

If you choose fields from two related tables in the Form Wizard, you can create a main form with a subform.

The _____ is the wildcard character that stands for any single character in criteria.

How can you reorder the navigation buttons in a navigation form in Form Layout view?

When you click the Blank Report button on the Create tab, Access opens a blank report in _____.