Exam 3: Building a Database and Defining Table Relationships

In order to define table relationships, each table being joined must contain a common field.

The ____ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition.

A relationship between Access tables that is a relationship between one record in the first table and zero, one, or many records in the second table, and at least one record in the second table matches at most one record in the first table, is defined as a(n) ____ relationship.

Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?

What is the default setting for the Field Size property for a field with the Number data type?

Case-Based Critical Thinking Questions Case 2-1 Akae plans to develop a database for his small DJ business that will include his music catalog, artists, clients, purchases, equipment, and vendors. Akae has identified that the following information will be included in the database: ∙ artist ∙ song and year ∙ client name ∙ client address ∙ client contact information ∙ vendor ∙ purchases ∙ equipment ∙ equipment inventory and rental Given the information Akae would like to include in his database, how many tables would be optimal if similar information is grouped into tables?

Explain how a one-to-many relationship is created using an Access database with two or more tables.  Why is it useful to create a relationship between tables?

Relationship integrit y is a set of rules used by Access to maintaain consistency between related tables when data in either table is updated. _________________________

The Address Quick Start selection adds a group of relationships related to an address including Address, City, State, etc. _________________________

Which data type would be the best logical data type for a field named PaidDate?

A field in an Access database table that has no value is determined by Access to have a ____ value.

Case-Based Critical Thinking Questions Case 2-1 Akae plans to develop a database for his small DJ business that will include his music catalog, artists, clients, purchases, equipment, and vendors. Akae has identified that the following information will be included in the database: ∙ artist ∙ song and year ∙ client name ∙ client address ∙ client contact information ∙ vendor ∙ purchases ∙ equipment ∙ equipment inventory and rental As Akae designs his database, which information group's fields might be added to a table quickly with the Quick Start selection?

The Data Type Gallery, which allows the entry of groups of fields using the Quick Start selection, is only available in Datasheet view.

Access does not allow data to be imported from sources other than another Access database.

Case-Based Critical Thinking Questions Case 2-1 Akae plans to develop a database for his small DJ business that will include his music catalog, artists, clients, purchases, equipment, and vendors. Akae has identified that the following information will be included in the database: ∙ artist ∙ song and year ∙ client name ∙ client address ∙ client contact information ∙ vendor ∙ purchases ∙ equipment ∙ equipment inventory and rental Client contact information should include several fields.  Which of the following field choices would allow client contact data to be separated into the smallest useful parts and provide Akae with the most options for contacting a client?

A primary key that consists of two or more fields is called a(n) redundant key . _________________________

In the accompanying figure, which button on the ribbon should be used to add a table to the Relationship window?

____________________ is the process that allows data to be copied to an Access database table from a source without having to open the source file.