Exam 1: Access 2019

In Form Design view, you can make design changes while displaying the data.

When you split an Access database, what do you call the database containing all the tables?

You can create a comment by starting the statement with _____.

You use _____ to mark up structured data so you can easily share the data with other programs.

The_____ Lookup property determines whether a lookup field accepts new values or only those in the lookup list.

For a table, the _____ produces a report listing the field names, property values for each field, and table relationships.

Use a(n) If statement to document a macro with explanatory text.

Joe adds the ClientName and ProjectID fields to the query grid. To find records without values in the ProjectID field, he can use Is Null as the criterion for the ProjectID field.

What must you do before setting a database password?

Run the steps in a saved export using the _____ button on the External Data tab.

On a form, you use Edit view to enter, edit, and delete records.

In Query Design view, the _____ shows you the field names, sort orders, and criteria used with a query.

Which of the following criteria uses the correct syntax for a Date/Time field in a query?

The text you specify for the Application Title property appears in the title bar instead of the database filename.

To run the code in the Visual Basic window, you click the Run button on the Standard toolbar.

In a Date/Time field named HireDate, the validation rule expression >#7/1/21# means _____.

Why would you create a function in a standard module?

What data type is most appropriate for a field named SquareFeet?

_____ are a series of commands that execute when the database opens.

After you hide a field in a datasheet, you can redisplay the hidden field using a shortcut menu.