Deck 7: Action and Specialized Queries

Question 1

Which action query provides an easy, automated way to copy records from one table to another table?

A) Update
B) Append
C) Add Records
D) Make table

Answer 1

B

Question 2

What two queries would you use to move all customers with unpaid invoices into a new table of their own and remove them from the original table?

A) Make table and Delete
B) Append and Delete
C) Make table and Update
D) Append and Update

Answer 2

A

Question 3

What queries are often used in conjunction with delete queries to move records from one table to another?

A) Make Record
B) Update
C) Append
D) Create table

Answer 3

C

Question 4

Which of the following is not considered an action query?

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

Question 5

Which of the following is not true about action queries?

A) They can be run more than once, but with full awareness of the action(s) they perform.
B) They should never be run more than once.
C) You should backup your data before running them.
D) They have special symbol icons to distinguish them from other queries.

Question 6

Of the four action queries, which one would help you find repeat customers?

A) Find unmatched
B) Find records
C) Find duplicates
D) Crosstab

Question 7

What query would you use if you were given an Excel spreadsheet of old customers and asked to incorporate these records into the Customers table of your database?

A) Make table
B) Append
C) Update
D) Crosstab

Question 8

Which of the following is not a type of query in Access?

A) Select
B) Update
C) Append
D) Make Record

Question 9

Of the four action queries, which one would help you find records that are the same after you appended an Excel spreadsheet of data into your table?

A) Find duplicates
B) Find unmatched
C) Crosstab
D) Find mismatched

Question 10

Which of the following is not true about running action queries?

A) They can be undone.
B) They can be cancelled before completion.
C) You will receive a warning when you attempt to run them.
D) They change data.

Question 11

Which action query would you use if you wanted to add records from another table?

A) Append
B) Crosstab
C) Update
D) Select

Question 12

When an Append query is run on a table that has no primary key, where do the new records appear?

A) Top of the table
B) Bottom of the table
C) Alphabetically in ascending order mixed in with the current list
D) You cannot run an Append query on a table with no primary key

Question 13

Which action query would you use if you wanted to change every occurrence of "Miss" or "Mrs." to "Ms"?

A) Append
B) Change Records
C) Find and Replace
D) Update

Question 14

In an Append query, what happens to any records that violate the Primary key (or any other) rule?

A) The query pauses at each violating record and allows you to fix the error(s).
B) A message box appears telling you that you must fix the problematic records before the query can be run.
C) New Primary key values are added to the records
D) The records are rejected.

Question 15

When you create a query, by default you are creating what type of query?

A) Parameter
B) Select
C) Action
D) Update

Question 16

What query or queries would you use to move every item that has never been sold to a new database, then reduce the price of each item by 10%?

A) Find unmatched, then make table, then delete, then update
B) Find unmatched, then make table, then append, then delete, then update
C) Append, then delete, then update
D) Make table, then delete, then update

Question 17

What happens when a Make Table query is run when a table with the same name already exists in the database?

A) The existing table has the word " Old" added to the end of the name.
B) The query will not run until you rename or delete the existing table.
C) The existing table is deleted.
D) The query will function like an Append query instead.

Question 18

What query would you use to give all full-time employees a 3% raise?

A) Crosstab
B) Append
C) Update
D) Select

Question 19

Of the four action queries, which one would help you track student grades over the past decade?

A) Summary
B) Find duplicates
C) Find patterns
D) Crosstab

Question 20

What query or queries would you use to find all repeat customers, change their shipping costs to zero, and then three months from now track their purchases to see if they purchased more over the last three months than the three months before the shipping costs were changed?

A) Update, then crosstab
B) Update, then find duplicates, then crosstab
C) Find duplicates, then crosstab
D) Find duplicates, then update, then crosstab

Question 21

In a crosstab query, where do the values of a field selected as a row heading display?

A) Left side of the crosstab datasheet
B) Right side of the crosstab datasheet
C) Top of the crosstab datasheet
D) Bottom of the crosstab datasheet

Question 22

Which is the first table chosen when creating a find duplicates query?

A) The table where the duplicate data might be found
B) The table with the foreign key
C) The data source for the query
D) The table which has no Primary key

Question 23

What query would help you find if a customer purchased from you more than once?

A) Crosstab
B) Find duplicates
C) Find unmatched
D) Summary

Question 24

Which of the following is not a common aggregate function used in a crosstab query?

A) Sum
B) Average
C) Var
D) Count

Question 25

In a crosstab query, where do the values of a field selected as a column heading display?

A) Left side of the crosstab datasheet
B) Right side of the crosstab datasheet
C) Top of the crosstab datasheet
D) Bottom of the crosstab datasheet

Question 26

In a crosstab query, what data is found at the intersection of the rows and columns?

A) Row heading
B) Aggregating
C) Column heading
D) Query title

Question 27

What does Access do to denote action queries differently in the Navigation Pane?

A) It displays them in bold text.
B) It displays them in a section called Action queries.
C) It displays them using specific icons.
D) It displays them in a larger typeface.

Question 28

