Exam 1: Access 2019

Which of the following events would trigger a data macro?

A check box and a command button display "yes" or "no" answers in a field.

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

Which of the following form controls works as a text box that provides a list of possible values for a field?

Which two properties control how a form and subform are linked?

You can format a table datasheet by setting the alternate record color in Table Datasheet view.

Which of the following is the SQL keyword to identify tables containing the field(s) you are selecting?

You use the _____ to create a query that finds records in one table that do not have related records in another table.

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

A function created in a standard module can be used in any query in the database.

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

Use a Long Text field when you need to store more than 256 characters in a field, such as for comments, reviews, or notes.

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.

Where do you paste a copied query?

You use the Field List to add fields to a form in Form Design view.

To change the text displayed on the report tab, use the report's Caption property.

An advantage of emailing query results as a PDF file is that _____.

A form ____ is the general way that the data and controls are arranged on the form.

You can freeze one or more fields in a datasheet so they remain visible at all times.

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