FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Building a Database and Defining Table Relationships

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

 Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database. _________________________ 

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

Short Answer

Review LaterAdd Note

Review Later

 The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

 The Currency data type is accurate up to 4 digits on the right side of the decimal point._________________________

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

 Performing a(n) ____________________ is the process of relating tables in a database based on a common field.

 The ____________________ data type is not subject to round-off error when calculated,unlike the Number data type with decimal values.

Identify the letter of the choice that best matches the phrase or definition. - The Access option that deletes a record in the primary table and also deletes all records in related tables that have matching foreign key values.

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

 The default character length for the Short Text data type is ____ characters. 

 By choosing the Definition Only option in the Import Objects dialog box,the ____ of a table is imported,but not the ____. 

 Field names in a table may only be changed in Design view. _________________________ 

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

 A value set in the Field Properties pane that appears in a field automatically is the ____ for the field. 

Identify the letter of the choice that best matches the phrase or definition. - A group of fields added all at once using the Data Type gallery. A)Cascade Update Related Fields Option B)Cascade Delete Related Records Option C)Composite key D)data redundancy E)Data Type gallery F)Design G)orphaned record H)propagate I)Quick Start selection J)referential integrity

Identify the letter of the choice that best matches the phrase or definition. - A primary key that consists of two or more fields in a table.

 The ____ property specifies the number of decimal places displayed to the right of the decimal point. 

 The common field between two tables in the Relationship window is indicated by a(n) ____. 

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

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

 Which data type allows both positive and negative numbers as field values?