Exam 9: Exploring Financial Tools and Functions

A Make-Table query is a type of _____.

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

Which of the following join types can you create by double-clicking a join line in Query Design View? Select all the options that apply.

A(n) _____ query changes the values in a field.

When building an action query, you do not change data until you click the _____ button.

What happens if you delete a row from the query design grid?

The outer join is the default join operation in Access.

Which of the following are action queries? Select all the options that apply.

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

Using an Append query, you can append a Short Text field from one table to a Number field in another table.

You can add rows to the query grid, but you cannot delete them.

_____ criteria are two or more criteria on the same Criteria row of the query design grid.

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

As you add AND criteria to the query design grid, you increase the number of records selected for the resulting datasheet.

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

Table Design view shows how each table relates to other tables in the database.

An Append query adds selected records to an existing table.

After setting up a Delete query, you delete selected records by clicking the _____ button.

Which action query would you use if you wanted to add records from one table to a backup table?

How do you specify an outer join between two tables?