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

By choosing the Definition Only option in the Import Objects dialog box,the ____ of a table is imported,but not the ____. 
A) data, structure
B) data type, structure 
C) structure, data
D) structure, data type

Accepted Answer

By choosing the Definition Only option, only the structure of the table is imported, not the data.

Question 3

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 ____ relationship. 
A) One-to-One
B) One-to-Many 
C) One-to-Most
D) Many-to-One

Accepted Answer

The answer of  A relationship between Access tables that is...

Question 4

The ____________________ Field Size property of a Number field stores positive and negative numbers to precisely seven decimal places in four bytes.

Accepted Answer

The answer of  The ____________________ Field Size property of a...

Question 5

To begin importing data from an Excel spreadsheet,click on the ____ tab on the ribbon. 
A) Create
B) Database Tools 
C) External Data
D) Home

Accepted Answer

The External Data tab on the ribbon contains options for importing data from external sources, including Excel spreadsheets.

Question 6

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? 
A) Input Mask
B) Default Value 
C) Format
D) Caption

Accepted Answer

To modify the field name display on the report, the Caption property should be changed. This will not affect how the information is stored in the database, but only how it is displayed on the report. Input Mask is used to set a specific format for data entry, Default Value sets a value that will appear in the field if no value is entered, and Format specifies how the data in the field should be displayed (such as currency or date format).

Question 7

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.

Accepted Answer

The answer of  A primary key field from one table...

Question 8

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field. 
A) entered value
B) changed value 
C) default value
D) permanent value

Accepted Answer

The default value is the value that appears automatically in a field. It is the value set in the Field Properties pane. Hence, option C is the correct choice.

Question 9

The way field values are stored,displayed,and processed in an Access database is determined by the ____________________.

Accepted Answer

The answer of  The way field values are stored,displayed,and processed...

Question 10

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

Accepted Answer

The answer of  In a single table,all ____________________ must be...

Question 11

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. 
A) imported
B) readable 
C) delimited
D) external

Accepted Answer

A delimited text file is a file where the data is separated by a specific character like a comma, tab or semicolon. When importing this type of file into Access, it is important to specify which character is being used as the delimiter so that the data can be properly separated and imported into the correct fields in the table.

Question 12

Performing a(n) ____________________ is the process of relating tables in a database based on a common field.

Accepted Answer

The answer of  Performing a(n) ____________________ is the process of...

Question 13

Field value maximum storage size is defined by the Field Size property for the data types including Short Text,Number,and ____________________ only.

Accepted Answer

The answer of  Field value maximum storage size is defined...

Question 14

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? 
A) Short Text
B) Number 
C) Yes/No
D) Currency

Accepted Answer

The Yes/No data type is the best choice to display a true/false condition for the ParticipantPD field, which indicates whether or not the participant has paid for the activity. This data type allows for easy and clear display of this binary option on the report.

Question 15

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

Question 16

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.

Accepted Answer

The answer of  One rule of ____________________ is that Access...

Question 17

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

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 19

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

Accepted Answer

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

Question 20

The ____________________ data type is not subject to round-off error when calculated,unlike the Number data type with decimal values.

Accepted Answer

The answer of  The ____________________ data type is not subject...

Quiz 2: Building a Database and Defining Table Relationships