Exam 2: Building a Database and Defining Table Relationships

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

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

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

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?

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

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.

The F6 key toggles the Access table workspace between the Table Design grid and the Field Properties pane. _________________________

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

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.

____________________ values are never allowed by Access in the primary key field.

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

The field name displayed in database objects,including forms and reports,is determined by the Caption property._________________________

A field used to connect one table logically with another table is called a ____ field.

Identify the letter of the choice that best matches the phrase or definition. -The Access option that permits a change in the value of the primary key in a table and changes the appropriate foreign key values in the related table.

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

Which data type allows the designer to define the Field Size property?

Access does not require a field description for every field included in a table. _________________________

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 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 is not subject to round-off error when calculated,unlike the Number data type with decimal values.