Exam 1: Access 2019

What happens when you close a module?

To create a banded rows effect in a report, you _____.

If you set the _____ property for a field that is often used for sorting, you improve database performance.

You can add rows to the query grid, but you cannot delete them.

To remove filter criteria from the Filter by Form grid, you _____.

Alan created a lookup field with two columns and wants to narrow the first column. Which property should he select on the Lookup tab in Table Design view?

A macro may contain one or more _____, the tasks that you want Access to perform.

Table Design view shows how each table relates to other tables in the database.

In Report Layout view, you can work with sections and make changes that you cannot make in other views.

To relate two tables in a one-to-many relationship, you connect them using a common field.

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

In a SaleDate field, you can display dates as 03-Jan-21, for example, by selecting Medium Date as the _____ property.

Which of the following form controls could have an After Update event property that triggers a Sub procedure?

To create a _____, you add the Total row to the query design grid to specify how to group and perform calculations on the records.

_____ modules are displayed as module objects in the Navigation Pane.

What is the difference between entering a record using a form and entering a record using a datasheet?

If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid?

What data type should you assign to a WeeklySalary field?

The difference between importing and exporting data is largely based on the type of data that is being copied.

In SQL view, a select query starts with the SQL keyword _____.