Exam 2: Building a Database and Defining Table Relationships

 Which of the following is the most logical data type to use if a field will contain long comments or explanations? 

 It is important that data being imported from a text file into Access are separated by a character,such as a comma,which defines the text file as a(n) ____ text file. 

 Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail? 

 List six guidelines for designing databases.

Identify the letter of the choice that best matches the phrase or definition. - An Access feature available from the FIELDS tab that allows the user to add a group of related fields to a table at the same time.

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

 A database management system is a useful tool only if it meets which of the following criteria? 

 The "one" table in a one-to-many relationship is the ____________________ table.

 To begin importing data from an Excel spreadsheet,click on the ____ tab on the ribbon. 

Identify the letter of the choice that best matches the phrase or definition. - The process that occurs when the field Description (Optional) property is changed in Design View and the Property Update Options tool is used to update the entire database everywhere the field is used,including forms and reports. 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

Interns Leah and Santana are organizing a summer camp for children ages 5-10 for their local recreation and parks agency.Participant and payment information is stored in an Excel spreadsheet as children are registered for activities.An Access database contains information about children (participants),parents,employees,as well as activity sessions and schedules.The database contains the following tables: ∙ Participant Information ∙ Parent Information ∙ Employees ∙ Activities - Leah and Santana have been requested to print a daily report of scheduled activities.  Their supervisor needs to know if each participant has paid for the activity.  The ParticipantPD field will be included in the report.  Which data type will allow the report to display a true/false condition for the ParticipantPD field? 

 ____ is the default name for a new table in an Access database. 

 ____________________ view allows the database designer to enter both the field names and define the field properties.

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

Identify the letter of the choice that best matches the phrase or definition. - The term used when the same data is stored in more than one place which can cause inconsistencies in the database.

 A custom date format set for a Date/Time field that contains the symbols mmm/dd/yy would display the date as ____. 

Interns Leah and Santana are organizing a summer camp for children ages 5-10 for their local recreation and parks agency.Participant and payment information is stored in an Excel spreadsheet as children are registered for activities.An Access database contains information about children (participants),parents,employees,as well as activity sessions and schedules.The database contains the following tables: ∙ Participant Information ∙ Parent Information ∙ Employees ∙ Activities - After printing a report of parent information for camper pick-up monitors,Santana decides some of the field names displayed on the report are hard to read.  For example,she prefers the field MotherMobilePhone to be displayed as Mother Cell on the report.  Which field property should be changed to modify the field name display on the report? 

 Discuss at least three advantages of including a primary key in a table.

 Formatting Date/Time fields changes only the way data is displayed,not the field ____. 

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