Question 1

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

Question 2

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.

Accepted Answer

A)  imported 
B)  readable 
C)  delimited 
D)  external

Question 3

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

Accepted Answer

A)  there is no relationship between tables 
B)  the Excel and Access caption property values to do not match 
C)  the data was entered incorrectly 
D)  the Access field names and the Excel worksheet column headings do not match

Question 4

List six guidelines for designing databases.

Accepted Answer

The answer of  List six guidelines for designing databases....

Question 5

Identify the letter of the choice that best matches the phrase or definition.
- An Access feature available from the FIELDS tab that allows the user to add a group of related fields to a table at the same time.

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

A database management system is a useful tool only if it meets which of the following criteria?

Accepted Answer

A)  produces reports 
B)  contains simple records 
C)  meets the needs of its users 
D)  meets the needs of the designer

Question 8

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 9

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

Accepted Answer

A)  Create 
B)  Database Tools 
C)  External Data 
D)  Home

Question 10

Identify the letter of the choice that best matches the phrase or definition.
- The process that occurs when the field Description (Optional) property is changed in Design View and the Property Update Options tool is used to update the entire database everywhere the field is used,including forms and reports.
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

Accepted Answer

The answer of Identify the letter of the choice that...

Question 11

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?

Accepted Answer

A)  Short Text 
B)  Number 
C)  Yes/No 
D)  Currency

Question 12

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

Accepted Answer

A)  My table 
B)  Table1 
C)  ADB Table 
D)  TableA

Question 13

____________________ view allows the database designer to enter both the field names and define the field properties.

Accepted Answer

The answer of  ____________________ view allows the database designer to...

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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.

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

Question 16

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

Accepted Answer

A)  July 4, 2016 
B)  07/04/16 
C)  7/4/2016 
D)  Jul/04/16

Question 17

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

Question 18

Discuss at least three advantages of including a primary key in a table.

Accepted Answer

The answer of  Discuss at least three advantages of including...

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

The answer of  ____________________ is the process that allows data...

Exam 2: Building a Database and Defining Table Relationships