Exam 2: Building a Database and Defining Table Relationships

A primary key field from one table that is also a field in another table and is used to create a relationship between the two tables is a(n) ____________________ in the second table.

Changing the order of fields in a database table is an example of changing a table's ____.

-In the accompanying figure, the primary key for the Vist table is the ____ field.

MATCHING -A record in a table that is related to a prmiary table but has no matching record established with the primary table.

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

In a single table, all ____________________ must be unique within that table.

One rule of ____________________ is that Access prevents the primary key from being changed in the primary table of a relationship if a matching record exists in a related table.

In the Database Design grid, press the Enter key to move from one property to the next property. _________________________

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

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?

External data are data that are imported from a source other than the current database without having to open the source file. _________________________

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

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

-In the accompanying figure, what is the name of the table being edited?

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

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

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

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.

-In the accompanying figure, the default value property for the State field is "CT". _________________________

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