Exam 1: Access 2019

When you select a control in Report Design view, you can use _____ to resize the control.

The purpose of a Delete query is to _____.

To move a field in Table Datasheet view, you select the column and then _____.

You use the _____ property of a query to document the purpose or author of the query.

Which of the following views gives you give you the most control over the placement and sizing of report controls?

After creating a macro, you can copy it to VBA.

Laura created a multivalued lookup field named Degrees using the Lookup Wizard. She wants to check the settings for the Degrees field in Table Design view. Which field property indicates Degrees is a multivalued field?

If you create a function in a standard module, it applies only to the current object.

Append queries are most often used to add records to _____.

Use the Default field property to specify that an entry is required for the field.

You use the Filter By Selection feature to sort and filter records at the same time.

You could use a(n) action query to delete all paid bills from last year.

To perform calculations on field values in Table Datasheet view, you click the Totals button in the Records group on the Home tab.

_____ are properties of an action that provide additional information on how the action should execute.

When you set a _____ for a table, you create an expression that restricts the values that users can enter into a record.

How can you enlarge the Detail section of a form in Form Design view?

A(n) _____ is a specialized template for a specific database object that can be imported into a database.

When updating a database, Roseanne set a startup option to display a navigation form when the database opens. How can she bypass that option the next time she opens the database?

In Report view, you can display the report data as you add lines for subtotals to the report.

After you split a database, what does the back-end database contain?