1 |
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
|
2 |
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
|
3 |
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
|
4 |
Which data type can be used to define a field that consists on only numbers to be used in calculations? |
Text
Memo
Number
Date/Time
|
5 |
Which data type can be used to define a field that consists of a maximum of 255 numbers or letters? |
Text
Memo
Number
Currency
|
6 |
Which of the following is logical data type in MS Access? |
Boolean
Yes/No
True/false
Log
|
7 |
What is the default field size of a text data type field? |
2
5
20
50
|
8 |
Which data type is the default type? |
Memo
Number
Text
Autonumber
|
9 |
A field's width indicates: |
Number of characters it can contain
Number of inches it takes on the screen
Number of pixels it takes on screen
Number of characters visible to the users
|
10 |
Every field in a table has: |
Field name and data type
field name and a field number
Field number and a data type
Field name, field number, and data type
|
11 |
What symbol indicates that you are editing a record? |
Pencil
Black arrow
Key
Asterisk
|
12 |
Which of the following methods are used for creating a table in Access? |
Creating table in Design view
Creating table by using wizard
Creating table by entering data
All
|
13 |
Which of the following menus is used to switch between table views? |
Edit
File
Tools
View
|
14 |
Which view is used to add, edit or delete records form a table? |
Record view
Datasheet view
Design view
Edit view
|
15 |
Which of the following view in MS Access looks like an electronic spreadsheet? |
Datasheet
QBE
Relationship
Design
|
16 |
Which of the following is NOT displayed in Design view? |
The data type of each field
The components of each filed
The properties of the selected field
The field names
|
17 |
Which of the following view in MS Access is used to define the structure of table? |
Datasheet
QBE
Relationship
Design
|