Exam 2: Access Module : Building a Database and Defining Table Relationships

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?

A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut .

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?

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

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 database system determines how to store, display, and process field values based on which of the following?

Discuss at least three advantages of including a primary key 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 -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?

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

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

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

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

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

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

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

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

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

List six guidelines for designing databases.

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.