NEW
Font size
S
M
L
XL
WorksheetsDatabase-Datatypes
Total questions: 17
Worksheet time: 9mins
Name
Class
Date
1.
Collection of fields known as
a)
keyfield
b)
record
c)
file
d)
table
2.
Which datatype can store both text and numbers
a)
Boolean
b)
Image
c)
number
d)
Text
3.
Which datatype would you use for a car registration number?
a)
Boolean
b)
Image
c)
number
d)
Text
4.
What datatype is used for yes/no?
a)
text
b)
boolean
c)
numbers
d)
memo
5.
Which datatype is suitable for your date of birth?
a)
TEXT
b)
NUMBER
c)
DATE
d)
TIME
6.
What datatype is used to store an appointment time?
a)
DATE
b)
TIME
c)
MEMO
d)
NUMBERS
7.
Which datatype is used to store the field SURNAME
a)
NUMBER
b)
BOOLEAN
c)
TEXT
d)
IMAGE
8.
Which datatype would be the best choice to store if have you passed your driving test.
a)
text
b)
boolean
c)
memo
d)
number
9.
Which are the operators for less than, greater than and equal to?
a)
\ / =
b)
{ } =
c)
( ) ==
d)
< > =
10.
Select the correct definition for "Database"
a)
This stores all the records for a particular field
b)
A collection of data stored in logical order
c)
One piece of data or information about a person of thing
d)
Used to uniquely identify every record in a table
11.
Select the correct definition for "Field"
a)
This stores all the records for a particular field
b)
A collection of data stored in logical order
c)
One piece of data or information about a person or object
12.
A record in Access is a...
a)
row
b)
column
13.
A field in Access is a...
a)
column
b)
row
14.
A column is...
a)
horizontal
b)
vertical
15.
A row is...
a)
horizontal
b)
vertical
16.
Access is a database.
a)
True
b)
False
17.
What are the two views that you can use when putting data in Access?
a)
Datasheet View and Design View
b)
Column View and Row View
c)
Field View and Record View
Reset
