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

Question 1

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.

Answer 1

A

Question 2

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

Answer 2

A

Question 3

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

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

Answer 3

A

Question 4

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.

Question 5

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 6

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.

Question 7

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 8

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 9

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 10

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 11

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

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

Question 12

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 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

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 15

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 16

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 17

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 18

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

Question 19

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 20

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 21

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

Question 22

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

Question 23

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 24

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 25

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 26

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

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

Question 27

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 28

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

Question 29

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 30

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 31

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 32

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 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

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 35

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 36

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 37

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

Question 38

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 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

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

Question 41

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

Question 42

Duplicate values should always be deleted from a database table.

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

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 54

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

Question 55

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

Question 56

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

Question 57

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 58

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

Question 59

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

Question 60

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

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 66

You should NOT rerun an action query.

Question 67

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

Question 69

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

Question 70

Access does not have a way to identify duplicate values.

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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