Exam 1: Access-2019

Sorting a table datasheet temporarily displays only those records that match given criteria.

To set the validation text for a table in Table Datasheet view, you use the _____ button on the Table Tools Fields tab.

Which startup command-line option opens the database for exclusive access?

If you set 100 as the Default Value property for the Rate field, 100 is inserted in the Rate field for all new records only.

Use the New (blank) record button to move the focus to the first record in a table.

What is the result of selecting four text boxes, clicking the Size/Shape button on the Arrange tab, and then clicking To Narrowest?

You must specify arguments for each action in a macro.

Which of the following report controls can you format in bold?

Compared to forms and datasheets, ____ give you more control over how data is arranged when printed.

Which of the following form controls would you use to display a border around other controls?

Before you can rename a field, you must change its data type.

To rename a form, open the form, and then use the Rename command on the Home tab.

When building a conditional expression that refers to a value in a form control, use the syntax called _____.

To center the text in a selected form control in Form Layout view, you _____.

You use the Performance Analyzer to analyze tables only.

_____ view provides the most options for defining fields.

Class modules most commonly run in response to an event, such as a user clicking a command button.

To close a query from SQL view, you can _____.

The _____ property indicates which field serves the link between the main form and subform.

In a macro, arguments provide _____.