WorksheetsAdvanced Database Features
Total questions: 27
Worksheet time: 46mins
Which object would you create to share the data from your database with others?
Form
Report
Query
Table
When you use Lookup values,
______ will appear.
Combo box
textbox
label
toggle text
Which software do you use to make database?
Microsoft Word
Microsoft Excel
Microsoft Publisher
Microsoft Access
Where in the report is the calculated control added?
Header
Footer
In the body of the report
On the right
What is included in a control?
A label
A text box
Both of these
Where are control labels usually located?
Above or to the left of the text box
Below or to the right of the text box
Above or to the right of the text box
Below or to the left of the text box
What automates repetitive tasks that are performed in your database?
A report
A query
A macro
A micro
What security level is best to use for macros to eliminate virus attacks?
Enable all macros
Disable all macros
Enable security
Disable viruses
Can macros be edited after they are created?
Yes
No
A navigation form in a database is similar to navigating through a _______________.
Property panel
Website
Table
Wizard
What is the purpose of a navigation form?
To navigate a spreadsheet
A main menu for the database
To give directions to locations
To hold addresses
What should you decide before designing a navigation form?
Report style
Layout style
Design style
Form style
What do you select in order to modify the background color of a form?
Paste button
Shading button
Properties button
Fill/Back color button
What should a form include?
A header
A footer
Fill back/color
A descriptive title
What tool do you use to create a sub form in Microsoft Access?
Lookup Wizard
Control Wizard
Mail Wizard
Report Wizard
How do you import or export data using Microsoft Access?
Datasheet tab
External Data tab
Database Tools tab
Create tab
In order to import a text file, the data must be organized in rows and __________.
cells
columns
paragraphs
tables
Can you choose to export data with formatting and layout when exporting the database to a text file?
yes
no
