Access Test Chapters 1 and 2
Indicate whether the statement is true or false.
____ 1. A collection of fields describing a person, place, object, event, or idea is a table.
____ 2. A single set of field values within a table is a record.
____ 3. A database is a collection of related tables.
____ 4. When two tables are related by a common field, users can tie together facts from the two tables.
____ 5. A DBMS controls the storage of databases on disk by carrying out data creation and manipulation requests.
____ 6. The Access window is the first window that appears when you launch Access.
____ 7. The navigation buttons allow you to step through a table record by record, or to quickly go to the first or last
record in the table.
____ 8. The fastest way to display all fields from an open table on a form is to use the Form Wizard.
____ 9. Records in a database can be displayed in a custom format by creating a form.
____ 10. When designing a database, the first thing you should do is to identify the fields that will be required.
____ 11. Primary keys uniquely identify records in a table.
____ 12. Every table defined in Access must have a primary key.
____ 13. Redundant fields waste storage space and can result in inconsistent data within the database.
____ 14. A common field is a field that is defined as a primary key in one table and is defined as a foreign key in a sec-
____ 15. A field in one table that establishes a relationship to another table is called a redundant field.
____ 16. A field defined as an AutoNumber data type cannot serve as a table’s primary key.
____ 17. Records in a table are stored on disk in the order they are entered but are displayed in primary key sequence.
____ 18. A primary key is allowed to have a null value.
____ 19. Certain Access data types have a predefined field size that cannot be changed.
____ 20. The spacebar works as a toggle for check boxes in Yes/No fields; you press the spacebar to insert a check
mark in an empty check box and to remove an existing check mark. Modified True/False
Indicate whether the statement is true or false. If false, change the identified word or phrase to make the
____ 21. A(n) relational database management system provides protection for your data through the use of security,
control, and recovery facilities. ____________________
____ 22. Databases you create in Access 2007 use the Access 2003 database file format. ____________________
____ 23. Most of the Database window screen components are the same as the components in other Windows pro-
____ 24. Access saves changes to the active database when a record is changed or added and when you close the data-
____ 25. Backing up a database rearranges the data and objects in a database to
decrease its file size, thereby making more space available on your disk and letting you
open and close the database more quickly. ____________________
____ 26. A field name can consist of up to 255 characters. ____________________
____ 27. A primary key that is made up of more than one field is called a(n) aggregate key. ____________________
____ 28. You use a(n) composite field to connect one table logically with another table. ____________________
____ 29. Integer is the default Field Size property setting. ____________________
____ 30. You can import a table from another Access database into your current database using the Import button on
the Ribbon. ____________________
____ 31. When you import a table from one Access database to another, you place a(n) copy of the table in the data-
base into which you import it. ____________________
____ 32. The F5 key is a toggle that you use to switch between the Table Design grid and the Field Properties pane.
____ 33. The data type determines what field values you can enter for the field and what other properties the field will
____ 34. Like calculations with Number data type decimal values, calculations performed with the Currency data type
are not subject to round-off error. ____________________
____ 35. Access allows you to change a field’s size in Datasheet view. ____________________
Identify the choice that best completes the statement or answers the question.
____ 36. When you first open a(n) ____, Access selects the first field value in the first record.
a. object c. query b. datasheet d. macro
____ 37. A field can be described as a(n) ____.
a. object c. attribute
b. record d. table
____ 38. Access allows you to ask questions and obtain information about your data through use of a built-in ____.
a. inquisitor c. table generator
b. query language d. report generator
____ 39. Which of the following is NOT an example of an Access object?
a. report c. form
b. query d. Report tool
____ 40. You open a table, or any Access object by double-clicking the object name in the ____.
a. Views group on the Ribbon c. Navigation Pane
b. Home tab d. Office Button
____ 41. The final step in the creation of a table is to save the table ____ to disk.
a. values c. key set
b. records d. structure
____ 42. Given a relationship between the two tables shown in the figure above, the field values labeled 2 show ____
a. redundant c. variation
b. inconsistent d. irrelevant
____ 43. A field name ____.