Exam 8: Access

You can make formatting changes to a table, such as font color and font size, in Table Design view.

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

A relational database can best be described as a collection of related _____ designed to minimize redundant data.

To navigate to a record in a table, switch to Table Design view.

Which of the following types of tables can you create from an Application Part? Select all the options that apply.

Which of the following is the most common type of bound control you can add to a form?

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

Which of the following controls has an After Update event property?

In a macro, a(n) _____ results in a true or false value.

The part of an If statement that is evaluated as either true or false is called a(n) _____.

To set the validation text for a table in Table Datasheet view, you use the _____ button on the Table Tools Fields tab.

The text you specify for the Application Title property appears in the title bar instead of the database filename.

Which of the following controls can you add to a form to clarify or organize form data? Select all the options that apply.

Besides reducing file size, what other benefit does compacting an Access database provide?

In Report Design view, you display a Number field value as a percentage using the _____ property.

Of all the database objects, a table provides the most formatting, layout, and summary options.

As with other action queries, the icon for an Append query includes a(n) _____ to remind you that it changes data when you run the query.

A control layout in an Access report is a ____.

The Alternate Background Color command changes the background color of alternate records in a selected section.

What is the most efficient way to navigate to the last record in a table containing 100 records?