Exam 1: Access-2019

When you delete a control from a form, you also delete the data it contains.

Which two properties control how a form and subform are linked?

When you click the first value in a column in Report Layout view, what are you actually selecting?

What must you do before renaming a table in the Navigation Pane?

A group of related fields, such as all the demographic information for one customer, is called a _____.

A category of data such as a customer's name, city, state, or phone number is called a _____.

Before you can edit actions in Macro Design View, you might need to click the Expand All button on the Macro Tools Design tab to display all the actions.

If the _____ property for a form control is set to No, the control cannot have the focus in Form view.

How can you enlarge the Detail section of a form in Form Design view?

What happens if you delete a field from a table that contains data?

Using the incorrect spelling of a VBA keyword is an example of a _____ programming error.

OpenReport is an Access macro _____.

Besides changing the width of a report, what else can you do if a report is too wide for an 8.5-x-11-inch page in Report Layout view?

To query for null values, use Is Null as the criterion.

What happens when you run a query from Query Design view?

The _____ organizes all the arguments for an action in a rectangle with a gray background.

You use the Find Unmatched Query Wizard to find records in one table that do not have related records in another table.

You must add actions to a macro in the order you want Access to evaluate them, starting at the bottom.

____ makes a duplicate copy of the data in the Access database.

Which of the following does NOT save changes made to a record?