NEW
Font size
S
M
L
XL
WorksheetsAccess Lesson 7
Total questions: 20
Worksheet time: 5hrs 45mins
Name
Class
Date
1.
The Queries group on the _______ tab contains the commands used to create queries.
a)
Create
b)
Query Design
c)
select query
d)
Datasheet
2.
The _______ button creates a new, blank query in Design view.
a)
Datasheet
b)
Query Design
c)
record source
d)
Simple Query
3.
A(n) _______ is the most basic type of Access query.
a)
field list
b)
Design
c)
select query
d)
Find Unmatched
4.
The tables or queries from which a query gets its data are referred to as its _______.
a)
select query
b)
Find Unmatched
c)
Design
d)
record source
5.
To run a query after it has been created, double-click it in the Navigation Pane to open it in _______ view and see the results.
a)
Datasheet
b)
Query Design
c)
duplicates
d)
Design
6.
Two or more records are considered _______ only when all the fields in your query results contain the same values.
a)
Simple Query
b)
Datasheet
c)
duplicates
d)
select query
7.
When you need to include multiple tables in your query, use the _______ Wizard to build a query from a primary table and a related table.
a)
select query
b)
Simple Query
c)
record source
d)
Design
8.
To view only the records in one table that don�t have a matching record in another table, you can create a(n) _______ query.
a)
Find Unmatched
b)
Query Design
c)
field list
d)
duplicates
9.
By switching to _______ view, you can access all the tools needed to modify your query.
a)
select query
b)
record source
c)
Find Unmatched
d)
Design
10.
A(n) _______ is a window that lists all the fields in the underlying record source or database object.
a)
field list
b)
Query Design
c)
duplicates
d)
Simple Query
11.
Creating a query is like
a)
a. sorting the data.
b)
b. asking the database a question.
c)
c. creating a new table.
d)
d. opening an existing database.
12.
The results that a query returns can be
a)
a. sorted.
b)
b. grouped.
c)
c. filtered.
d)
d. all of the above.
13.
When one table will provide the information that you need, you can create a
a)
a. record source.
b)
b. simple select query.
c)
c. query criterion.
d)
d. parameter query.
14.
Which query cannot be created using the Query Wizard?
a)
a. Parameter query
b)
b. Simple query
c)
c. Find duplicates query
d)
d. Find unmatched query
15.
Queries are different from sort or filter commands because they can be
a)
a. applied to multiple fields.
b)
b. saved.
c)
c. modified.
d)
d. used on forms.
16.
A query can get its data from
a)
a. one or more tables.
b)
b. existing queries.
c)
c. a combination of a and b.
d)
d. all of the above.
17.
To find records that contain matching field values, you can create a query using which wizard?
a)
a. Find Matching
b)
b. Matching Fields
c)
c. Duplicate Records
d)
d. Find Duplicates
18.
Before creating a query from multiple tables, you must first ensure that the tables have
a)
a. unmatched records.
b)
b. a defined relationship.
c)
c. a filter applied.
d)
d. no related records.
19.
To add a table to a query, you must be in what view?
a)
a. SQL
b)
b. Datasheet
c)
c. PivotTable
d)
d. Design
20.
A rule that identifies the records that you want to include in the query result is called a
a)
a. parameter query.
b)
b. query criterion.
c)
c. select query.
d)
d. field list.
Reset
