NEW
Font size
S
M
L
XL
WorksheetsAccess - Lesson 9
Total questions: 10
Worksheet time: 5mins
Name
Class
Date
1.
Ashawn has created a table from his database to know the number of products currently available for sale in his spring catalog. Which aggregate function should he use?
a)
Count
b)
Max
c)
Min
d)
Average
2.
What is the purpose of a primary key in a database?
a)
Unique Identifier
b)
Limits field size
c)
Provides a description
d)
Provides database security
3.
A wizard that performs the normalization process by examining a table design and suggesting a way to divide the table for maximum efficiency
a)
Query Wizard
b)
Report Wizard
c)
Access Wizard
d)
Table Analyzer
4.
Ashawn has created a table from his database to know which product has the lowest quantity in inventory from his spring catalog. Which aggregate function should he use?
a)
Count
b)
Max
c)
Min
d)
Average
5.
The process of applying rules to a database design to ensure that you have divided your information into the appropriate tables
a)
Critical Thinking
b)
Aggregate function
c)
Normalization
d)
Table priorization
6.
Carol has created a table from her database to see all information about FBLA chapters in her region. She needs to know the mean number of active members in the region. Which aggregate function should she use?
a)
Count
b)
Max
c)
Min
d)
Average
7.
Ashawn has created a table from his database to see his company's income and expenses for the year and now would like to see the totals for each category. Which table feature should he use?
a)
Insert a Totals Row
b)
Sort by Selection
c)
Insert a Chart
d)
Table prioritization
8.
The Table Analyzer gives you the choice of whether to create a query. True or False?
a)
True
b)
False
9.
On which tab can you find the commands to insert and delete rows?
a)
Create
b)
Table Tools: Design
c)
Database Tools
d)
External Data
10.
In order to start the Data Analyzer Wizard, what do you do?
a)
Open table > Database Tools tab > Analyze Table button
b)
Open table > Database Tools tab > Relationships > Relationship button
c)
Open table > Database Tools tab > Macro > Run Macro button
d)
Open table > Create tab > Queries > Query Wizard
Reset
