Question 1

The Report Wizard allows detail records to be sorted by up to four fields. ____________________

Accepted Answer

A) True 
 B)False

Question 2

The most detailed view of a form's structure is available the Layout view. ____________________

Accepted Answer

A) True 
 B)False

Question 3

Formatting used in a report that is applied to certain field values depending on the conditions set for the values is ____ formatting.

Accepted Answer

A)  report 
B)  field 
C)  conditional 
D)  criteria 
A)  report 
B)  field 
C)  conditional 
D)  criteria

Question 4

Carmen and Sergio have created a database for the Spring Fling event at their college. Sergio created forms for Carmen to use when entering data into the database. Carmen needs to create some reports to update the faculty sponsor on the progress that has been made planning the event. The tables and fields for the database along with established relationships are illustrated in the figure below.
  
-By default, data in the reports created by Carmen will be grouped by ____.

Accepted Answer

A)  ParticipantID 
B)  LocationSite 
C)  table 
D)  subtable 
A)  ParticipantID 
B)  LocationSite 
C)  table 
D)  subtable

Question 5

The Columnar form layout displays the fields from one record at a time.

Accepted Answer

A) True 
 B)False

Question 6

Sergio and Carmen are planning the Spring Fling event for their college campus. The event will have exhibits, vendors, and entertainment for students. A database has been created to handle registration for all of the student groups, businesses, and other vendors who will be participating in the Spring Fling. The tables in the database and the fields for each table are illustrated in the figure below.
  
-Sergio wants the form layout to display the fields for only one record at a time. Which form layout should Sergio select?

Accepted Answer

A)  Tabular 
B)  Columnar 
C)  Aligned 
D)  Datasheet 
A)  Tabular 
B)  Columnar 
C)  Aligned 
D)  Datasheet

Question 7

One ____ available for specifying conditional formatting in a report is "Check values in the current record or use an expression."

Accepted Answer

A)  condition type 
B)  rule type 
C)  field format 
D)  field value 
A)  condition type 
B)  rule type 
C)  field format 
D)  field value

Question 8

MATCHING
Insert the letter of the choice that best matches the phrase or definition.
-The feature used to distinguish one record from another in a form.

Accepted Answer

A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Show me more information
G)Find
H)Layout view
I)shading
J)# 
A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Show me more information
G)Find
H)Layout view
I)shading
J)#

Question 9

Viewing and printing options for forms and records are available on the ____ tab.

Accepted Answer

A)  HOME 
B)  PRINT PREVIEW 
C)  DESIGN 
D)  FILE 
A)  HOME 
B)  PRINT PREVIEW 
C)  DESIGN 
D)  FILE

Question 10

After a conditional formatting rule is created using the ____ dialog box, the rule is then available for use in the database from the Conditional Formatting Rules Manager dialog box.

Accepted Answer

A)  New Formatting Rule 
B)  Conditional Formatting Manager 
C)  Report Rules Manager 
D)  Field Conditions Formatting 
A)  New Formatting Rule 
B)  Conditional Formatting Manager 
C)  Report Rules Manager 
D)  Field Conditions Formatting

Question 11

Carmen and Sergio have created a database for the Spring Fling event at their college. Sergio created forms for Carmen to use when entering data into the database. Carmen needs to create some reports to update the faculty sponsor on the progress that has been made planning the event. The tables and fields for the database along with established relationships are illustrated in the figure below.
  
-The faculty sponsor has asked Carmen to email all participants with a balance greater than zero and remind those participants of the due date for payment. Carmen wants to generate a report with participant email addresses only for those participants with a balance greater than zero. Which method would be best for Carmen to use to generate the report?

Accepted Answer

A)  create a form and base the report on the form 
B)  create a report with all participants and manually highlight those with a balance greater than zero 
C)  create a report with only the balance field included 
D)  create a query using a criterion for the balance then create a report based on the query 
A)  create a form and base the report on the form 
B)  create a report with all participants and manually highlight those with a balance greater than zero 
C)  create a report with only the balance field included 
D)  create a query using a criterion for the balance then create a report based on the query

Question 12

Layout view shows both the form and its data while allowing the form to be modified.

Accepted Answer

A) True 
 B)False

Question 13

To design a form using the Form Wizard, begin by clicking on the ____ tab on the Access Ribbon.

Accepted Answer

A)  HOME 
B)  CREATE 
C)  FILE 
D)  EDIT 
A)  HOME 
B)  CREATE 
C)  FILE 
D)  EDIT

Question 14

MATCHING
Insert the letter of the choice that best matches the phrase or definition.
-The button used to display the Find and Replace dialog box.

Accepted Answer

A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Show me more information
G)Find
H)Layout view
I)shading
J)# 
A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Show me more information
G)Find
H)Layout view
I)shading
J)#

