Exam 1: Access 2019

The Form Wizard prompts you for information it needs to create a form, such as the fields, layout, and title for the form.

How can you move a selected report label with the most precise control in Report Layout view?

In Table Design view, "State must be AZ or CO" is an example of integrity text.

The tab order is the order the focus moves from control to control when a user presses TAB.

Suppose you rename a field in Table Design view. What must you do before you can view the data in the table?

To import data from Excel to Access, you would begin by clicking the ____.

Database templates create tables and queries, but not forms and reports.

Which Short Text field property should you use to indicate users must enter a value in the field?

In Query Design view, you can right-click the join line between two field lists and then click Join Properties to change the join type.

When exporting to XML, Access creates a separate _____ file that defines the structure of the XML file.

The Action Catalog lists all of the macro actions organized by category.

To arrange form controls in a layout of rows and columns like a spreadsheet, select the controls to group together, and then click the _____ button on the Form Layout Tools Arrange tab.

Each row in a table datasheet displays a _____.

When you select a control in Form Design view and then press an arrow key, you _____ the control.

To select more than one control in Form Design view, you _____ and then click each control.

How does VBA treat comments when you run the code in the Visual Basic window?

What type of query should you create if you want to change a manager's name from "Jones" to "Ames" for all selected records?

By default, the objects you create in a database are formatted with the Normal theme.

When you create a form containing data from two tables that have a one-to-many relationship, what type of form are you creating?

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