Exam 1: Access-2019

The _____ is the wildcard character that stands for any single character in criteria.

What could you use to display the amount of a 25% discount on a form?

If a blank column of controls appears next to a column of fields in a control layout, you can _____ the columns to create a single column.

For a Comments field that contains many words, set a Long data type.

A common way to run a macro is to assign it to a command button.

To apply the last filter you selected to a datasheet, you click the _____ button.

You can assign a key combination to a macro by creating a macro with the name _____.

Which of the following controls has an After Update event property?

You can manage default startup options using features in the _____ category of the Access Options dialog box.

If you export form data as a(n) _____ file, you can view the data but not change it.

Because the _____ section prints once for each record in the record source, you often shorten the section in Report Design view.

When you add a Yes/No field in Report Design view, what control(s) does Access typically add to the report?

To set the properties for an entire table, open the table's property sheet in Table Design view.

Which process is most like copying and pasting?

A Make-Table query is a type of _____ query that creates a new table of data.

In Table Datasheet view, a(n) _____ shows the records on the "many" side of a one-to-many relationship.

To create a single-value lookup field in Table Design view, you use the _____ in the Field Properties pane.

Which Recordset Type property value should you set for a query to prevent data from being updated?

After Update is a typical event for a table macro.

You can create a database by using an Access _____ or by starting with a blank database.