Chapter 7 Action And Specialized Queries Complete Test Bank

Exploring Microsoft Office 365, Access 2019 Comprehensive (Poatsy)

Chapter 7 Action and Specialized Queries

1) Which of the following is not considered an action query?

A) Update

B) Append

C) Create Table

D) Make Table

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

2) 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.

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 1

Objective: A6.01 Determine When to Use an Action Query

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

A) Parameter

B) Select

C) Action

D) Update

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 3

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 3

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 1

Objective: A6.01 Determine When to Use an Action Query

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

A) Append

B) Crosstab

C) Update

D) Select

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

9) 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.

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

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

A) Crosstab

B) Append

C) Update

D) Select

Diff: 1

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 1

Objective: A6.01 Determine When to Use an Action Query

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

A) Find unmatched

B) Find records

C) Find duplicates

D) Crosstab

Diff: 1

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

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

A) Select

B) Update

C) Append

D) Make Record

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 2

Objective: A6.03 Add Records to a Table with an Append Query

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

Diff: 3

Objective: A6.03 Add Records to a Table with an Append Query

19) 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.

Diff: 3

Objective: A6.03 Add Records to a Table with an Append Query

20) 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.

Diff: 3

Objective: A6.03 Add Records to a Table with an Append Query

21) 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.

Diff: 2

Objective: A6.03 Add Records to a Table with an Append Query

22) 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.

Diff: 1

Objective: A6.05 Delete Records with a Delete Query

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

A) Parameter

B) Select

C) Append

D) Update

Diff: 2

Objective: A6.05 Delete Records with a Delete Query

24) 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.

Diff: 3

Objective: A6.05 Delete Records with a Delete Query

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

Diff: 2

Objective: A6.06 Summarize Data with a Crosstab Query

26) What query is often used to display trends in values?

A) Parameter

B) Summary

C) Find duplicates

D) Crosstab

Diff: 2

Objective: A6.06 Summarize Data with a Crosstab Query

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

Diff: 2

Objective: A6.06 Summarize Data with a Crosstab Query

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

Diff: 2

Objective: A6.06 Summarize Data with a Crosstab Query

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

Diff: 2

Objective: A6.06 Summarize Data with a Crosstab Query

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

A) Sum

B) Average

C) Var

D) Count

Diff: 1

Objective: A6.06 Summarize Data with a Crosstab Query

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

Diff: 1

Objective: A6.06 Summarize Data with a Crosstab Query

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

A) 2

B) 3

C) 4

D) 5

Diff: 3

Objective: A6.06 Summarize Data with a Crosstab Query

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

Diff: 2

Objective: A6.06 Summarize Data with a Crosstab Query

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

A) Crosstab

B) Find duplicates

C) Find unmatched

D) Find Null

Diff: 2

Objective: A6.06 Summarize Data with a Crosstab Query

35) 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.

Diff: 2

Objective: A6.06 Summarize Data with a Crosstab Query

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

Diff: 1

Objective: A6.07 Find Duplicate Records with a Query

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

Diff: 3

Objective: A6.07 Find Duplicate Records with a Query

38) 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.

Diff: 2

Objective: A6.08 Find Unmatched Records with a Query

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

Diff: 1

Objective: A6.08 Find Unmatched Records with a Query

40) Tables can be created using the Crosstab query type.

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

41) The Delete action query deletes tables.

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 1

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 3

Objective: A6.01 Determine When to Use an Action Query

46) Action queries change data.

Diff: 1

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 1

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 1

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 2

Objective: A6.02 Update Date with an Update Query

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

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 2

Objective: A6.03 Add Records to a Table with an Append Query

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

Diff: 3

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 1

Objective: A6.02 Update Date with an Update Query

55) Action queries can be tested before being run.

Diff: 1

Objective: A6.02 Update Date with an Update Query

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

Diff: 2

Objective: A6.02 Update Date with an Update Query

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

Diff: 3

Objective: A6.03 Add Records to a Table with an Append Query

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

Diff: 2

Objective: A6.03 Add Records to a Table with an Append Query

59) 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.

Diff: 3

Objective: A6.04 Create a Table with Make a Table Query

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

Diff: 2

Objective: A6.04 Create a Table with Make a Table Query

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

Diff: 1

Objective: A6.06 Summarize Data with a Crosstab Query

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

Diff: 2

Objective: A6.06 Summarize Data with a Crosstab Query

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

Diff: 3

Objective: A6.06 Summarize Data with a Crosstab Query

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

Diff: 2

Objective: A6.06 Summarize Data with a Crosstab Query

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

Diff: 3

Objective: A6.06 Summarize Data with a Crosstab Query

66) All duplicated data represents poor database design.

Diff: 1

