Question 1

Which of the following methods should be used in report Layout view to edit a field caption object that is not fully displayed?

Accepted Answer

A)  resize the object 
B)  delete the object and recreate it 
C)  move the object to another location 
D)  change the caption

Question 2

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)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!

Question 3

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

Accepted Answer

The answer of  A report formatted in _____________________ is wider...

Question 4

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

Accepted Answer

The answer of  Briefly explain options available for applying a...

Question 5

To resize an image without changing its proportions,simply drag  ____ of the image.

Accepted Answer

A)  the left side 
B)  the top 
C)  any corner 
D)  the bottom

Question 6

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)Pencil symbol
G)Find
H)Layout view
I)shading
J)#
K)!

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

Question 8

The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field. ____________________

Accepted Answer

A) True 
 B)False

Question 9

When a form is created based on two or more tables,a relationship must be defined between queries.____________________

Accepted Answer

A) True 
 B)False

Question 10

The first,last,next,or previous page in a report may be displayed using the ____________________ buttons.

Accepted Answer

The answer of  The first,last,next,or previous page in a report...

Question 11

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

Question 12

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

Data in a form may only be modified in ____ view.

Accepted Answer

A)  Form 
B)  Layout 
C)  Design 
D)  Datasheet

Question 17

Access allows all pages,a range of pages,or a currently selected record to be printed from Form view.____________________

Accepted Answer

A) True 
 B)False

Question 18

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)

Question 19

The Form Wizard limits fields to be used in a form to one table or one query. ____________________

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 4: Creating Forms and Reports

Which of the following methods should be used in report Layout view to edit a field caption object that is not fully displayed?

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 report formatted in _____________________ is wider than it is tall.

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

To resize an image without changing its proportions,simply drag ____ of the image.

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.

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.

The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field. ____________________

When a form is created based on two or more tables,a relationship must be defined between queries.____________________

The first,last,next,or previous page in a report may be displayed using the ____________________ buttons.

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

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.

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

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

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

Data in a form may only be modified in ____ view.

Access allows all pages,a range of pages,or a currently selected record to be printed from Form view.____________________

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

The Form Wizard limits fields to be used in a form to one table or one query. ____________________

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