1 |
Find and Replace command is found in: |
Edit menu
File menu
Tool
View menu
|
2 |
Which of the following is New record button in MS Access? |
*
$
#
|
|
3 |
Which format property displays text in uppercase? |
Greater than sign
Less than sign
TEXT
Upper
|
4 |
Which does not improve data entry? |
Input masks
Validation rules
Indexing
Required fields
|
5 |
Which field type can be indexed? |
Memo
Number
Hyperlink
OLE
|
6 |
Why are validation rules used in a database? |
Ensure correct data is entered
To avoid typing errors
Both A and B
Neither A nor B
|
7 |
Which of the following is NOT suitable for an input mask? |
Street address
Telephone number
A date
Social security number
|
8 |
Which of the following is suitable for an input mask? |
Social security number
Telephone number
A date
All
|
9 |
Field properties are shown in : |
Design view
Datasheet view
A and B
None
|
10 |
Field properties determine: |
Field size
Input mask
Default value
All
|
11 |
What is the term for a for a characteristic or attribute of an object that determines how the object looks and behaves? |
Color
Property
Size
Orientation
|
12 |
Each of the following is an example of a valid Access data type EXCEPT: |
Memo
Currency
Name
Text
|
13 |
Which of the following can be found in an MS Access database file? |
Tables
Forms
Queries
All
|
14 |
Which data type is used to define a field that contains Web address as its context? |
Hyperlink
OLE object
Lookup Wizard
AutoNumber
|
15 |
Which data type can be used to create a sequential number for each record that can also serve as primary key? |
Number
Memo
AutoNumber
Currency
|
16 |
Which data type can be used to define a field that contains data content such as a chart, picture, or graphic object? |
Hyperlink
OLE object
Memo
Auto number
|
17 |
Which data type can be used to define a field that is also formatted for data entry and display? |
Text and Memo
Number and Currency
Date/Time
All
|