Exam 1: Access 2019

Use the _____ to exit Access.

When using the Form Wizard, you can select fields from tables and _____ in the database.

If a blank column of controls appears next to a column of fields in a control layout, you can _____ the columns to create a single column.

____ makes a duplicate copy of the data in the Access database.

Where do you manage data macros in Access?

Which of the following views should you use to modify the size, position, and formatting of report controls while displaying live data?

A report is an easy-to-use data entry and navigation screen.

Which argument of the MessageBox macro action determines the text in the title bar of the message dialog box?

When Molly inserts a label control on a form in Form Design view, the label displays Text12. Which property can she change for the label so it displays the text Listing Date?

Which of the following changes makes a datasheet easier to read?

When you click the Delete button in the Query Type group, Access adds the Update row to the query design grid.

You must add actions to a macro in the order you want Access to evaluate them, starting at the bottom.

What should you do if you want to make a copy of a database in a secure location?

If you set the Visible property of a form's label control to Yes, the label does not appear in Form view.

Standard modules are also called universal modules.

For two tables that have a(n) _____ join, a query will select all the records in the "one" table even if they do not have matching records in the "many" table.

In which object can you rename a field?

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

Which of the following could you use to export records to a new table?

When you create a(n) _____ query, the value the user enters in the dialog box determines which records the query displays in the results.