Microsoft Office Excel

Computing

Quiz 7 :

Action and Specialized Queries

Quiz 7 :

Action and Specialized Queries

Question Type
search
arrow
Which action query provides an easy, automated way to copy records from one table to another table?
Free
Multiple Choice
Answer:

Answer:

B

Tags
Choose question tag
close menu
arrow
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?
Free
Multiple Choice
Answer:

Answer:

A

Tags
Choose question tag
close menu
arrow
What queries are often used in conjunction with delete queries to move records from one table to another?
Free
Multiple Choice
Answer:

Answer:

C

Tags
Choose question tag
close menu
arrow
Which of the following is not considered an action query?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which of the following is not true about action queries?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Of the four action queries, which one would help you find repeat customers?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
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?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which of the following is not a type of query in Access?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
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?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which of the following is not true about running action queries?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which action query would you use if you wanted to add records from another table?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
When an Append query is run on a table that has no primary key, where do the new records appear?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which action query would you use if you wanted to change every occurrence of "Miss" or "Mrs." to "Ms"?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
In an Append query, what happens to any records that violate the Primary key (or any other) rule?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
When you create a query, by default you are creating what type of query?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
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%?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What happens when a Make Table query is run when a table with the same name already exists in the database?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
What query would you use to give all full-time employees a 3% raise?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Of the four action queries, which one would help you track student grades over the past decade?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
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?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
Showing 1 - 20 of 98