Exam 8: Access

Which of the following pages numbers is displayed in the "Page N of M" format?

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

After editing a procedure, click the Reset button to execute the procedure.

To add totals to a report column in Report Design view, you create a calculated control.

Use a Long Text field when you need to store more than 256 characters in a field, such as for comments, reviews, or notes.

What should you do when you are finished working with a database?

To add VBA code to a macro embedded in a report, you can first _____ the macro to VBA code.

Why would you set the Limit to List property to No for a lookup field?

ToWhat tool do you use to set the sort orders for records in a report?

A style is a predefined format such as a set of fonts, colors, and alignment, that you can apply to reports and forms.

Which of the following tasks is a good candidate for a macro?

Set the Append Only property to _____ to allow users to add data to a Long Text field but not to change or remove existing data.

An XML file is a text file containing Extensible Markup Language tags that identify field names and data.

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

To delete a field from a query in Query Design view, click the _____ for the field, and then press DELETE.

Which of the following are controls you can add to a form in Form Layout view? Select all the options that apply.

How can you add a field to the query grid in Query Design view? Select all the options that apply.

Compacting a database has the same result as backing up a database.

Use a Size option when you want to specify the exact height and width of two selected controls.

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