FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Building a Database and Defining Table Relationships

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

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

A) AutoNumber
B) Short Text
C) Yes/No
D) Long Text

E) All of the above
F) B) and D)

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Currency
B) Number
C) Memo
D) Date/Time

E) All of the above
F) A) and B)

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

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?

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

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

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?

Identify the letter of the choice that best matches the phrase or definition.

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

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 field in an Access database table that has no value is determined by Access to have a ____ value.

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

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

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

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.

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

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?

Identify the letter of the choice that best matches the phrase or definition.

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

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.