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.

Attachments:

• 1507703591-Assignment 7.rtf