Exam 1: Access 2019

When report controls appear in a control layout, you can change the type of control layout, but you cannot remove it.

You might want to create a function to calculate a value based on your company's unique business rules.

You can create a table in Table Datasheet view or Table Design view.

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

A(n) _____ is an individual step that a macro performs.

When you export an Access table to a(n) _____ file, you have the option to preserve the formatting and layout of the table.

For bound controls such as text boxes, the _____ property value often matches the field name.

Horizontal Tabs is a navigation system theme that determines how the navigation buttons are displayed on the form.

How do you start the Performance Analyzer?

Which of the following templates lets you create a database from scratch?

Which two properties are required for every field?

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

To back up a database, you use the _____ command.

(999)000-000;1;_ would be a possible entry for which field property?

In the Visual Basic Editor, the Object window is where you create, modify, and display VBA procedures.

A _____ is a predesigned database that includes professionally designed tables, reports, and other database objects.

Press ESC to remove editing changes you made to the previous record.

When you open a database using the Open dialog box, the default setting is _____.

After starting Access, which of the following is the fastest way to open a database you worked on yesterday?

A _____ typically shows all the fields for one record on a single screen for data entry and editing.