Question 1

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

Accepted Answer

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

Question 2

Caution should be used when deleting an entire record in Form view because the record will also be deleted in the form's underlying table.
____________________

Accepted Answer

A) True 
 B)False

Question 3

Insert the letter of the choice that best matches the phrase or definition.
-The wildcard character that will match any single numeric character.

Accepted Answer

A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)​! 
A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)​!

Question 4

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 5

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 6

A set of controls grouped together in a form or report that allows manipulation of the set of controls as a single control is a(n)____________________.

Accepted Answer

The answer of A set of controls grouped together in...

Question 7

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)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)​! 
A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)​!

Question 8

When using the Report Wizard,the report title entered in the Wizard is also the name of the report ____________________.

Accepted Answer

The answer of When using the Report Wizard,the report title...

Question 9

To select both a field label and field value to move in a report design,after selecting the field label press the ____ key to select the field value box.

Accepted Answer

A) Ctrl 
B) Alt 
C) F2 
D) Shift 
A) Ctrl 
B) Alt 
C) F2 
D) Shift

Question 10

Insert the letter of the choice that best matches the phrase or definition.
-A report must be in Design view or this view to apply conditional formatting.

Accepted Answer

A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)​! 
A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)​!

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

A form created from two tables that have a ____ relationship creates a main form and a subform.

Accepted Answer

A) one-to-one 
B) one-to-all 
C) many-to-many 
D) one-to-many 
A) one-to-one 
B) one-to-all 
C) many-to-many 
D) one-to-many

Question 13

To print two records from a form,select the ____ option in the Print dialog box.

Accepted Answer

A) Selected Page(s) 
B) Current Page 
C) Range 
D) Selected Record(s) 
A) Selected Page(s) 
B) Current Page 
C) Range 
D) Selected Record(s)

Question 14

Before applying a conditional format in a report,the ____ box must be selected.

Accepted Answer

A) field label 
B) caption 
C) field value 
D) design 
A) field label 
B) caption 
C) field value 
D) design

Question 15

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 16

A form created from more than one table uses the primary table for the main form.____________________

Accepted Answer

A) True 
 B)False

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

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 19

Insert the letter of the choice that best matches the phrase or definition.
-Indicates editing mode.

Accepted Answer

A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)​! 
A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)​!

Question 20

Insert the letter of the choice that best matches the phrase or definition.
-The wildcard character used to match any single alphabetic character.

Accepted Answer

A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)​! 
A) (?) 
B) Themes 
C) Design view 
D) control layout 
E) Report Wizard
F)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)​!

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

Caution should be used when deleting an entire record in Form view because the record will also be deleted in the form's underlying table. ____________________

Insert the letter of the choice that best matches the phrase or definition. -The wildcard character that will match any single numeric character.

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.

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

A set of controls grouped together in a form or report that allows manipulation of the set of controls as a single control is a(n)____________________.

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.

When using the Report Wizard,the report title entered in the Wizard is also the name of the report ____________________.

To select both a field label and field value to move in a report design,after selecting the field label press the ____ key to select the field value box.

Insert the letter of the choice that best matches the phrase or definition. -A report must be in Design view or this view to apply conditional formatting.

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

A form created from two tables that have a ____ relationship creates a main form and a subform.

To print two records from a form,select the ____ option in the Print dialog box.

Before applying a conditional format in a report,the ____ box must be selected.

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

A form created from more than one table uses the primary table for the main form.____________________

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

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.

Insert the letter of the choice that best matches the phrase or definition. -Indicates editing mode.

Insert the letter of the choice that best matches the phrase or definition. -The wildcard character used to match any single alphabetic character.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

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

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

Caution should be used when deleting an entire record in Form view because the record will also be deleted in the form's underlying table. ____________________

Insert the letter of the choice that best matches the phrase or definition. -The wildcard character that will match any single numeric character.

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.

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

A set of controls grouped together in a form or report that allows manipulation of the set of controls as a single control is a(n)____________________.

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.

When using the Report Wizard,the report title entered in the Wizard is also the name of the report ____________________.

To select both a field label and field value to move in a report design,after selecting the field label press the ____ key to select the field value box.

Insert the letter of the choice that best matches the phrase or definition. -A report must be in Design view or this view to apply conditional formatting.

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

A form created from two tables that have a ____ relationship creates a main form and a subform.

To print two records from a form,select the ____ option in the Print dialog box.

Before applying a conditional format in a report,the ____ box must be selected.

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

A form created from more than one table uses the primary table for the main form.____________________

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

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.

Insert the letter of the choice that best matches the phrase or definition. -Indicates editing mode.

Insert the letter of the choice that best matches the phrase or definition. -The wildcard character used to match any single alphabetic character.

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Introduction to Cloud Computing and Office 365

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Internet Basics and Information Literacy

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