Question 15

MATCHING
Insert the letter of the choice that best matches the phrase or definition.
-The view that gives the most detailed view of the structure of a form or report.

Accepted Answer

A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Show me more information
G)Find
H)Layout view
I)shading
J)# 
A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Show me more information
G)Find
H)Layout view
I)shading
J)#

Question 16

A form's object name appears on the tab for the form in the Access window.

Accepted Answer

A) True 
 B)False

Question 17

A report layout may be changed using options on the ____________________ tab.

Accepted Answer

The answer of A report layout may be changed using...

Question 18

Data in a form created from the primary table is contained in the ____.

Accepted Answer

A)  subform 
B)  subdatasheet 
C)  main datasheet 
D)  main form 
A)  subform 
B)  subdatasheet 
C)  main datasheet 
D)  main form

Question 19

Sergio and Carmen are planning the Spring Fling event for their college campus. The event will have exhibits, vendors, and entertainment for students. A database has been created to handle registration for all of the student groups, businesses, and other vendors who will be participating in the Spring Fling. The tables in the database and the fields for each table are illustrated in the figure below.
  
-Which field is the common field for the two tables Sergio used to create the form?

Accepted Answer

A)  LocationSite 
B)  AmountDue 
C)  ParticipantID 
D)  Other 
A)  LocationSite 
B)  AmountDue 
C)  ParticipantID 
D)  Other

Question 20

Carmen and Sergio have created a database for the Spring Fling event at their college. Sergio created forms for Carmen to use when entering data into the database. Carmen needs to create some reports to update the faculty sponsor on the progress that has been made planning the event. The tables and fields for the database along with established relationships are illustrated in the figure below.
  
-The first report Carmen would like to create will include all participants and the balance due to participate in the Spring Fling. Which two tables should Carmen use to create the report?

Accepted Answer

A)  ParticipantAccount and RequestedResources 
B)  ParticipantAccount and Location 
C)  ParticipantInformation and ParticpantAccount 
D)  Location and RequestedResources 
A)  ParticipantAccount and RequestedResources 
B)  ParticipantAccount and Location 
C)  ParticipantInformation and ParticpantAccount 
D)  Location and RequestedResources

The Report Wizard allows detail records to be sorted by up to four fields. ____________________

The most detailed view of a form's structure is available the Layout view. ____________________

Formatting used in a report that is applied to certain field values depending on the conditions set for the values is ____ formatting.

The Columnar form layout displays the fields from one record at a time.

One ____ available for specifying conditional formatting in a report is "Check values in the current record or use an expression."

MATCHING Insert the letter of the choice that best matches the phrase or definition. -The feature used to distinguish one record from another in a form.

Viewing and printing options for forms and records are available on the ____ tab.

After a conditional formatting rule is created using the ____ dialog box, the rule is then available for use in the database from the Conditional Formatting Rules Manager dialog box.

Layout view shows both the form and its data while allowing the form to be modified.

To design a form using the Form Wizard, begin by clicking on the ____ tab on the Access Ribbon.

MATCHING Insert the letter of the choice that best matches the phrase or definition. -The button used to display the Find and Replace dialog box.

MATCHING Insert the letter of the choice that best matches the phrase or definition. -The view that gives the most detailed view of the structure of a form or report.

A form's object name appears on the tab for the form in the Access window.

A report layout may be changed using options on the ____________________ tab.

Data in a form created from the primary table is contained in the ____.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

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 4: Creating Forms and Reports

The Report Wizard allows detail records to be sorted by up to four fields. ____________________

The most detailed view of a form's structure is available the Layout view. ____________________

Formatting used in a report that is applied to certain field values depending on the conditions set for the values is ____ formatting.

The Columnar form layout displays the fields from one record at a time.

One ____ available for specifying conditional formatting in a report is "Check values in the current record or use an expression."

MATCHING Insert the letter of the choice that best matches the phrase or definition. -The feature used to distinguish one record from another in a form.

Viewing and printing options for forms and records are available on the ____ tab.

After a conditional formatting rule is created using the ____ dialog box, the rule is then available for use in the database from the Conditional Formatting Rules Manager dialog box.

Layout view shows both the form and its data while allowing the form to be modified.

To design a form using the Form Wizard, begin by clicking on the ____ tab on the Access Ribbon.

MATCHING Insert the letter of the choice that best matches the phrase or definition. -The button used to display the Find and Replace dialog box.

MATCHING Insert the letter of the choice that best matches the phrase or definition. -The view that gives the most detailed view of the structure of a form or report.

A form's object name appears on the tab for the form in the Access window.

A report layout may be changed using options on the ____________________ tab.

Data in a form created from the primary table is contained in the ____.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

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