Access Chapter 6

A crosstab query works best when the data source has at least two grouping fields.

true

Action queries display different icons than select queries in the Navigation Pane.

true

Action queries include update, append, make table, and delete.

true

An action query can be used to add, edit, or delete data in a database.

true

An append query is used to add records to an existing table.

true

Backing up the database prior to running an update query is the best precaution.

true

Choosing the wrong matched field in an unmatched query will cause you to query incorrect information.

true

It is important to ensure that when you delete duplicate records, you do not delete associated records in a related table.

true

It is recommended to preview results before running a delete query.

true

It is usually better to enter the value of zero rather than have a null value in a field.

true

Moving records from one table to another can be accomplished with the combination of an append query and a delete query.

true

Once you run an action query, you are committing yourself to an irreversible change.

true

One reason an append query can fail is because of duplicate primary keys in the source and destination tables.

true

Prior to updating data in a table, you must first locate the records that need to be modified.

true

The delete query saves you the chore of having to locate and delete records manually.

true

The find unmatched query only works if two tables share a common field.

true

The find unmatched query requires two tables with a common field where one of the tables is missing information.

true

The grouping in a crosstab query comes from the definitions of row and column headings.

true

The type of data displayed in a crosstab query depends on which aggregate function you choose when creating the query.

true

When running a delete query, you are prompted with a warning message.

true

When running an append query, an append query warning message appears specifying the number of rows to be appended.

true

When updating records, convert the select query to an update query and insert the missing information.

true

You can use a make table query to copy some or all records from a source table to a destination table even if the destination table does not exist.

true

You should NOT rerun an action query.

true

A(n) ________ query is used to update or change data automatically based on criteria that you specify.

update

A(n) ________ can be used when records with missing data have been found.

update query

A(n) ________ would be used to replace null values with zeros?

update query

Moving records from one table to another can be accomplished with the combination of what two types of queries?

Append and delete

The process of creating a make table query is very similar to which other type of query?

Append query

Which type of query calculates data using a sum, average, or other function and groups the results by two sets of values?

Crosstab query

What do you do if you make a mistake when running a Find Unmatched query?

Delete the query and start over, then reverse the order of the tables.

How is a crosstab query different from other queries?

You can only reference one object (table or query) as the data source

When running an append query, the data types of the source fields do not have to match the data types of the destination fields.

false

You can use Undo when running an update or delete query.

false

Why should you backup your database before running an action query?

Action queries are irreversible.

Why should you backup your database before testing an action query?

Action queries change data in your database that cannot be reversed.

To avoid a mistake when using an update query that includes making calculations on a field, what is one thing you can do to prevent losing the original information?

Add an additional field with the original figures.

Where do the row headings display in a crosstab query?

Along the left side of a crosstab query

Where do the column headings display in a crosstab query?

Along the top of a crosstab query

What should be the first step taken before creating an update query?

Back up the database

After becoming familiar with the data in a database, what should be the first step when creating an action query?

Backup the database

What is the first step in creating an append query?

Create a select query

What summarizes a data source into a grid of rows and columns?

Crosstab query

Which of the following is NOT a rule for appending queries?

Data field types do not have to be the same.

Which query identifies multiple instances of the same information in a table?

Find duplicates

To test an update query before running the query, what should you do first?

From Design view, click View in the Results group and click Datasheet view.

Which type of query automatically creates a new table from data that already exists in a database?

Make Table

Before running a delete query, what should you do?

Preview the datasheet to verify that the records are those that you intend to delete.

Before running a make table query, what should you do?

Preview the datasheet to verify that the records are those that you intend to insert into the table.

If you run a make table query again at a later time, what happens?

The table is replaced with the new up-to-date table.

When running an append query, what happens if a record violates the primary key rule for the destination table?

The record is rejected.

What is the purpose of a find unmatched query?

To compare records in two related tables and display the records found in one table and not the other.

What must be present for a find unmatched query to work?

Two tables share a common field.

Once records with missing data are found, what type of query can you use to add the needed information?

Update

What does the type of data displayed in a crosstab query depend on?

Which aggregate function used when the query was created

A(n) ________ query can be used for adding records to an existing table.

append

An append query is a query that:

copies records from one table to another.

A(n) ________ query removes records from a table based on criteria that you specify.

delete

Duplicate values in a table can prevent you from:

enforcing referential integrity.

A delete query automatically creates a new table from data that already exists in a database.

false

A find duplicates query compares records in two related tables and displays the values found in one table but not the other.

false

A find unmatched query compares records in two related tables and displays the records found in both tables.

false

Access does not have a way to identify duplicate values.

false

An append query changes the data values in one or more fields for all records that meet specific criteria.

false

An append query deletes records from one or more tables and adds them to an existing table.

false

An append query is used to update or change data automatically based on criteria that you specify.

false

An append query selects records from one or more tables and uses then to create a new table.

false

Duplicate values should always be deleted from a database table.

false

Find unmatched queries provide a subset of the data that answers most questions that users ask about the data in their databases.

false

If the destination table exists and you run the make table query, Access automatically deletes the source table.

false

It is not recommended to preview the datasheet prior to running a make table query.

false

There is no way to verify that the correct records will be updated when using an update query.

false

A(n) ________ query can be used to archive older records that need to be stored outside of the current table.

make table

To test an update query before running it, you can:

switch to Datasheet view.