Font size
WorksheetsMS ACCESS
Total questions: 20
Worksheet time: 10mins
Tick the Functions of a Database
Updating
Sorting
Editing
Playing
A computerized record keeping system is called as
Communication system
Database management System(DBMS)
Networking System
Which of the following is the correct definition of a Record?
It has only one type of information
Collection of Files
All information about a single entity.
Fields in database are similar to _________ in tables.
Rows
Columns
Cells
Values
Which view of table is used to insert a field name in table.
Date sheet
Design
Database
all of the above
The default extension of Ms-Access file is __________
.acccdb
.accdb
.abccd
.acbdc
Which datatype will be used to generate numbers automatically while inserting data?
Number
Auto number
Automatic Number
Integer
Each item from this list is classified as...
Name
Birthdate
Social Security No.
Street
City
State
Zip
table
record
field/Attribute Name
Data Type
Table Rows are called...
fields
records
table
entry
Table Columns are called...
rows
fields
table
form
Which data type would be most suitable for the 'DateofBirth' field?
Currency
Number
Date/Time
Yes/No
Memo
Where do you configure the field properties of a Table?
Design View
Datasheet View
Access View
The best data type to choose for a postcode would be
Number
Text
Date/Time
Currency
