Part 1 of 1 - Question 1 of 205.0 Points In which type of scenario would you place two criteria in the Criteria row when creating a query? A. When

Part 1 of 1 -

Question 1 of 20

5.0 Points

• In which type of scenario would you place two criteria in the Criteria row when creating a query? A. When looking for two separate values
•  B. When using the AND logical operator for both values
•  C. When each criterion is designated for a separate database
•  D. When using the OR logical operator for the two values

Reset Selection

Mark for Review What's This?

Question 2 of 20

5.0 Points

• In which type of scenario would you place two criteria in different rows in the Query design grid? A. When looking for two separate values
•  B. When using the AND logical operator for both values
•  C. When each criterion is designated for a separate database
•  D. When using the OR logical operator for the two values

Reset Selection

Mark for Review What's This?

Question 3 of 20

5.0 Points

• You need to access the Property Sheet button to modify the settings for a form you are creating in order to change the background color of the form. You would access this button in the __________ group of the __________ tab ribbon. A. Tools; Arrange
•  B. Tools; Format
•  C. Formatting; Arrange
•  D. Formatting; Format

Reset Selection

Mark for Review What's This?

Question 4 of 20

5.0 Points

• You need to access the Align Text Center button in order to center the text at the top of a form. You need to access this button in the __________ group of the __________ ribbon. A. Font; Arrange tab
•  B. Font; Form Layout
•  C. Font; Format tab
•  D. Font; Home tab

Reset Selection

Mark for Review What's This?

Question 5 of 20

5.0 Points

• You are running a query on your database. You want to query any customer's last name that starts with an R. What wildcard characters would you type? A. [R]
•  B. *
•  C. R#
•  D. R*

Reset Selection

Mark for Review What's This?

Question 6 of 20

5.0 Points

• You are tracking what numbers have won the lottery every night. There are three numbers in a row and you want to see how many times the winning numbers started with the number 5. How would you query this using a wildcard? A. 5$$
•  B. *
•  C. 5##
•  D. 5&&

Reset Selection

Mark for Review What's This?

Question 7 of 20

5.0 Points

• When you add a calculated field to a query it creates a new: A. column.
•  B. table.
•  C. form.
•  D. report.

Reset Selection

Mark for Review What's This?

Question 8 of 20

5.0 Points

• You have just run a query to find out how many customers spent over $500 this year with you. You now want to see how many of these same customers live in Atlanta. What is the easiest way to do this? A. Run a second query with Atlanta as the criteria.
•  B. Run a second query using the wildcard phrase At*.
•  C. Click the Find button in the Find group and search for Atlanta.
•  D. Run the report wizard using Atlanta as the primary key criteria.

Reset Selection

Mark for Review What's This?

Question 9 of 20

5.0 Points

• A summary statistic could provide which of the following? A. The number of records within a table
•  B. The batting average for the players on a team
•  C. Customers whose first name starts with a J
•  D. The number tables a record is related to

Reset Selection

Mark for Review What's This?

Question 10 of 20

5.0 Points

• What does this button,  represent in the Controls group? A. A text box
•  B. A caption
•  C. A label
•  D. A font property

Reset Selection

Mark for Review What's This?

Question 11 of 20

5.0 Points

• You are creating a report in Access 2007 but you see all of the tools you need to configure the report as you want. What can you do? A. Import the tools you need from the Microsoft Web site.
•  B. Click on the Additional Tool button on the Database Tools tab ribbon.
•  C. Click on the Hidden Tool button on the Database Tools tab ribbon.
•  D. Switch to Design view to see additional tools on the Design tab ribbon.

Reset Selection

Mark for Review What's This?

Question 12 of 20

5.0 Points

• You have added a textbox to a report using the Controls group tools. You want to change the placement of the text box. How do you do this? A. Click the indent buttons on the Home tab ribbon.
•  B. Click the movement buttons on the Home tab ribbon.
•  C. Press the arrow keys on the keyboard.
•  D. Press the Tab key on the keyboard.

Reset Selection

Mark for Review What's This?

Question 13 of 20

5.0 Points

• You insert a label into the report footer of an Access report. Where will it be displayed? A. On the first page of the report
•  B. On the last page of the report
•  C. In the footer section of every page
•  D. In the report notes summary

Reset Selection

Mark for Review What's This?

Question 14 of 20

5.0 Points

• You insert a text box into the page header. Where will it be displayed? A. On the first page of the report
•  B. On the last page of the report
•  C. In the header section of every page
•  D. In the page notes summary

Reset Selection

Mark for Review What's This?

Question 15 of 20

5.0 Points

• You want to configure conditional formatting for the fonts in an Access report. How do you access this setting? A. Click the Conditional button in the Font group on the Design tab ribbon.
•  B. Click the Conditional button in the Font group on the Home tab ribbon.
•  C. Click the Font button arrow on the Home tab ribbon and choose conditional formatting.
•  D. Click the Font button arrow on the Design tab ribbon and choose conditional formatting.

Reset Selection

Mark for Review What's This?

Question 16 of 20

5.0 Points

• Which view will you be working in by default when you use the Blank Report tool? A. Design
•  B. Layout
•  C. Form
•  D. Report

Reset Selection

Mark for Review What's This?

Question 17 of 20

5.0 Points

• Which of the selections below is NOT a tool found in the Controls Group? A. Date and Time button
•  B. Title button
•  C. Gridlines button
•  D. Logo button

Reset Selection

Mark for Review What's This?

Question 18 of 20

5.0 Points

• You want to use a chart in a report to visually display the data from a recent query. What is the easiest way to do this? A. Click the Import Chart button in the Controls group and select Excel Chart.
•  B. Click the Import Chart button in the Controls group and select PowerPoint Chart.
•  C. Use the PowerPoint Chart Wizard tool located on the Create tab ribbon.
•  D. Click the Chart Wizard button in the Controls group.

Reset Selection

Mark for Review What's This?

Question 19 of 20

5.0 Points

• How do you access the Access Options dialog box? A. Click the Access Options button on the Design tab ribbon.
•  B. Click the Access Options button on the Arrange tab ribbon.
•  C. Click the Access Options button on the Create tab ribbon.
•  D. Click the Access Options button after pressing the Office button.

Reset Selection

Mark for Review What's This?

Question 20 of 20

5.0 Points

• In which section of the Access Options can you access Navigation Options? A. Popular
•  B. Current Database
•  C. Advanced
•  D. Navigation

Reset Selection

Mark for Review What's This?