Exam 2: Building a Database and Defining Table Relationships

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 Currency data type is accurate up to 4 digits on the right side of the decimal point._________________________

 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. - 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.

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