BTM 481 Lecture Notes - Mail Merge, Relational Database Management System, Unique Key
76 views7 pages
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.
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