Exam 8: Access

If you select 25 in the Top Values list, Access displays _____ in the query results.

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

A database in a trusted folder enables all database content, including all macros and VBA.

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

A Make-Table query is a type of action query that creates a new table of data.

If the Quantity field has "< 50" as its validation rule, and a user tries to enter "100" in the field, Access displays the message in the _____ property.

When you copy data from an Access query to a new delimited text file, you are _____ the data.

When you apply the Currency format to a field, Access displays a currency symbol and two values after the decimal point, but it does not change the field's data type.

When you import Excel data, you create a link to the data in the Access database.

The first step in the Form Wizard is to _____.

In Report Design view, you add a field to a report using the _____.

(999)000-000;1;_ would be a possible entry for which field property?

To select records in the Sales table that have no related records in the Customers table, create a(n) _____ join.

Which of the following options for creating a form can you access on the Create tab? Select all the options that apply.

To allow users to enter more than one value in a field, you set the Allow Multiple Values property to Yes in the _____ in Table Design View.

Which of the following statements are true about subdatasheets? Select all the options that apply.

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

Which of the following are benefits of using macros? Select all the options that apply.

When you select a control in Form Design view and then press an arrow key, you _____ the control.

When you _____ data to a table, the column names in the Excel spreadsheet must match the field names in the Access table.