Question 1

-In the accompanying figure, the fields indicated by the green brackets are fields to be included in the ____.

Accepted Answer

A)  subform 
B)  main form 
C)  related table 
D)  primary table 
A)  subform 
B)  main form 
C)  related table 
D)  primary table

Question 2

A form must be displayed in ____________________ view to navigate, view, and edit data.

Accepted Answer

The answer of A form must be displayed in ____________________...

Question 3

MATCHING
Insert the letter of the choice that best matches the phrase or definition.
-The Access feature that asks a series of questions and creates a report based on the answers to those questions.

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 4

MATCHING
Insert the letter of the choice that best matches the phrase or definition.
-The button used to change the theme of a form from the default theme to another theme in Layout view.

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 5

A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.

Accepted Answer

A) ( #) 
B)  (+) 
C) ( ?) 
D)  (*) 
A) ( #) 
B)  (+) 
C) ( ?) 
D)  (*)

Question 6

Design changes cannot be made to a form in Form view. ____________________

Accepted Answer

A) True 
 B)False

Question 7

The default theme for a form as well as additional themes may be found in the ____________________ when viewing a form in Layout view.

Accepted Answer

The answer of The default theme for a form as...

Question 8

The default theme for a new form that is created is the ____________________ theme.

Accepted Answer

The answer of The default theme for a new form...

Question 9

Briefly explain options available for applying a theme to a form or report and other database objects.

Accepted Answer

Themes may be applied to all m

Question 10

Which Access database object is best to use for the basis of a report when specific criteria must be applied to the report?

Accepted Answer

A)  table 
B)  form 
C)  query 
D)  subdatasheet 
A)  table 
B)  form 
C)  query 
D)  subdatasheet

Question 11

Data in Date/Time fields are automatically ____-aligned.

Accepted Answer

A)  left 
B)  right 
C)  center 
D)  justified 
A)  left 
B)  right 
C)  center 
D)  justified

Question 12

The appearance of fields in a report that is created using the Report Wizard is determined by ____.

Accepted Answer

A)  the order of the fields in the table being used for the report 
B)  the data type of each field in the table 
C)  the size of each field in the table 
D)  the order the fields are selected in the Report Wizard 
A)  the order of the fields in the table being used for the report 
B)  the data type of each field in the table 
C)  the size of each field in the table 
D)  the order the fields are selected in the Report Wizard

Question 13

Which of the following may be used as a wildcard character when searching for a value in Access?

Accepted Answer

A)  % 
B)  # 
C)  ^ 
D)  & 
A)  % 
B)  # 
C)  ^ 
D)  &

Question 14

An item on a form or report object that can be manipulated to modify an object's appearance is a(n) ____.

Accepted Answer

A)  element 
B)  property 
C)  control 
D)  layout 
A)  element 
B)  property 
C)  control 
D)  layout

Question 15

A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based.

Accepted Answer

A)  primary record 
B)  detail record 
C)  secondary table 
D)  record values 
A)  primary record 
B)  detail record 
C)  secondary table 
D)  record values

Question 16

-In the accompanying figure, which Access database object is represented by the icons and titles shown in bracket number 4?

Accepted Answer

A)  Tables 
B)  Queries 
C)  Reports 
D)  Forms 
A)  Tables 
B)  Queries 
C)  Reports 
D)  Forms

Question 17

When using a wildcard character in the Find and Replace dialog box, it is necessary to select the Any Part of Field Match option. ____________________

Accepted Answer

A) True 
 B)False

Question 18

-In addition to standard colors, the font color gallery displays ____ colors.

Accepted Answer

A)  Pantone 
B)  graphic 
C)  theme 
D)  print 
A)  Pantone 
B)  graphic 
C)  theme 
D)  print

Question 19

A ____ is a placeholder used in a search when the search should start or end with a specific character or match a particular pattern.

Accepted Answer

A)  control 
B)  design box 
C)  replace character 
D)  wildcard character 
A)  control 
B)  design box 
C)  replace character 
D)  wildcard character

Question 20

Options for modifying the format of report objects are found on the ____ tab in Layout view when the contextual REPORT LAYOUT TOOLS tab is available.

Accepted Answer

A)  FORMAT 
B)  MODIFY 
C)  DESIGN 
D)  PAGE SETUP 
A)  FORMAT 
B)  MODIFY 
C)  DESIGN 
D)  PAGE SETUP

-In the accompanying figure, the fields indicated by the green brackets are fields to be included in the ____.

A form must be displayed in ____________________ view to navigate, view, and edit data.

MATCHING Insert the letter of the choice that best matches the phrase or definition. -The Access feature that asks a series of questions and creates a report based on the answers to those questions.

MATCHING Insert the letter of the choice that best matches the phrase or definition. -The button used to change the theme of a form from the default theme to another theme in Layout view.

A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.

Design changes cannot be made to a form in Form view. ____________________

The default theme for a form as well as additional themes may be found in the ____________________ when viewing a form in Layout view.

The default theme for a new form that is created is the ____________________ theme.

Briefly explain options available for applying a theme to a form or report and other database objects.

Which Access database object is best to use for the basis of a report when specific criteria must be applied to the report?

Data in Date/Time fields are automatically ____-aligned.

The appearance of fields in a report that is created using the Report Wizard is determined by ____.

Which of the following may be used as a wildcard character when searching for a value in Access?

An item on a form or report object that can be manipulated to modify an object's appearance is a(n) ____.

A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based.

-In the accompanying figure, which Access database object is represented by the icons and titles shown in bracket number 4?

When using a wildcard character in the Find and Replace dialog box, it is necessary to select the Any Part of Field Match option. ____________________

-In addition to standard colors, the font color gallery displays ____ colors.

A ____ is a placeholder used in a search when the search should start or end with a specific character or match a particular pattern.

Options for modifying the format of report objects are found on the ____ tab in Layout view when the contextual REPORT LAYOUT TOOLS tab is available.

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

-In the accompanying figure, the fields indicated by the green brackets are fields to be included in the ____.

A form must be displayed in ____________________ view to navigate, view, and edit data.

MATCHING Insert the letter of the choice that best matches the phrase or definition. -The Access feature that asks a series of questions and creates a report based on the answers to those questions.

MATCHING Insert the letter of the choice that best matches the phrase or definition. -The button used to change the theme of a form from the default theme to another theme in Layout view.

A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.

Design changes cannot be made to a form in Form view. ____________________

The default theme for a form as well as additional themes may be found in the ____________________ when viewing a form in Layout view.

The default theme for a new form that is created is the ____________________ theme.

Briefly explain options available for applying a theme to a form or report and other database objects.

Which Access database object is best to use for the basis of a report when specific criteria must be applied to the report?

Data in Date/Time fields are automatically ____-aligned.

The appearance of fields in a report that is created using the Report Wizard is determined by ____.

Which of the following may be used as a wildcard character when searching for a value in Access?

An item on a form or report object that can be manipulated to modify an object's appearance is a(n) ____.

A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based.

-In the accompanying figure, which Access database object is represented by the icons and titles shown in bracket number 4?

When using a wildcard character in the Find and Replace dialog box, it is necessary to select the Any Part of Field Match option. ____________________

-In addition to standard colors, the font color gallery displays ____ colors.

A ____ is a placeholder used in a search when the search should start or end with a specific character or match a particular pattern.

Options for modifying the format of report objects are found on the ____ tab in Layout view when the contextual REPORT LAYOUT TOOLS tab is available.

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