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.