Microsoft Office Access Version 2003
1. A table is made up of
A. fields and records.
B. queries and fields.
C. records and reports.
D. forms and fields.
2. A database is stored within a table.
A. True
B. False
3. The Database window allows you to
A. link two tables.
B. navigate to objects and create new objects.
C. find answers to questions about Access.
D. create a new database.
4. To move to the previous field in a record, you use
A. the Left arrow key.
B. Shift+Tab.
C. the mouse.
D. All of the above are correct.
5. If you don’t click the Save button when entering data into a datasheet, the data will be lost.
6. In Datasheet view, a(n) __________ appears to the left of a record to show the current status of the record.
A. row selector
B. insertion point
C. data type
D. record selector
7. You should __________ before creating a database.
A. design a table using Design view
B. design a table using the Table Wizard
C. think about how the database will be organized
D. add fields to a database
8. If you delete a field with data in it, all the information in the field will also be deleted.
9. You create a table __________ or by using the Table Wizard.
A. from scratch in Datasheet view
B. from scratch in Design view
C. by using the Database Wizard
D. by using a template
10. A data type is
A. another word for field.
B. a setting that determines what kind of data a field can contain.
C. a type of database application.
D. a generic term that describes the names of fields that the Access Table Wizard allows you to choose from.
11. You add or edit records in Design view.
12. The __________ data type can be used to automatically generate numbers for each new record.
A. Number
B. Hyperlink
C. AutoNumber
D. Memo
13. To organize data in order from highest to lowest value, you click the __________ button.
A. Filter By Form
B. Filter By Selection
C. Sort Ascending
D. Sort Descending
14. The __________ field property will automatically enter a value into a field in a new record.
A. Field Size
B. Format
C. Caption
D. Default Value
15. The Filter By Selection button allows you to
A. find the selected value.
B. type the value to use as the filter.
C. filter based on the contents of the currently selected field.
D. organize data in alphabetical or numerical order.
16. The row in the Query Design view window that can be used to restrict the data that appears in the query results is called the __________ row.
A. Sort
B. Show
C. Criteria
D. Field
17. You type __________ in the Criteria row to restrict the query results to records containing values greater than 30.
A. >=30
B. <=30
C. >30
D. <30
18. What must be true in order for Access to automatically join two fields from different tables in the Query Design view window?
A. The two fields must contain identical values and at least one of them must be a primary key.
B. The two fields must contain identical values and neither of them should be a primary key.
C. The two tables containing the fields are in a one-to-many relationship.
D. The two tables containing the fields are in a one-to-one relationship.
19. The criteria t[iou]p will find
A. tulip.
B. tap.
C. typ.
D. top.
20. If you wanted to display all the records containing the letters smi anywhere in the LastName field, you would type __________ in the Criteria row.
A. smi
B. *smi*
C. *smi
D. smi*
21. If you specify criteria in more than one field at a time, the query results will
A. include only records that match none of the criteria.
B. include only records that match the first criteria.
C. include only records that match all of the criteria.
D. show an error message.
22. A character used in query criteria to represent one or more other characters is called a(n)
A. placeholder.
B. algorithm.
C. selector.
D. wildcard.