BTM 481 Lecture Notes - Mail Merge, Relational Database Management System, Unique Key

76 views7 pages
Access Test Chapters 1 and 2
True/False
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-
ond table.
____ 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.
Unlock document

This preview shows pages 1-2 of the document.
Unlock all 7 pages and 3 million more documents.

Already have an account? Log in
Modified True/False
Indicate whether the statement is true or false. If false, change the identified word or phrase to make the
statement true.
____ 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-
grams. ____________________
____ 24. Access saves changes to the active database when a record is changed or added and when you close the data-
base. ____________________
____ 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
have. ____________________
____ 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. ____________________
Multiple Choice
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
Unlock document

This preview shows pages 1-2 of the document.
Unlock all 7 pages and 3 million more documents.

Already have an account? Log in

Get access

Grade+
$10 USD/m
Billed $120 USD annually
Homework Help
Class Notes
Textbook Notes
40 Verified Answers
Study Guides
1 Booster Class
Class+
$8 USD/m
Billed $96 USD annually
Homework Help
Class Notes
Textbook Notes
30 Verified Answers
Study Guides
1 Booster Class