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 on relationships button on the home tab ribbon
c. Click on trust design button on the home tab ribbon
d. Click the table layout button on the database tool tab ribbon
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
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
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
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
6. Which of the mathematical operators below is used as a comparison operator for queries in access?
a. +
b. >
c. *
d. /
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 inputted in military time format.
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 about the ribbon tabs
b. Query report toolbar
c. Query status toolbar
d. Data view toolbar
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
10. When running reports, the _______ view allows for more precision.
a. Layout
b. Design
c. Precision
d. Details
11. The controls group is located on which access taps ribbon?
a. Home
b. Create
c. External data
d. Design
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
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
14. The following button in access 2007, the run button is use to run:
a. Reports
b. The analyzer tool
c. Macros
d. Queries
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
16. The text button use to align text within a report is located in the ____ group.
a. Text
b. Font
c. Control
d. Styles
17. The group and sort button is located on the ______ tab ribbon.
a. Database tools
b. Format
c. Arrange
d. Page setup
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
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
20. To make the file visible in a web browser, you should export the report as a:
a. RTF file
b. Notepad tile
c. HTML document
d. TXT file