21
The following criterion is NOT written using the proper syntax?
A)
"Haris"
B)
<500
C)
NO VALUE
D)
Between #1/1/2000# and #12/31/2000#
Answer & Solution
Answer: Option
C
22
In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?
A)
zipcode, firstname, lastname
B)
firstname, lastname, zipcode
C)
zipcode, lastname, firstname
D)
can't sort by multiple fields
Answer & Solution
Answer: Option
C
23
In Access press to Cycle through the field grid, field properties, Navigation Pane, access keys in the Keyboard Access System, Zoom controls, and the security bar (Design view of tables)
A)
F6
B)
F7
C)
F8
D)
None of these
Answer & Solution
Answer: Option
A
24
Which control type do you use to create a calculated control?
A)
command button
B)
combo box
C)
text box
D)
list box
Answer & Solution
Answer: Option
C
25
An organized collection of logically related data is known as
A)
Data
B)
Meta data
C)
Database
D)
Information
Answer & Solution
Answer: Option
C
26
What is the memo data type field used for?
A)
To add table
B)
To store objects created in other programs
C)
For long text entries
D)
For shout text entries of no more than 255 characters
Answer & Solution
Answer: Option
C
27
This type of query summarizes large amounts of data in easy-to-read, row-and-column format.
A)
Crosstab
B)
Columnar
C)
Select
D)
Action
Answer & Solution
Answer: Option
A
28
Which of the following is not a field type in Access
A)
Memo
B)
Hyperlink
C)
OLE Object
D)
Lookup Wizard
Answer & Solution
Answer: Option
D
29
When creating a new table which method can be used to choose fields from standard databases and tables
A)
Create table in Design View
B)
Create Table using wizard
C)
Create Table by Entering data
D)
None of above
Answer & Solution
Answer: Option
B
30
The Table _______________ Wizard analyzes a database and recommends changes for normalization.
A)
Analyzer
B)
Documenter
C)
Cleanup
D)
Normalization
Answer & Solution
Answer: Option
A
