1. The most important function of a database is the ability to _______ the data in order to find the responding data that relates to the question.
a. Create
b. Query
c. Delete
d. Macro
2. _______ are displayed in rows, and each category is known as a field.
a. Files
b. Data types
c. Records
d. Designs
3. when in the single form layout, you will be viewing a:
a. record
b. table
c. field
d. macro
4. An easy way to skip to the last record in a table is to click the forward button in the Navigation:
a. Bar at the bottom of the screen
b. Bar at the top of the screen
c. Pane
d. Group on the home tab ribbon
5. The easiest way to jump from field to field in order to input data when in the single form layout is to use the:
a. Mouse
b. Tab key
c. Ctrl key
d. Spacebar
6. You are nearly finished inputting a new record when you find that you are inputting the wrong information. The easiest way to start over is to press the:
a. Tab key
b. Spacebar
c. Page up key
d. Esc key
7. In order to perform a query on an access database, you must provide a list of:
a. Records
b. Tables
c. Forms
d. Criteria
8. Which of the selections below describes a key difference between viewing data in a table and viewing in a report?
a. The data displayed in a report doesn't match the data found in a table.
b. Tables only show data that has been queried.
c. The data in a report cannot be changed, unlike a table.
d. The data in a table cannot be changed, unlike a report.
9. You want to make formatting changes to the table in your access database by the datasheet formatting dialog box. You need to access this dialog box in the dialog box launcher in the _____ group on the home tab ribbon.
a. Table
b. Cell
c. Font
d. Datasheet
10. What is the maximum number of alpha-numeric characters that you can type into a field in access 2007?
a. 16
b. 55
c. 199
d. 255
11. You click the right arrow button while viewing a table. What happens as a result?
a. A new record is created and displayed as an append row.
b. A new field is created and displayed as an append row.
c. A new field is created and displayed as an append column.
d. A new table is created and is displayed in a new window.
12. What will happen to the data you are viewing in an access table as a result of clicking the A-Z button?
a. Access will perform a search and replace operation.
b. Access will sort the data in alphabetical order.
c. Access will show all the data that matches the input criteria.
d. Access will delete all of the data in the selected field.
13. You are viewing a table made up of nearly two dozen columns. You only want to view half of them in access 2007. you need to highlight the undesired columns and:
a. Press the delete key
b. Click the delete columns button
c. Click the hide fields button
d. Click the hide columns button
14. How do you know if you are viewing filtered or unfiltered data in a table?
a. Look at the filter checkbox in the sort and filter group.
b. Look at the filter button in the sort and filter group.
c. Look at the filter status bar.
d. Look to see if the filter tab appears on the ribbon.
15. You wish to print the filtered data you are viewing. How do you access the print command?
a. Click the print table button on the home tab ribbon.
b. Click the office button and select the print command.
c. Click the print records button on the home tab ribbon.
d. Press the shift + p keys on the keyboard.
16. In order to have a relational database, you must have two or more tables that share:
a. A common field
b. A common record
c. The same data
d. The same filter group
17. You are looking at two tables that are connected to each other after clicking the relationships tab. What does this mean?
a. The two tables were created from the same template.
b. The two tables share date redundancy.
c. The two tables are related.
d. One of the tables was created from the other.
18. What is the easiest way to display fields within a table that has been assigned the date/time data type?
a. Click the filter toggle button and select date and time.
b. Click the filter toggle button and check the date and time checkbox.
c. Click the date picker button.
d. Click the date and time button in the data group.
19. When in report layout view, how can you tell if a label is selected?
a. The label blinks
b. The label is highlighted
c. The label is active
d. The label has an orange border
20. What is a key benefit of the compact and repair tool in access 2007?
a. It eliminates data redundancy
b. It decreases the size of the database file
c. It eliminates non alpha-numeric characters from the records.
d. It converts a 2007 database to the 2003 file format.