Exam 8: Access

What is the result of using the Database Documenter?

To add, delete, or change fields in a query, you use Query Design view.

What property should you set to have the Department header section appear at the top of every printed page?

What criterion should you use in the Bedrooms field to select records of houses for sale with exactly four bedrooms?

To close a query from SQL view, you can _____.

Which button on the Form Design Tools Arrange tab do you use to remove a tabular layout from a form?

Why would you create a function in a standard module?

The difference between importing and exporting data is largely based on the type of data that is being copied.

Which of the following import options means data is not copied from Excel to Access, but stored in the original workbook?

Which of the following form controls works as a text box that provides a list of possible values for a field?

You can convert a form label to a hyperlink using the control's Web property.

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

To use HTML tags to format text in a text box, first set the Text Format property of the text box to _____.

You can assign a key combination to a macro by creating a macro with the name _____.

Use >500 as the criterion for a Number field in a query to select records with a value less than 500 in that field.

To format a number with a dollar sign ($) as in $50.99, use the Standard format.

Where do you set the Allow Multiple Values property of a field in Table Design view?

In Form Layout view of a navigation form, you can double-click the navigation button to _____.

One reason to split a database is to improve performance.

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