Objective: A6.07 Find Duplicate Records with a Query

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

Diff: 2

Objective: A6.08 Find Unmatched Records with a Query

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

Diff: 1

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 1

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 1

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 1

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 1

Objective: A6.02 Update Date with an Update Query

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

Diff: 2

Objective: A6.02 Update Date with an Update Query

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

Diff: 1

Objective: A6.03 Add Records to a Table with an Append Query

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

Diff: 3

Objective: A6.03 Add Records to a Table with an Append Query

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

Diff: 3

Objective: A6.03 Add Records to a Table with an Append Query

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

Diff: 2

Objective: A6.03 Add Records to a Table with an Append Query

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

Diff: 3

Objective: A6.05 Delete Records with a Delete Query

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

Diff: 1

Objective: A6.05 Delete Records with a Delete Query

82) Running an update query from ________ view does not display the results in a datasheet like a select query does.

Diff: 3

Objective: A6.02 Update Date with an Update Query

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

Diff: 2

Objective: A6.06 Summarize Data with a Crosstab Query

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

Diff: 1

Objective: A6.06 Summarize Data with a Crosstab Query

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

Diff: 2

Objective: A6.06 Summarize Data with a Crosstab Query

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

Diff: 2

Objective: A6.06 Summarize Data with a Crosstab Query

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

Diff: 2

Objective: A6.06 Summarize Data with a Crosstab Query

88) Action queries make changes to the data in the underlying ________.

Diff: 2

Objective: A6.01 Determine When to Use an Action Query

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

Diff: 2

Objective: A6.07 Find Duplicate Records with a Query

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

Diff: 1

Objective: A6.08 Find Unmatched Records with a Query

91) Match the following terms with their descriptions:

I. Action query

II. Append query

III. Delete query

IV. Update query

V. Crosstab query

A. Adds records from a source table to a destination table

B. Changes data values

C. Removes records

D. General term for any query that changes data

E. Displays trends over time

Diff: 1

Objective: Multiple Objectives

92) Match the following terms with their descriptions:

I. Column heading

II. Row heading

III. Find duplicates query

IV. Find unmatched query

V. Make Table query

A. Finds records which are found in one table, but not the other table

B. Displayed at the top of a crosstab query

C. Displayed at the left side of a crosstab query

D. Selects records from one table and creates a new table with those records included

E. Finds repeated values

Diff: 1

Objective: Multiple Objectives

93) Match the following queries with what is unique about them:

I. Crosstab

II. Delete

III. Update

IV. Make Table

V. Append

A. Can only use one data source

B. Similar to a copy and paste for records

C. Removes records

D. Should be run multiple times only with extreme caution

E. Deletes existing table with same name

Diff: 1

Objective: Multiple Objectives

94) Match the following queries with what is unique about them:

I. Append

II. Crosstab

III. Make Table

IV. Delete

V. Find unmatched

A. Copies the structure of an existing table

B. Often used after an Append query

C. Replaces the Show row in query design view

D. Finds students with no grades applied

E. Requires at least three fields

Diff: 1

Objective: Multiple Objectives

95) Match the following commands with their purposes:

I. Run

II. Datasheet View

III. Query Wizard

IV. Query Design

V. Find Unmatched Query Wizard

A. Used to preview how an action would affect data.

B. Provides step-by-step instructions for creating one specific type of action query.

C. Performs the action of the query.

D. Allows for the creation of a simple select query.

E. Allows the creation of certain action queries not available anywhere else.

Diff: 1

Objective: Multiple Objectives

96) Match the following recommendations with the appropriate commands or queries:

I. Perform this before running an action query.

II. Do this very carefully.

III. Use this to help find redundant data.

IV. Be aware that this is true of all action queries.

V. Doing this will delete an existing table.

A. Create and run a Find duplicates query.

B. Run a Make table query

C. Run an Update query a second time.

D. They cannot be undone.

E. Backup database

Diff: 1

Objective: Multiple Objectives

97) Match the following statements with which commands or queries they are true:

I. This is a safe way to test an action query.

II. This cannot be created directly from the Table tools tab; Design tab; Query Type group.

III. This is often run after an Append query.

IV. This is how most action queries begin.

V. Performing this is always a good idea.

A. Select query

B. Datasheet view

C. Find duplicates query

D. Delete query

E. Backup database

Diff: 3

Objective: Multiple Objectives

98) Match the following queries with the action they would perform:

I. Append

II. Delete

III. Make Table

IV. Crosstab

V. Find duplicates

A. Remove records from a table

B. Display trends over time

C. Find repeat customers

D. Select records, then create a new table for them

E. Add records from another table

Diff: 1

Objective: A6.01 Determine When to Use an Action Query