What query is often used to display trends in values?

A) Parameter
B) Summary
C) Find duplicates
D) Crosstab

Question 29

Which query would you use to show the sales by region for each of four quarters?

A) Crosstab
B) Find duplicates
C) Find unmatched
D) Summary

Question 30

When creating a crosstab query, you need a minimum of how many fields?

A) 2
B) 3
C) 4
D) 5

Question 31

Which of the following is an example of a field which should not have duplicate data?

A) City
B) State
C) Lastname
D) Primary key

Question 32

Which of the following is not a rule for using an Append query?

A) There must be the same number of fields in both tables.
B) Data types in both tables much match (with some exceptions).
C) The destination table should not have an AutoNumber field.
D) All the normal rules for adding a new record to the destination table still apply.

Question 33

Tables can be created using the Crosstab query type.

Question 34

Which query would be helpful to locate students for whom no grades have been assigned during a semester?

A) Crosstab
B) Find duplicates
C) Find unmatched
D) Find Null

Question 35

The first step in creating a Delete query is to create what other type of query?

A) Parameter
B) Select
C) Append
D) Update

Question 36

When you assign a date field to the column heading in a crosstab query, which option does Access not give you for summarizing your data?

A) Biweekly
B) Monthly
C) Quarterly
D) Yearly

Question 37

Which action query can be undone if you change your mind immediately after running the query?

A) Make table
B) Append
C) Update
D) You cannot undo action queries.

Question 38

What query would you use to find items that have never sold?

A) Crosstab
B) Find duplicates
C) Find unmatched
D) Find Null

Question 39

Which of the following is not a reason for using specialized queries?

A) They help you streamline (limit) your data.
B) They help you analyze your data.
C) They help you improve the integrity of your data.
D) They help you find group and summarize your data.

Question 40

What must you do before you can create a crosstab query that references more than one table?

A) Run an append query to combine the records from the various tables.
B) Run a make table query and use that as the source for the crosstab query.
C) Make sure the relationships have been properly created in the Relationships window.
D) Create a select query which includes the fields from the various tables you want included in the crosstab query.

Question 41

To guard against data loss, it is good practice to have the same record in more than one table.

Question 42

As with other actions in Access, you can undo the changes made by running actions queries.

Question 43

The Append query can create a table and add records to it at the same time.

Question 44

Action queries can be tested before being run.

Question 45

Action queries change data.

Question 46

An action query is useful when an end user is required to enter the same information into many records.

Question 47

The Make table query is limited to creating tables in the current database.

Question 48

When you create a query, by default you are creating a parameter query.

Question 49

It is always a good practice to backup your entire database before running an action query.

Question 50

It is possible, using the Make Table query to create a table in another database.

Question 51

Depending on what an Update query is designed to do; it is often not a good idea to run the query again.

Question 52

You cannot run a Make Table query if a table with that name already exists in the database.

Question 53

The Delete action query deletes tables.

Question 54

The use of the Make table query is often followed by the Delete query.

Question 55

When you run an action query that affects data, Access always warns you how many records will be affected.

Question 56

Before running an action query, it is good idea to backup your database.

Question 57

When running a Make Table query, if the "Move Records" check box is checked, then the table will be created and all appropriate records will be moved (not just copied) to the new table.

Question 58

When working with queries, viewing a query in Datasheet View is the same as running the query.

Question 59

When you update data in a query, you are actually updating the data in the underlying table.

Question 60

An Update query can only update (change) values in one field at a time.

Question 61

Unlike other queries, changing elements in a Crosstab query is difficult and it is usually easier to just create a new query.

Question 62

Unlike other queries, you can only reference one object as the data source in a Crosstab query.

Question 63

The ________ query is a good alternative to the Find and Replace tool.

Question 64

When you convert a Select query to an Append query, Access removes the Show row and adds a(n) ________ To row in its place.

Question 65

You cannot undo updates or deletions performed by a(n) ________ query.

Question 66

Before running an Update query, you usually begin with a(n) ________ query to view the results before making a permanent change.

Question 67

When you create a query, by default you are creating a(n) ________ query.

Question 68

Crosstab queries display the results in a grid of columns and rows.

Question 69

All duplicated data represents poor database design.

Question 70

Append queries are often used in conjunction with ________ queries to move records from one table to another and removed records from the current table.

Question 71

When creating a crosstab query, you need a minimum of four fields.

Question 72

A(n) ________ query changes data values in one or more fields based on specific criteria.

Question 73

The Make Table query is an example of a(n) ________ query.

Question 74

A(n) ________ Table query can create a new table based on data in an existing table.

Question 75

The summarizing or aggregating data in a crosstab query are displayed at the intersection of the rows and columns.

Question 76

The ________ query can add records from a spreadsheet to an existing table.

Question 77

In a Find duplicates query, it does not matter which table is chosen first.

Question 78

The Delete query is often used immediately after a(n) ________ query.

Question 79

A(n) ________ query automatically removes records based on certain criteria.

Question 80

Before running an Append query, it is best to first create a(n) ________ query to view the results before making a permanent change.