Question 1

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.

Accepted Answer

A)  entered value 
B)  changed value 
C)  default value 
D)  permanent value 
A)  entered value 
B)  changed value 
C)  default value 
D)  permanent value

Question 2

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

Which data type allows the designer to define the Field Size property?

Accepted Answer

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

Question 4

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 5

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 6

A database system determines how to store, display, and process field values based on which of the following?

Accepted Answer

A)  field names 
B)  field properties 
C)  field captions 
D)  field size 
A)  field names 
B)  field properties 
C)  field captions 
D)  field size

Question 7

Access automatically assigns the Number data type to all new fields.

Accepted Answer

A) True 
 B)False

Question 8

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

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 9

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 10

What is the default setting for the Field Size property for a field with the Number data type?

Accepted Answer

A)  2 
B)  Auto 
C)  Long Integer 
D)  15 
A)  2 
B)  Auto 
C)  Long Integer 
D)  15

Question 11

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 12

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

MATCHING
-The Access option that permits a change in the value of the primary key in a table and changes the appropriate foreign key values in the related 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 14

Explain how a one-to-many relationship is created using an Access database with two or more tables. Why is it useful to create a relationship between tables?

Accepted Answer

To create a one-to-many relationship bet

Question 15

List six guidelines for designing databases.

Accepted Answer

1.Identify all the fields needed to prod

Question 16

The field name displayed in database objects, including forms and reports, is determined by the Caption property. _________________________

Accepted Answer

A) True 
 B)False

Question 17

Akae plans to develop a database for his small DJ business that will include his music catalog, artists, clients, purchases, equipment, and vendors. Akae has identified that the following information will be included in the database:
· artist
· song and year
· client name
· client address
· client contact information
· vendor
· purchases
· equipment
· equipment inventory and rental
-As Akae designs his database, which information group's fields might be added to a table quickly with the Quick Start selection?

Accepted Answer

A)  client contact information 
B)  purchases 
C)  song and year 
D)  client address 
A)  client contact information 
B)  purchases 
C)  song and year 
D)  client address

Question 18

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 
A)  July 4, 2016 
B)  07/04/16 
C)  7/4/2016 
D)  Jul/04/16

Question 19

Access does not require a table to have a(n) primary key. _________________________

Accepted Answer

A) True 
 B)False

Question 20

What is the maximum character length of a field name?

Accepted Answer

A)  64 
B)  255 
C)  48 
D)  240 
A)  64 
B)  255 
C)  48 
D)  240

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.

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

Which data type allows the designer to define the Field Size property?

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

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

A database system determines how to store, display, and process field values based on which of the following?

Access automatically assigns the Number data type to all new fields.

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

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

What is the default setting for the Field Size property for a field with the Number data type?

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

MATCHING -A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.

MATCHING -The Access option that permits a change in the value of the primary key in a table and changes the appropriate foreign key values in the related table.

Explain how a one-to-many relationship is created using an Access database with two or more tables. Why is it useful to create a relationship between tables?

List six guidelines for designing databases.

The field name displayed in database objects, including forms and reports, is determined by the Caption property. _________________________

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

Access does not require a table to have a(n) primary key. _________________________

What is the maximum character length of a field name?

Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters

Exam 2: Building a Database and Defining Table Relationships

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.

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

Which data type allows the designer to define the Field Size property?

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

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

A database system determines how to store, display, and process field values based on which of the following?

Access automatically assigns the Number data type to all new fields.

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

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

What is the default setting for the Field Size property for a field with the Number data type?

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

MATCHING -A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.

MATCHING -The Access option that permits a change in the value of the primary key in a table and changes the appropriate foreign key values in the related table.

Explain how a one-to-many relationship is created using an Access database with two or more tables. Why is it useful to create a relationship between tables?

List six guidelines for designing databases.

The field name displayed in database objects, including forms and reports, is determined by the Caption property. _________________________

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

Access does not require a table to have a(n) primary key. _________________________

What is the maximum character length of a field name?

Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters