1. 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
2. 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
3. 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
4. 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
5. 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*
6. 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&&
7. When you add a calculated field to a query it creates a new:
a. Column
b. Table
c. Form
d. Report
8. 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 criteria
b. Run a second query using the wildcard phrase At*
c. Click the find button in the editing group and search for Atlanta
d. Run the report wizard using Atlanta as the primary key criteria
9. 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
10. What does this button, Aa represent in the control group?
a. A text box
b. A caption
c. A label
d. A font property
11. 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
12. You have added a textbox to a report using the control 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.
13. 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
14. 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
15. 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.
16. Which view will you be working in by default when you use the blank report tool?
a. Design
b. Layout
c. Form
d. Report
17. 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
18. 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.
19. 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
20. In which section of the access options can you access navigation options?
a. Popular
b. Current database
c. Advanced
d. Navigation