Question 1

What is the easiest way to view all the relationships between the tables in your Access database?
A. Click the Relationships button on the Database Tools tab ribbon.
B. Click the Relationships button on the Home tab ribbon.
C. Click the Trust Design button on the Home tab ribbon.
D. Click the Table Layout button on the Database Tool tab ribbon.

Question 2

The easiest way for the Access novice to create a query in Access 2007 is to click the __________ button on the __________ tab ribbon.
A. Query Wizard; Database Tools
B. Query Wizard; Create
C. Simple Query; Database Tools
D. Simple Query; Create

Question 3

When you create a query in Access, you are essentially:
A. finding relationships between multiple tables.
B. finding related data among multiple tables.
C. asking the database a question.
D. creating a relationship report.

Question 4

You wish to create a label report. Labels in Access 2007 are identified by:
A. how they relate to a table.
B. how they are related to the database.
C. manufacturer and product number.
D. the auto number assigned by Access.

Question 5

You wish to print the first two pages of a label report created in Access 2007. The place to specify the pages to print is in the:
A. Office button menu.
B. Label Report View box.
C. Print Preview box.
D. Print Dialog box.

Question 6

Which of the mathematical operators below is used as a comparison operator for queries in Access?
A. +
B. >
C. *
D. /

Question 7

You are inputting Date/Time data type criteria for the desired fields when creating a query. What is special about the Date/Time data type?
A. The date and time must be separated by commas.
B. The date values are surrounded by the # symbol.
C. The date and time values are surrounded by the % symbol.
D. The time must be inputted in military time format.

Question 8

You have just run a query on your database and you want to save the results. The save button is on the:
A. Quick Access Tool above the ribbon tabs.
B. Query Report toolbar
C. Query Status toolbar.
D. Data View toolbar.

Question 9

You have run a report using the Report Wizard in Access 2007. The report has a column showing a series of dollar amounts but all that shows is a series of ######## symbols instead. What must you do to correct this?
A. Rerun the report using the correct data type format.
B. Rerun the report, this time checking the Show Currency checkbox.
C. Drag the column border to make the column wider.
D. Rerun the report selecting the correct fields.

Question 10

When running reports, the __________view allows for more precision.
A. layout
B. design
C. precision
D. details

Question 11

The Controls group is located on which Access tab ribbon?
A. Home
B. Create
C. External Data
D. Design

Question 12

Rather than dragging controls with the mouse to their desired position, you can utilize the:
A. control alignment tools.
B. control placement tools.
C. control insert drop box.
D. control group insert button.

Question 13

You are running a query in Access 2007. A Dialog box is requesting you to input your criteria. What type of query are you running?
A. Control group query
B. Input query
C. Parameter query
D. Results query

Question 14

The following button in Access 2007, ! is used to run:
A. reports.
B. the analyzer tool.
C. macros.
D. queries.

Question 15

One benefit of building a report on a Parameter Query is that you can:
A. select from multiple database sources.
B. display a variety of results from a single query.
C. display the results with input from the user.
D. run reports in silent mode.

Question 16

The Text button used to align text within a Report is located in the __________ group.
A. Text
B. Font
C. Control
D. Styles

Question 17

The Group and Sort button is located on the __________ tab ribbon.
A. Database Tools
B. Format
C. Arrange
D. Page Setup

Question 18

You have assigned a Null value to a field for a report. This means the field:
A. has a negative value.
B. has a non-numeric value.
C. has been configured for sorting.
D. is empty and has no value.

Question 19

You want to export an Access report that will preserve the text formatting of the report. What type of file should you choose?
A. RTF file
B. TXT file
C. DOC file
D. DOCX file

Question 20

To make the file visible in a Web browser, you should export the report as a:
A. RTF file.
B. NotePad file.
C. HTML document.
D. TXT file.