Exam 1: Access 2019

To learn about the new features in Access, you can use the Tell Me box.

Which of the following criteria selects records for customers except those who live in New York, even if the City field is blank?

What can you add to a macro to test logical conditions and execute statements only if the conditions are true?

The only way to create a Crosstab query is to use the Crosstab Query Wizard.

What property would you set for a field with a Yes/No data type that usually stores a Yes value?

To navigate to the first record in a form, first switch to Form Design view.

Before deleting a query, you can view its _____ to determine if any other queries, forms, or reports depend on that query.

_____ fields allow you to make more than one choice from a field's lookup list.

Use the Number data type for fields that store postal codes.

An aggregate function is _____.

To select more than one control in Form Design view, you _____ and then click each control.

When you import Excel data, you create a link to the data in the Access database.

Which field property do you use to change a lookup field to a regular field?

To change the background color of a form control in Form Design view, you use the _____ button.

You reference a submacro in a macro list using the command Submacro().

Number fields store values that represent quantities, measurements, and scores, for example.

Which of the following can you change when formatting a datasheet?

What property would you use in an If statement to display a label in some records but not others?

To display the contents of a text box in more than one font size or color, set the _____ property of the text box to RTF.

A chart is a visual representation of numeric data that helps users see comparisons, patterns, and trends in the data.