Exam 1: Access 2019

You can select one or more option buttons at the same time within an option group.

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

A common example of delimited text file is a PDF file.

_____ means to make the data in a database unreadable by other software.

When a module is embedded in a form or report, it is called a(n) _____.

Each row in a table datasheet displays a _____.

If you used D*n as the criterion in a Short Text field called FirstName, what would appear in that field in the query results?

When does the After Update table event run?

You can assign most but not all data types to a field in Table Datasheet view.

The Enabled property specifies whether you can edit a control in Form view.

In the criterion 8/*/2021, the asterisk (*) is called a wildcard.

Access displays your user account information in the Navigation Pane.

Use >500 as the criterion for a Number field in a query to select records with a value less than 500 in that field.

When you add actions to a Group program flow, the macro does not perform the actions.

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

A _____ allows you to arrange the fields of a record in any layout so a database user can quickly and easily find, enter, edit, and analyze data.

If you want the State field to display "Iowa" in each new form record, you set the Control Value property for the State field.

In Form Layout view of a navigation form, you can double-click the navigation button to _____.

The Lookup Source property stores the values that are provided in the list for a Lookup field.

Which of the following import options means data is not copied from Excel to Access, but stored in the original workbook?