NEW
Font size
S
M
L
XL
WorksheetsMS Access Database
Total questions: 10
Worksheet time: 7mins
Name
Class
Date
1.
What prevents duplicated data or NULL data from being entered in the same field?
a)
Data Preventer
b)
Primary Key
c)
Primary Lock
d)
Field Lock
2.
Which Application program saves data automatically as it is entered?
a)
MS Word
b)
PowerPoint
c)
MS Access
d)
MS Excel
3.
What kind of data type do you use when entering a Client Number?
a)
Short Text
b)
Currency
c)
Number
d)
Autonumber
4.
Client Name is an example of a:
a)
Field Name
b)
Record
5.
What is a Relationship in an MS Access Database?
a)
It makes the data easier to enter
b)
It prevents data from being entered incorrectly
c)
It makes you feel closer to the computer and it's capabilities
d)
It connects two tables so that they can be used as one table
6.
What TAB is used to Created a Report, a Query, a Form or another Table?
a)
Design
b)
Home
c)
Database Tools
d)
Create
7.
What button is used to create a new Report?
a)
Report Wizard
b)
Blank Report
c)
Report
d)
Report Design
8.
When creating a Form, which drop-down button is used to locate the split form?
a)
Split-Form Drop-down
b)
Form Wizard
c)
Form Design
d)
More Forms Drop-down
9.
To Enter Data in a Database showing only ONE record at a time, what must you create a:
a)
A Record
b)
A Report
c)
A Form
d)
A Querry
10.
In Access, What's the best way to give the boss a report of all the clients in a Client Table?
a)
Create a Query
b)
Create a Report
c)
Create A Form
d)
Create a Table
Reset
