Deck 6: Action and Specialized Queries: Moving Beyond the Select Query

Question 1

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

A) Data field types do not have to be the same.
B) All the normal rules for adding a new record to the destination table apply.
C) A field from the source table does not exist in the destination table.
D) The destination table should not contain an AutoNumber field.

Answer 1

A

Question 2

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

A) Action queries are irreversible.
B) Action queries are reversible.
C) Action queries are temporary.
D) Action queries add extra tables to the database.

Answer 2

A

Question 3

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

A) Update
B) Delete
C) Make table
D) Find duplicates

Answer 3

A

Question 4

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

A) make table
B) update
C) delete
D) append

Question 5

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

A) append
B) update
C) make table
D) delete

Question 6

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

A) The record is rejected.
B) The original record is selected.
C) The record is added without the primary key field.
D) The append query is rejected.

Question 7

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

A) Make Table
B) Update
C) Append
D) Delete

Question 8

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

A) The table is replaced with the new up-to-date table.
B) The new table will show as it was when it was created.
C) All new information is lost.
D) It will select the new records from the table and delete them.

Question 9

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

A) update query
B) append query
C) delete query
D) make table query

Question 10

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

A) Append and delete
B) Append and make table
C) Append and select
D) Append and update

Question 11

What is the first step in creating an append query?

A) Create a select query
B) Create a make table query
C) Create a delete query
D) Create a find duplicates query

Question 12

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

A) Back up the database
B) Switch to Datasheet view
C) Move the records to a different table
D) Run the query

Question 13

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

A) From Design view, click View in the Results group and click Datasheet view.
B) From Design view, click the Run button.
C) From Design view, verify that all fields are listed.
D) From Design view, click Update in the Query type group.

Question 14

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

A) Append query
B) Delete query
C) Find duplicates query
D) Update query

Question 15

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?

A) Add an additional field with the original figures.
B) When you run the query, just undo if you question the new figures.
C) Rerun the query to make sure the figures have updated.
D) Backup the database after you have run the query.

Question 16

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

A) update
B) append
C) make table
D) delete

Question 17

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

A) delete
B) append
C) update
D) make table

Question 18

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

A) switch to Datasheet view.
B) run an append query first.
C) backup the database.
D) move the records to a different table.

Question 19

An append query is a query that:

A) copies records from one table to another.
B) changes the data values in one or more fields that meet specific criteria.
C) automatically creates a new table from data that already exists.
D) removes records from a table based on criteria.

Question 20

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

A) Action queries change data in your database that cannot be reversed.
B) Action queries change data in your database but the changes are temporary.
C) Action queries do not make any changes to your database.
D) Action queries duplicate data in your database.

Question 21

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

A) Preview the datasheet to verify that the records are those that you intend to insert into the table.
B) View the results in Design view.
C) Create the table, you can always delete it if the information is wrong.
D) Create a delete query at the same time.

Question 22

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

A) Crosstab query
B) Append query
C) Make table query
D) Find duplicates query

Question 23

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

A) update query
B) make table query
C) append query
D) delete query

Question 24

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

Question 25

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

A) Delete the query and start over, then reverse the order of the tables.
B) Rerun the query using different fields.
C) Delete associated records in the table.
D) Modify the aggregate function.

Question 26

Before running a delete query, what should you do?

A) Preview the datasheet to verify that the records are those that you intend to delete.
B) View the results in Design view.
C) Create the table, you can always delete it if the information is wrong.
D) Manually go through the table and delete the information, then use the delete query to verify all information is removed.

Question 27

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

Question 28

Where do the column headings display in a crosstab query?

A) Along the top of a crosstab query
B) Along the left side of a crosstab query
C) Along the right side of a crosstab query
D) Along the bottom of a crosstab query

Question 29

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

Question 30

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

A) Backup the database
B) Save the database in an earlier version
C) Using design view, create the query
D) Run the query

Question 31

How is a crosstab query different from other queries?

A) You can only reference one object (table or query) as the data source
B) You can use records from several objects in a crosstab query
C) You can preview the data before finalizing the query
D) You can select a data source with several grouping fields

Question 32

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

A) Find duplicates
B) Crosstab
C) Append
D) Make table

Question 33

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

A) Which aggregate function used when the query was created
B) The intersection of columns and rows
C) What the query was based on
D) The grouping of the data

Question 34

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

Question 35

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

A) Crosstab query
B) Append query
C) Make table query
D) Find duplicates table

Question 36

What is the purpose of a find unmatched query?

A) To compare records in two related tables and display the records found in one table and not the other.
B) To find records that are the same in two related tables.
C) To combine information in one table with information in another table.
D) To summarize a table into columns and rows to show trends.

Question 37

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

A) Two tables share a common field.
B) Two tables have no relationship.
C) All fields in the tables should be the same.
D) There is nothing necessary for the query to work properly.

Question 38

Duplicate values in a table can prevent you from:

A) enforcing referential integrity.
B) adding additional records.
C) having an accurate database.
D) running an append query.

Question 39

Where do the row headings display in a crosstab query?

A) Along the left side of a crosstab query
B) Along the top of a crosstab query
C) Along the right side of a crosstab query
D) Along the bottom of a crosstab query

Question 40

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

Question 41

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

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

Duplicate values should always be deleted from a database table.

Question 52

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

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

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.

Question 61

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

Question 62

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

Question 63

A(n) ________ query provides the easiest way to move records from one table to another.

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

You should NOT rerun an action query.

Question 73

Access does not have a way to identify duplicate values.

Question 74

Match the following terms with their meanings:
I. crosstab query
II. find duplicate query
III. find unmatched query
IV. action query
A. helps identify duplicate values in a table
B. usually created to show trends in values over time
C. adds, edits, or deletes data in a database
D. compares records in two related tables and displays the records found in one table but not the other

Question 75

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

Question 76

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

Question 77

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

Question 78

A(n) ________ calculates a sum, average, or other statistic and groups the results by sets of values.

Question 79

The field names that display at the top of a crosstab query are called ________.

Question 80

Match the following terms with their meanings:
I. update query
II. append query
III. make table query
IV. delete query
A. creates a new table from data that already exist in a database
B. removes records from a table based on criteria that you specify
C. updates or changes data automatically based on criteria that you specify
D. adds records to an existing table