Exam 1: Access 2019

The Recordset Type property determines whether Access locks or allows updates to records displayed by a query.

To set the Validation Text property for a table in Table Design view, you use the _____.

To replace "coffee" with "beverage" in any part of a field, you click the _____ in the Find and Replace dialog box.

You use conditional formatting to highlight important data in a report.

The Allow Value List Edits property determines whether users can change the items in a lookup list.

How can you display the title of a report in green?

What happens when you run a query with the Is Null criterion in the Product Type field?

The Import Spreadsheet Wizard can help you import data from Excel into a new Access table.

In a macro, a Group component lets you sort macro arguments.

Clicking in the vertical ruler in Report Design view selects _____.

If you want to remove records for discontinued products from a Products table, create a(n) Update query.

What criterion would you use to find numbers greater than or equal to 100?

You can add fields to a form in Design view or _____.

You can create a database by using an Access _____ or by starting with a blank database.

Entering _____ in the Column Width property for a combo box sets the width of the first column to 0.5" and the width of the second column to 2".

To display the VBA code for a form, click the Build button in one of the form's event properties.

Tab order refers to the order you added tabbed pages to a tab control.

What types of errors occur only after you start running the code in the Visual Basic window?

A macro is an Access object that stores Visual Basic for Applications (VBA) programming code.

When you split a database, the back-end database contains all of the queries, forms, and reports in the database.