Question 1

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 2

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 3

Print All,Pages,and Selected Record(s)are options available from the ____ for printing forms.

Accepted Answer

A) PRINT PREVIEW tab 
B) Print dialog box 
C) PRINT LAYOUT tab 
D) Print layout options dialog box 
A) PRINT PREVIEW tab 
B) Print dialog box 
C) PRINT LAYOUT tab 
D) Print layout options dialog box

Question 4

A report formatted in _____________________ is wider than it is tall.

Accepted Answer

landscape

Question 5

Alignment of text in a field value may be changed using the ____________________ tab in the REPORT LAYOUT TOOLS contextual tabs when designing a report.

Accepted Answer

The answer of Alignment of text in a field value...

Question 6

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

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

The ____ is located to the right of the navigation buttons and is used to locate a specific record in a form.

Accepted Answer

A) Record number 
B) Search box 
C) Find box 
D) Locate box 
A) Record number 
B) Search box 
C) Find box 
D) Locate box

Question 10

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 11

It is often easier to maintain data in a datasheet using a form because all changes for a ____ are the focus at one time.

Accepted Answer

A) single table 
B) datasheet layout 
C) single record 
D) subform layout 
A) single table 
B) datasheet layout 
C) single record 
D) subform layout

Question 12

Which of the following characters represents the wildcard character that matches any one of a range of characters in ascending order?

Accepted Answer

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

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

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

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

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

Accepted Answer

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

Question 20

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

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

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

Print All,Pages,and Selected Record(s)are options available from the ____ for printing forms.

A report formatted in _____________________ is wider than it is tall.

Alignment of text in a field value may be changed using the ____________________ tab in the REPORT LAYOUT TOOLS contextual tabs when designing a report.

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.

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

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

The ____ is located to the right of the navigation buttons and is used to locate a specific record in a form.

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.

It is often easier to maintain data in a datasheet using a form because all changes for a ____ are the focus at one time.

Which of the following characters represents the wildcard character that matches any one of a range of characters in ascending order?

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

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

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

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.

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.

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

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

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

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 4: Creating Forms and Reports

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

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

Print All,Pages,and Selected Record(s)are options available from the ____ for printing forms.

A report formatted in _____________________ is wider than it is tall.

Alignment of text in a field value may be changed using the ____________________ tab in the REPORT LAYOUT TOOLS contextual tabs when designing a report.

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.

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

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

The ____ is located to the right of the navigation buttons and is used to locate a specific record in a form.

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.

It is often easier to maintain data in a datasheet using a form because all changes for a ____ are the focus at one time.

Which of the following characters represents the wildcard character that matches any one of a range of characters in ascending order?

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

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

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

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.

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.

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

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

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

Creating a Database

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Formsmodule

Creating Custom Reports

Sharing,integrating,and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters