Question 1

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

Accepted Answer

The answer of The "one" table in a one-to-many relationship...

Question 2

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.

Accepted Answer

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

Question 3

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.

Accepted Answer

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

Question 4

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

Accepted Answer

A) include both numbers and letters in the name 
B) use only uppercase characters 
C) describe the content or purpose of the field 
D) use only lowercase letters and no spaces 
A) include both numbers and letters in the name 
B) use only uppercase characters 
C) describe the content or purpose of the field 
D) use only lowercase letters and no spaces

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

A) Hyperlink 
B) Short Text 
C) Memo 
D) Long Text 
A) Hyperlink 
B) Short Text 
C) Memo 
D) Long Text

Question 8

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

Accepted Answer

A) Data type 
B) Field size 
C) Required 
D) Description 
A) Data type 
B) Field size 
C) Required 
D) Description

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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?

Accepted Answer

A) Input Mask 
B) Default Value 
C) Format 
D) Caption 
A) Input Mask 
B) Default Value 
C) Format 
D) Caption

Question 11

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

Accepted Answer

The answer of Field name display in database objects such...

Question 12

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

Accepted Answer

A) mm/dd/yyyy 
B) m/ddd/yy 
C) mmm/d/yyyy 
D) m/dd/yy 
A) mm/dd/yyyy 
B) m/ddd/yy 
C) mmm/d/yyyy 
D) m/dd/yy

Question 13

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

Accepted Answer

A) Decimal Places 
B) Input Mask 
C) Default Value 
D) Format 
A) Decimal Places 
B) Input Mask 
C) Default Value 
D) Format

Question 14

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

Accepted Answer

A) values 
B) letters 
C) numbers 
D) mask 
A) values 
B) letters 
C) numbers 
D) mask

Question 15

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

Accepted Answer

The answer of The default Field Size for the Short...

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

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.

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.

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

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

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

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

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

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

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

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

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.

Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 2: Building a Database and Defining Table Relationships

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

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.

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.

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

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

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

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

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

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

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

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

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.

Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters