Exam 1: Access-2019

What Access tool should you use if the path to the back-end database changes and you need to reconnect the front-end and back-end databases?

What happens if you delete a row from the query design grid?

Where can you set a field's Default Value in Table Design view?

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

You use the Field List to add fields to a form in Form Design view.

To align the edges of multiple controls in Form Design view, you use the Align button on the _____ tab.

A macro always performs all the actions in an If program flow.

What must you use in a macro that performs an action if an employee's salary is greater than $50,000 and the performance rating is greater than 5?

What happens when you apply a theme to a form?

The On _____ event occurs when focus moves from one record to another.

To delete an action from a macro, point to the action in Macro Design View, and then click the Delete button.

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

If a form displays data from the Clients table, you could change the form's Record Source property to _____ to display different data.

Set the _____ startup option to add a custom title to the title bar instead of the database name and path.

Use a Number field to store values that represent money.

To set a command button to be a hyperlink in Form Design view, you change the button's _____ property.

Why is it easy to import XML data into an Access table?

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

A(n) _____ file is a text file containing Extensible Markup Language tags that identify field names and data.

The Validation Rule and _____ properties help prevent users from entering unreasonable data in the database.