Exam 1: Access 2019

To share form data among two or more programs, export the form as a(n) _____ file.

At what point does Access save the data in a database?

How do you rename a table?

Which action query would you use if you wanted to add records from one table to a backup table?

To have form users select one of three options, add a(n) _____ to the form.

How do you display the results of a query listed in the Navigation Pane?

When you apply the Currency format to a field, Access displays a currency symbol and two values after the decimal point, but it does not change the field's data type.

If users must enter text in a LastName field, you can set the _____ property for the field in Table Datasheet view.

You can use the Chart Wizard to add a chart to a form or query .

When you convert a macro, you break it down, step by step, to observe the effect of each action.

In Query Design view, the query grid shows the names of the fields and tables involved in the query.

To view all the indexes in a table at the same time, use the Indexes button in Table Design view.

To resize a control in Report Design view, you select the control and then _____.

If you want to export records to another Access database, create a Top Values query.

In Print Preview, you can display the next page of a report by pressing the PAGE DOWN key.

A(n) _____ provides a template for designing a form.

If you import data from Excel often, you can save the import steps so you can repeat them easily and accurately.

You use the _____ control when you want to link two reports together in the same report.

An Append query adds selected records to an existing table.

After setting up a Delete query, you delete selected records by clicking the _____ button.