Exam 1: Access 2019

When you create a form using the Blank Form tool, the _____ property is blank.

To navigate records in Form view, you use the buttons on the _____.

How do you specify an outer join between two tables?

Set the Append Only property to _____ to allow users to add data to a Long Text field but not to change or remove existing data.

After you split a database, what does the back-end database contain?

A(n) self join selects all the records from the "one" table regardless of whether there is a related record in the "many" table.

What Access tool helps you import a CSV file as a new Access table?

Use the Move up and Move down buttons to move macro actions in Macro Design View.

Create a Top Values query to find the highest values in set of unsorted records.

Using the incorrect spelling of a VBA keyword is an example of a _____ programming error.

You can set a startup option to show or hide the Navigation Pane itself.

Which of the following is a comment you could add to a VBA procedure?

Use the Default field property to specify that an entry is required for the field.

Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.

To make some commands such as ShowToolbar and PrintOut available to a macro, you must first click the Show All Actions button on the Macro Tools Design tab.

When you _____ data to a table, the column names in the Excel spreadsheet must match the field names in the Access table.

Which data type is used for sequential integers controlled by Access?

When you use the _____, Access asks you for the information it needs to create a query.

In a split form, the upper half shows one record of data while the lower half lists records in a datasheet presentation.

Which data type stores email addresses?