NEW
Font size
S
M
L
XL
WorksheetsAccess 2.12 (A) Review
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
Which one of these Action Queries pulls data from an existing table and creates a new table?
a)
Append Query
b)
Update Query
c)
Delete Query
d)
Make a Table Query
2.
Which of these Action Queries adds information to a designated table?
a)
Append Query
b)
Update Query
c)
Delete Query
d)
Make a Table Query
3.
Which of these Action Queries makes changes to all the records in a table that meet a given criteria?
a)
Append Query
b)
Update Query
c)
Delete Query
d)
Make a Table Query
4.
A Multi-Table Query will create a query from:
a)
1 table
b)
2 tables
c)
1 or more tables
d)
3 tables
5.
What button must be pressed in order to get the results of a query?
a)
Run
b)
Create
c)
Begin
d)
Apply
6.
What Query creation button must you click in order to create one of the Action Queries?
a)
Query Wizard
b)
Query Design
7.
True or False? A Delete Query will remove data from a specified form?
a)
True
b)
False
8.
The most basic type of query is a(n):
a)
Select
b)
Simple
c)
Both Select and Simple
d)
Run Query
9.
Which report creation button will automatically take all the fields from a table and create a general report for you?
a)
Report Wizard
b)
Report Design
c)
Report Tool
d)
Blank Report
10.
Which report creation button focuses on the structure and themes of the report?
a)
Report Wizard
b)
Report Design
c)
Report Tool
d)
Blank Report
Reset
