Part 1 of 1 –
Question 1 of 20
5.0 Points
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. Reset Selection
Mark for Review What’s This?
Question 2 of 20
5.0 Points
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 Reset Selection
Mark for Review What’s This?
Question 3 of 20
5.0 Points
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. Reset Selection
Mark for Review What’s This?
Question 4 of 20
5.0 Points
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. Reset Selection
Mark for Review What’s This?
Question 5 of 20
5.0 Points
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. Reset Selection
Mark for Review What’s This?
Question 6 of 20
5.0 Points
Which of the mathematical operators below is used as a comparison operator for queries in Access?
A. +
B. >
C. *
D. / Reset Selection
Mark for Review What’s This?
Question 7 of 20
5.0 Points
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. Reset Selection
Mark for Review What’s This?
Question 8 of 20
5.0 Points
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. Reset Selection
Mark for Review What’s This?
Question 9 of 20
5.0 Points
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. Reset Selection
Mark for Review What’s This?
Question 10 of 20
5.0 Points
When running reports, the __________view allows for more precision.
A. layout
B. design
C. precision
D. details Reset Selection
Mark for Review What’s This?
Question 11 of 20
5.0 Points
The Controls group is located on which Access tab ribbon?
A. Home
B. Create
C. External Data
D. Design Reset Selection
Mark for Review What’s This?
Question 12 of 20
5.0 Points
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. Reset Selection
Mark for Review What’s This?
Question 13 of 20
5.0 Points
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 Reset Selection
Mark for Review What’s This?
Question 14 of 20
5.0 Points
The following button in Access 2007, is used to run:
A. reports.
B. the analyzer tool.
C. macros.
D. queries. Reset Selection
Mark for Review What’s This?
Question 15 of 20
5.0 Points
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. Reset Selection
Mark for Review What’s This?
Question 16 of 20
5.0 Points
The Text button used to align text within a Report is located in the __________ group.
A. Text
B. Font
C. Control
D. Styles Reset Selection
Mark for Review What’s This?
Question 17 of 20
5.0 Points
The Group and Sort button is located on the __________ tab ribbon.
A. Database Tools
B. Format
C. Arrange
D. Page Setup Reset Selection
Mark for Review What’s This?
Question 18 of 20
5.0 Points
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. Reset Selection
Mark for Review What’s This?
Question 19 of 20
5.0 Points
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 Reset Selection
Mark for Review What’s This?
Question 20 of 20
5.0 Points
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. Reset Selection
Mark for Review What’s This?
