Question 1

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 
A)  produces reports 
B)  contains simple records 
C)  meets the needs of its users 
D)  meets the needs of the designer

Question 2

When text is used as the Default Value for a field property, it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

Students should include at least three o

Question 4

A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut. _________________________

Accepted Answer

A) True 
 B)False

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

Access does not require a field description for every field included in a table.

Accepted Answer

A) True 
 B)False

Question 7

MATCHING
-A group of fields added all at once using the Data Type gallery.

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 8

-In the accompanying figure, which button on the ribbon should be used to add a table to the Relationship window?

Accepted Answer

A)  Show Table 
B)  Edit Relationships 
C)  Direct Relationships 
D)  Relationship Report 
A)  Show Table 
B)  Edit Relationships 
C)  Direct Relationships 
D)  Relationship Report

Question 9

All fields in a database should be contained in one table.

Accepted Answer

A) True 
 B)False

Question 10

-In the accompanying figure, the field size is set to ____.

Accepted Answer

A)  Short text 
B)  InvoiceNum 
C)  General 
D)  5 
A)  Short text 
B)  InvoiceNum 
C)  General 
D)  5

Question 11

Access does not allow data to be imported from sources other than another Access database.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

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

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

-In the accompanying figure, the highlighted record entries illustrate a database design with ____.

Accepted Answer

A)  extremely long character widths 
B)  data redundancy 
C)  a composite primary key 
D)  no field properties 
A)  extremely long character widths 
B)  data redundancy 
C)  a composite primary key 
D)  no field properties

Question 18

A field in an Access database table that has no value is determined by Access to have a ____ value.

Accepted Answer

A)  custom 
B)  zero 
C)  null 
D)  number 
A)  custom 
B)  zero 
C)  null 
D)  number

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

When text is used as the Default Value for a field property, it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message.

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

A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut. _________________________

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

Access does not require a field description for every field included in a table.

MATCHING -A group of fields added all at once using the Data Type gallery.

-In the accompanying figure, which button on the ribbon should be used to add a table to the Relationship window?

All fields in a database should be contained in one table.

-In the accompanying figure, the field size is set to ____.

Access does not allow data to be imported from sources other than another Access database.

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

MATCHING -A primary key that consists of two or more fields in a table.

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

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

-In the accompanying figure, the highlighted record entries illustrate a database design with ____.

A field in an Access database table that has no value is determined by Access to have a ____ value.

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 database management system is a useful tool only if it meets which of the following criteria?

When text is used as the Default Value for a field property, it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message.

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

A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut. _________________________

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

Access does not require a field description for every field included in a table.

MATCHING -A group of fields added all at once using the Data Type gallery.

-In the accompanying figure, which button on the ribbon should be used to add a table to the Relationship window?

All fields in a database should be contained in one table.

-In the accompanying figure, the field size is set to ____.

Access does not allow data to be imported from sources other than another Access database.

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

MATCHING -A primary key that consists of two or more fields in a table.

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

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

-In the accompanying figure, the highlighted record entries illustrate a database design with ____.

A field in an Access database table that has no value is determined by Access to have a ____ value.

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