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

Accepted Answer

The Append query is used to add records from another table to a destination table. The Append query is used when you want to add records from another table to an existing table.

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

Accepted Answer

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.

Accepted Answer

Option B is not true because action queries can be run more than once, but it is important to have a full awareness of the actions they perform and to backup your data before running them. While it is recommended to exercise caution and fully understand the actions of an action query before running it, there may be situations where running the query multiple times is necessary. Therefore, option B is not true. Options A, C, and D are all true statements about action queries.

Question 4

Which of the following is not a type of query in Access?
A) Select
B) Update
C) Append
D) Make Record

Accepted Answer

"Make Record" is not a type of query in Access. The other three options are valid types of queries in Access. "Make Record" is not a type of query in Access. The other options (Select, Update, and Append) are all common types of queries used to manipulate data in Access databases.

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

Accepted Answer

When an Append query is run on a table that has no primary key, the new records will appear at the bottom of the table. This is because without a primary key, there is no way to sort the records in any particular order. The new records will appear at the bottom of the table. Without a primary key, the sorting order of the table is not established, so the new records cannot be inserted in a specific order.

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

Accepted Answer

The Append query allows users to append records from one table to another table. It provides an easy and automated way to copy records from one table to another table. The Update query updates data in an existing table, the Add Records query adds new records to an existing table, and the Make Table query creates a new table based on existing data. The Append query is used to add records from one table to another. It provides an easy, automated way to copy records from one table to another. The Update query is used to modify existing records, the Add Records option is not a query type, and the Make Table query creates a new table from existing table(s) or query results.

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

Accepted Answer

The answer of What two queries would you use to...

Question 8

Which of the following is not considered an action query?
A) Update
B) Append
C) Create Table
D) Make Table

Accepted Answer

Create Table is a data definition query, not an action query. Action queries are used to modify or add data within existing tables, while data definition queries are used to create new tables or modify the structure of existing ones. Creating a table is not considered an action query because it does not modify or retrieve data from an existing table. Instead, it creates a new table with specified fields and data types. Update, Append, and Make Table are all considered action queries because they modify existing tables or create new tables with data from existing tables.

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

Accepted Answer

The Append query is often used in conjunction with a delete query to move records from one table to another. The delete query would remove the records from the original table, and the Append query would add them to the destination table. The other options (Make Record, Update, and Create table) are not relevant to this scenario. Append queries are used to move records from one table to another. Delete queries are used to remove records from a table. By using an append query in conjunction with a delete query, records can be moved from one table to another. The other choices (A, B, D) are not typically used in conjunction with delete queries to move records between tables.

Question 10

What query would you use to give all full-time employees a 3% raise?
A) Crosstab
B) Append
C) Update
D) Select

Accepted Answer

The UPDATE query is used to modify existing records in a database. In this case, we want to update the salary of full-time employees by increasing it by 3%. The UPDATE query updates values in a table. In this scenario, a query can be written to update the salary of all full-time employees by increasing their current salary by 3%.

Question 11

When you create a query, by default you are creating what type of query?
A) Parameter
B) Select
C) Action
D) Update

Accepted Answer

By default, when you create a query, you are creating a Select query. This type of query allows you to retrieve data from one or more tables based on specified criteria. It is the most commonly used type of query in databases. Parameter queries allow users to enter criteria at runtime, Action queries perform a specific action such as deleting or updating data, and Update queries modify existing data in a table. By default, when creating a query in most database management systems, you are creating a Select query. This type of query allows you to retrieve and view data from one or more tables in a database. Parameter, Action, and Update queries all perform different functions and must be explicitly created.

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.

Accepted Answer

The answer of What happens when a Make Table query...

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.

Accepted Answer

Action queries in databases, such as Microsoft Access, make changes to a large number of records in a single operation. Unlike select queries, action queries can modify or move data, which means their effects are not easily reversible. This is why options B, C, and D are true, but A is not, as once an action query is executed and changes are committed, it cannot be undone through a simple undo command.

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

Accepted Answer

The answer of Which action query would you use if...

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

Accepted Answer

"Find duplicates" will help identify records that are the same, which would be useful in this scenario after appending data from an Excel spreadsheet. The other action queries (B, C, and D) do not address duplicates specifically. The "Find duplicates" action query would help you find records that are the same after you appended an Excel spreadsheet of data into your table. This query compares every record in the table to every other record and returns only the ones that have identical values in each field. This will allow you to identify and remove any duplicate records that may have been created during the import process.

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

Accepted Answer

To find all repeat customers and change their shipping costs to zero, we need to update the data. This can be done with the UPDATE query. Then, we need to find duplicates of the customers based on some unique identifier like email address or customer ID. This can be done with the FIND DUPLICATES query. Finally, we need to track their purchases for two different time periods and compare them. This requires the use of the CROSSTAB query. So, the best choice is to use the three queries in sequence - first update, then find duplicates, and then crosstab. Therefore, option D is the correct answer. To find all repeat customers, we need to find duplicates in the customer table. After finding duplicates, we need to update their shipping costs to zero. Then, three months from now, we can track their purchases and compare them with the purchases made in the three months before the shipping costs were changed. To do this, we can use a crosstab query to compare the aggregate data. Therefore, the best choice would be: 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

Accepted Answer

The append query is used to add records from one table to another. In this case, we want to add records from the Excel spreadsheet of old customers to the Customers table in the database. Therefore, the append query is the most appropriate choice. The other options are not suitable for this purpose. The make table query creates a new table based on a query result. The update query is used to modify existing records in a table. The crosstab query summarizes data by grouping values in one field and calculating values in another field. The Append query is used to add new records from a data source to an existing table in a database. In this case, the data source is the Excel spreadsheet of old customers, and the destination table is the Customers table in the database.

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.

Accepted Answer

Any records that violate the Primary key (or any other) rule are rejected and not added to the destination table. Records that violate the Primary key (or any other) rule are rejected in an Append query. This is because the Primary key is a unique identifier for each record in a table, and duplicates or null values cannot be allowed. Therefore, the query will not add any records that violate this rule to the destination table.

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

Accepted Answer

The "Find Duplicates" action query would be the best choice to find repeat customers as it can identify and return any records with identical data in selected fields, such as customer name or email. This would allow you to easily identify customers who have made multiple purchases or have contacted your company multiple times.

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

Accepted Answer

The Crosstab query would allow you to analyze data by both rows and columns, making it the best option for tracking student grades over time. By setting the year as your column and the student's name as your row, you can easily view a summary of their grades over the past decade. The crosstab query allows you to compare and analyze data across multiple fields. In this case, you can use it to track student grades over the past decade by grouping the data by year and student and displaying the grades in a table format.

Quiz 6: Action and Specialized Queries

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

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

Which of the following is not true about action queries?

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

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

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

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?

Which of the following is not considered an action query?

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

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

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

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

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

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

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?

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?

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?

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

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

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