Exam 1: Access-2019

Dynaset is the default value of the _____ property in a query; it lets you update data in the query recordset.

In Report Layout view, you can edit data but not labels.

To use the Command Button Wizard, the _____ button must be toggled on.

If you want Access to create a top-to-bottom and left-to-right tab order, click _____ in the Tab Order dialog box.

Class modules are stored in an individual form or report.

Heather set the Required property for the GameDate field in the Soccer database, which means users must enter the date with a proper date format, such as June 20, 2021.

How can you display "Product Description" in a table datasheet for a field named "ProdDesc" without renaming the field?

In a macro's conditional expression, you refer to a value of a form control using the following syntax: ____.

When you type a password in the Set Database Password dialog box, _____ appear instead of the characters you typed.

Actions you take in Query Design view automatically update in _____.

A(n) _____ chart typically shows cumulative totals, such as combined sales totals for store locations.

Where do you manage data macros in Access?

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

You can change the margins of a report using the Margins button on the Print Preview tab.

When using the Form Wizard, you can select fields from tables and _____ in the database.

You might delete an employee record if the employee no longer works for the company.

A combo box is a combination of a text box and command button.

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

What criterion would you use in the LastName field to find records that do not contain a last name?

A macro is an Access object that stores Visual Basic for Applications (VBA) programming code.