Question 1

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

Question 2

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

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

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 6

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 7

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 8

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 9

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 Definition Only option, only the structure of the table is imported, not the accompanying data.

Question 10

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 is where you can access options to import data from sources such as Excel. The other tabs listed do not have specific import options.

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

When data is separated by a specific character in a text file, it is considered a delimited text file. Access allows for the import of delimited text files by recognizing the separator character and importing the data into appropriate fields. Therefore, the best choice would be C, delimited.

Question 12

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

Question 13

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

The Caption field property should be changed to modify the field name display on the report. This property allows for the creation of a more user-friendly field name display, without changing the actual field name in the table or database. The Input Mask property is used to format data entry in a specific way, such as for phone numbers or social security numbers. The Default Value property is used to set the default value for a field. The Format property is used to control the format of data displayed in a field, such as for currency or dates.

Question 15

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 as it allows for the creation of checkboxes in forms and reports, which can be checked to indicate a positive response (such as "paid") and unchecked to indicate a negative response (such as "not paid").

Question 16

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 set in the Field Properties pane that appears in a field automatically.

Question 17

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 18

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 19

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 20

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

Accepted Answer

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

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