Exam 8: Access

How do you enter more than one value in a multivalued lookup field in Table Datasheet view?

To select a control layout in Form Design view, you _____, and then click the plus sign icon to the left of the layout.

What are you doing when you enter data into a subdatasheet?

When you use the Chart Wizard to add a chart to a report, your first step is to select _____.

When you change a select query to an Update query, Access displays the _____ row in the query design grid.

Which of the following are formats you can apply to a Date control in Report Layout view? Select all the options that apply.

The join line between the Appointments and Treatments tables has an arrow pointing to the Treatments table.What join type does this indicate?

To decrease the decimal places in a Number field in Table Datasheet view, you can use the Decrease Decimals button.

If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid?

_____ are a series of commands that execute when the database opens.

You must use the correct _____, or rules, when creating a VBA statement.

Which of the following statements are true about one-to-many relationships? Select all the options that apply.

A new blank desktop database includes one table named Table1.

The upper pane of _____ view shows field names and data types.

A(n) _____ macro allows you to embed macro capabilities directly in a table to add, change, or delete data based on conditions you specify.

Which of the following are possible entries for the Field Size property of a Number field? Select all the options that apply.

In a datasheet, which mode do you use for changing the value of a field?

What do you change when you drag the right border of a form in Form Design view?

To create an Update query in Query Design view, you use the Add to row in the query design grid.

When you click the Application Parts button on the Create tab and then click Issues, you create a new database named Issues.