Exam 1: Access 2019

A function created in a standard module can be used in any query in the database.

Kendra is working in Form Design view and sets the On Current property for a form to [Event Procedure] so that a VBA procedure runs when the focus shifts to the next record in the form. How can Kendra display the procedure from Form Design view?

You can add one or more _____ to a tab control.

You can use a report to enter a record into the database.

You can display page numbers on a report in a "Page 1 of 2" format.

To navigate to a record in a table, switch to Table Design view.

A category of data such as a customer's name, city, state, or phone number is called a _____.

What do you change when you drag the right border of a form in Form Design view?

A group of related fields, such as all the demographic information for one customer, is called a _____.

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

After using the Performance Analyzer, you can open the Relationship window to see the tables and relationships it created. Which symbol identifies the primary key field?

Set the Append Only property to _____ to allow users to add data to a Long Text field but not to change or remove existing data.

How do you display the records in a subdatasheet?

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

In VBA, comments appear in _____ text.

When you attach a macro to the _____ property for a form, the macro actions run when the form opens.

The Alternate Background Color command changes the background color of alternate records in a selected section.

Access automatically creates an index for the _____.

Use a(n) If statement to document a macro with explanatory text.

Before you close a database, you must save any changes you made to the data.