Site MapHelpFeedbackMixed Quiz
Mixed Quiz
(See related pages)



1

Which of the following refers to a restriction placed on records in the open datasheet to quickly isolate and display a subset of records?
A)query
B)datasheet
C)form
D)filter
2

If you are building a filter and you wish to include entries from the zip codes 45430, 43210, and 43214, then you would use which operator?
A)Zip Code
B)OR
C)Range
D)AND
3

You can create a Select query using
A)Crosstab query wizard.
B)Find Duplicates query wizard.
C)Select query design wizard.
D)Simple query wizard.
4

Which type of query prompts you with a dialog box to enter criteria?
A)Parameter query
B)Action query
C)Crosstab query
D)Select query
5

To remove all fields from the query design grid, choose
A)Tools/New.
B)Clear/Clear Grid.
C)Edit/Clear Grid.
D)File/Clear Grid.
6

A query that uses more than one tables is called what?
A)explicit query
B)multitable query
C)joined query
D)relational query
7

You can display up to this many pages of a report at a time.
A)10
B)15
C)20
D)25
8

When designing a report, you can display the toolbox or field list using this menu.
A)Tools
B)File
C)View
D)Edit
9

If you wanted something to print at the top of every page of the report, you would include it in this section.
A)Report Header
B)Page Footer
C)Report Footer
D)Page Header
10

A control that is not linked to a field in the underlying table is said to be
A)suspect.
B)unbound
C)object-oriented.
D)bound
11

A filter is only temporary, and all records are redisplayed when you remove the filter.
A)True
B)False
12

A Cross tab query locates records in one table that do not have records in another.
A)True
B)False
13

The common fields of a join must have the same field name.
A)True
B)False
14

The View/Pages command can be used to display up to 12 pages.
A)True
B)False
15

Compacting makes a copy of the file and rearranges how the file is stored on your disk.
A)True
B)False





To learn more about the book this website supports, please visit its Information Center.
(c)2004 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


The O'Leary Series Office 2003Online Learning Center

Home > Access 1 > Lab 3 > Mixed Quiz