Name______Access Chapter 2 Part 1 Reading Assignment

Name______Access Chapter 2 Part 1 Reading Assignment

1______2______3______4______5______6______

7______8______9______10______11______12______13 ______

1. What are the two general categories of database management systems? (Hint: page 35)

a.file management system and relational database management system

b.server based system and Web based system

c.relational database management system and binary system

d.PC based system and mainframe based system

2. Which of the following features is found in a relation database management system but not in a file management system?

a.indexingb.sequential processing

c.the ability to join tablesd.All of the above

3. A relational database management system eliminates the need for (Hint: page 36)

a.sequential processing.b.multiple tables.

c.indexes.d.data redundancy.

4. Chapter 2 emphasizes that in planning your database and its related tables, it is important to consider

a.what each table is “about.”b.the number of fields in each table.

c.how many records each table will hold.d.the overall size of each table.

5. The ability to relate, or ____ tables is part of what makes Access a relational database system.

a.joinb.mergec.appendd.parse

6. Chapter 2 emphasizes that in planning your database and its related tables, it is important to consider (Hint: page 36)

a.what each table is “about.”b.the number of fields in each table.

c.how many records each table will hold.d.the overall size of each table.

7. Before you create a relationship between tables, you need to (Hint: page 37)

a.backup your database.b.define a primary key in a table.

c.enter fields descriptions for each field in each table.d.sort each table by the first field in the table.

8. A primary key field ____ contain the same value for different records.(Hint: page 37)

a.cannotb.canc.must always

9. For primary keys fields, Access enforces entity integrity, meaning that (Hint: page 37)

a.it expects a value in the primary key field(s) for each record in the table.

b.the values in the primary key field(s) must be numeric and sequential.

c.the primary key fields(s) must be assigned the AutoNumber data type.

d.only letters and numbers can be entered in the primary key field(s).

10. What happens if you try to leave a primary key field blank? (Hint: page 37)

a.Access will automatically fill the field with a random number.

b.Access will not let you close the table until a value is filled in.

c.Access will automatically fill the field using a sequential pattern based on previous entries.

d.Nothing; primary key fields may be left blank.

11. When a relationship is established between two tables, the primary key in one table is joined to the ____ key in the other table.

a.foreignb.clientc.subordinated.secondary

12. In which group will you find the Primary Key button?

a.Show/Hide group in the Table Tools Design tabb.Records group in the Home tab

c.Other group in the Create tabd.Tools group in the Table Tools Design tab

13. Values in a foreign key field ____ be duplicated across records.(Hint: page 37)

a.cannotb.must alwaysc.can