Exam 1: Access 2019

Which of the following controls would you use to display a Yes/No field on a form?

To select records in the Sales table that have no related records in the Customers table, create a(n) _____ join.

In VBA, comments appear in _____ text.

For a Comments field that contains many words, set a Long data type.

A _____ is a saved object within the database, whereas a _____ is temporary.

In Table Datasheet view, you must use a property sheet to increase the decimal places in a Number field.

A Make-Table query is a type of _____ query that creates a new table of data.

In the _____, Access lists each object in the open database.

You might delete an employee record if the employee no longer works for the company.

You can assign a key combination to a macro by creating a macro with the name _____.

You can display numbers on a report in Currency, Percent, or Standard formats.

The Display Control property of a _____ field is set to Combo Box by default.

The _____ property displays a value that is automatically entered in the field for

If most records will contain "NY" in the State field, enter _____ as the _____ property for the State field.

If you edit data in the upper half of a split form, you must make the same changes in the lower half.

Which of the following layouts can you use to arrange form controls?

Which of the following controls would you use to describe another control on a report?

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

To allow users to enter more than one value in a field, you set the Allow Multiple Values property to Yes in the _____ in Table Design View.

What Field Size should you set for a State field that stores two-character state abbreviations?