Deck 6: Action and Specialized Queries

Question 1

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

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

Answer 1

A

Question 2

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

Answer 2

A

Question 3

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.

Answer 3

B

Question 4

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

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

Question 5

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 6

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

Question 7

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

Question 8

Which of the following is not considered an action query?

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

Question 9

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

Question 10

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

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

Question 11

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

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

Question 12

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 13

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 14

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 15

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 16

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 17

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 18

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 19

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 20

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 21

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 22

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 23

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 24

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 25

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

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 28

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

Question 29

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 30

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 31

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 32

What query is often used to display trends in values?

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

Question 33

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 34

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 35

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 36

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

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

Question 37

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

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

Question 38

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 39

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 40

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

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

Question 41

In a Crosstab query, the column heading is displayed at the ________ of the datasheet.

Question 42

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

Question 43

A(n) ________ query is usually created to show trends in values.

Question 44

You can present grouped and summarized data with a(n) ________ query

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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 50

You can use one, or more, tables as source tables when running a(n) ________ query.

Question 51

Before running an Append query, it is best to first create a(n) ________ query.

Question 52

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

Question 53

In a crosstab query, the field values which are displayed on the left side are also called the ________ heading.

Question 54

The easiest way to create a crosstab query is to use the Crosstab Query ________.

Question 55

A(n) ________ query removes records from a table.

Question 56

As with other queries, action queries can be ________ for use at a later time.

Question 57

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

Question 58

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

Question 59

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

Question 60

Before running an Update query, you usually begin with a(n) ________ query.

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

Action queries change data.

Question 66

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 67

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

Question 68

Tables can be created using the Crosstab query type.

Question 69

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

Question 70

Finding ________ values and knowing what to do with them remains one of the challenges of good database design.

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

The Delete action query deletes tables.

Question 80

Action queries can be tested before being run.