Access 2.12 (A) Review

Which one of these Action Queries pulls data from an existing table and creates a new table?

• Append Query
• Update Query
• Delete Query
• Make a Table Query

Which of these Action Queries adds information to a designated table?

• Append Query
• Update Query
• Delete Query
• Make a Table Query

Which of these Action Queries makes changes to all the records in a table that meet a given criteria?

• Append Query
• Update Query
• Delete Query
• Make a Table Query

A Multi-Table Query will create a query from:

• 1 table
• 2 tables
• 1 or more tables
• 3 tables

What button must be pressed in order to get the results of a query?

• Run
• Create
• Begin
• Apply

What Query creation button must you click in order to create one of the Action Queries?

• Query Wizard
• Query Design

True or False? A Delete Query will remove data from a specified form?

• True
• False

The most basic type of query is a(n):

• Select
• Simple
• Both Select and Simple
• Run Query

Which report creation button will automatically take all the fields from a table and create a general report for you?

• Report Wizard
• Report Design
• Report Tool
• Blank Report

Which report creation button focuses on the structure and themes of the report?

• Report Wizard
• Report Design
• Report Tool
• Blank Report