Databases Chapter 2- Concept Exam

How are relationships indicated in the Relationships window?

A black line connects the table field list boxes.

What happens if a primary key field is left blank?

Access will not allow closing the database until a value is entered in the field.

Which of the following steps should be performed first to edit a relationship?

Click the Relationships button.

In defining a primary key, which step do you complete just before you click the Primary Key button?

Click the field

In defining a one-to-many relationship between two tables, what is the next step after placing the two tables in the Relationships window?

Drag the common field from the primary table to the related table.

To display subdatasheets for all records in the primary table, begin by clicking the

More button in the Records group on the Home tab.

What is done at the Show Table dialog box?

Tables are added to the Relationships window.

Relationships between tables are edited

at the Edit Relationships dialog box.

When you perform a join, you are

establishing a relationship between tables.

What are the two general categories of database management systems?

file management and relational database management systems

File management systems are sometimes referred to as

flat file databases

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

foreign

A one-to-one relationship is _____ a one-to-many relationship.

not as common

If a value is not entered in a field, Access enters a

null value

A table should be about _____ subject(s).

one

The _____ integrity rules ensure that a record added to a related table has a matching record in the primary table.

referential

Access is a(n) _____ database management system in which relationships are defined between sets of data.

relational

Changes made to fields in a _____ affect the table and any related tables.

subdatasheet

In planning a database and its related tables, it is important to consider

what each table is about.

In which situation would using a one-to-one relationship be helpful?

when you need to divide a large table with many fields into two separate tables