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

Question 1

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 1

A

Question 2

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 2

A

Question 3

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

Answer 3

A

Question 4

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 5

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 6

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

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

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

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 9

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 10

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

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

Question 11

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 12

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 13

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 14

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 15

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 16

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 17

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 18

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 19

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 20

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 21

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 22

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

Question 23

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 24

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 25

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

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

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 28

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 29

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 30

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

Question 31

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

Question 32

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 33

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 34

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 35

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

Question 36

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 37

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 38

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 39

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 40

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 41

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

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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

Question 58

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

Question 59

Duplicate values should always be deleted from a database table.

Question 60

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

Question 61

Access does not have a way to identify duplicate values.

Question 62

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

Question 63

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

Question 64

You should NOT rerun an action query.

Question 65

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

Question 66

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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