Exam 1: Access 2019

To close an object such as a form or report while keeping the database open, you _____.

Hanna created a backup table listing renters in Springfield County, and now wants to add records to that backup table from the Rentals table for renters in Lincoln County. What type of query should she create to accomplish this?

If you want to increase the price of products in a particular category by 10%, use a(n) Append query.

If you delete the text box for the State field on a form, Access removes _____.

Why would you create a function in a standard module?

When a record from one table is related to several records in another table, the tables have a one-to-many relationship.

As with other action queries, the icon for an Append query includes a(n) _____ to remind you that it changes data when you run the query.

To rename a table, you must use the Navigation Pane.

Which of the following field properties can you set to help users enter phone numbers by providing a pattern for the number?

Which VBA keyword(s) do you use to declare the name and arguments that create a new function procedure?

When you use the _____, Access asks you for the information it needs to create a query.

When you start Access, the first screen that appears is one showing a blank database.

To delete a field in Table Datasheet view, you click _____.

When you sort on two fields in Query Design view, the sorted fields must appear next to each other in the query grid.

To apply a combination of formatting options to a form control in Form Layout view, you can use the Quick Layout button.

What button do you use on the Query Tools Design tab to add a field list to a query?

In _____, you define or modify a table structure and the properties of the fields in a table.

Access provides a single method to encrypt the database and _____ at the same time.

Use the Move up and Move down buttons to move macro actions in Macro Design View.

You can set the Field Size property for a field with a Short Text data type.