12. Which form type displays records in a tabular format similar to a Datasheet view but has more editing options such as adding graphics? |
Datasheet Form
Multiple Items Form
Split Form
Subform
|
13. Clicking on the form tool will open a(n) |
existing form.
new form in design view.
new form in layout view.
wizard to design a form.
|
14. Which of the following describes a poor design consideration for a form? |
Arrange controls closely together or in a sequence that is easy to read by the user.
Each form should have a different theme.
Make labels descriptive and clear.
Right-align labels followed by a colon and left-align bound controls.
|
15. Which of the following expressions is NOT correct? |
Cost: [Price] * [Qty]
DiscountAmt = [Price] * [Qty] * [Discount]
PrPerSqFt: [SalePr] / [SqFt]
Sales: [GP] * [Qty]
|
16. Which term best describes demographics? |
It is a bar code on a card that contains information about you.
It defines population into segmented groups such as age, income, gender, and race.
It is the quantity of merchandise a store will purchase.
It is tracking customer purchases.
|
17. Which of the following statements best describes data mining? |
It is the determining of future volume of sales.
It is the predicting of future customer buying behavior.
It is identifying patterns or relationships through a process of analyzing large quantities of data.
It is tracking customer purchasing behavior.
|
18. The Switchboard Manager is an Access utility that is used |
by all database users.
to create and manage the menu items for a switchboard.
to make certain objects unavailable to some users and available to others.
to manage and optimize the database.
|
created by scrambling the content.
protected by a password.
saved with a specific file extension.
unreadable if it is opened through a tampering tool or another program.
|
20. All of the following are true when a user creates their own self-signed digital signature EXCEPT |
a time stamp is not required to go through a commercial service or local server for processing.
a time stamp will prove when the file was last used.
it is created through another software application.
it will prove that the creator owns the database.
|
21. To examine the efficiency and performance of an Access database, you should |
migrate the database out of Access and into a larger DBMS.
move the database to its own dedicated server.
redesign your database applying 3NF principles.
use the Performance Analyzer and Table Analyzer to optimize the performance of the database.
|
22. Which of the following is NOT true of a ship date field? |
A ship date is considered a constant.
A ship date would be defined as a date/time field.
A ship date would be defined as a calculated field.
Date arithmetic can be applied to a ship date field.
|