FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Building a Database and Defining Table Relationships

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

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.

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

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

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

A) AutoNumber
B) Short Text
C) Yes/No
D) Long Text

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

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

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

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

The default Field Size for the Short Text data type is ____________________ characters.

The Data Type Gallery,which allows the entry of groups of fields using the Quick Start selection,is only available in Datasheet view. _________________________

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?

Field name display in database objects such as datasheets,forms,and reports is determined by the ____________________ property.

The ____ property allows the database designer to explain the purpose of a field or how a field is used.

When choosing field names,it is best to choose names that ____.

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

Which symbols would be used to create a custom date format that would display July 4,2016 as 7/04/16?

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

Identify the letter of the choice that best matches the phrase or definition. -A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.