Question 1

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 B

Question 2

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

Themes gallery

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 B

Question 4

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 5

The Tabular and Justified form report layouts display the fields from multiple records at one time. ____________________

Accepted Answer

A) True 
 B)False

Question 6

Case-Based Critical Thinking Questions Case 4-2
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.
 
Before printing the report, Carmen uses ____ to view the page breaks and make sure that no records are split across pages.

Accepted Answer

A)  Print Preview 
B)  Layout view 
C)  Design view 
D)  Print Data Only 
A)  Print Preview 
B)  Layout view 
C)  Design view 
D)  Print Data Only

Question 7

Records printed in Form view are distinguished from one another in Print Preview by ____________________.

Accepted Answer

The answer of Records printed in Form view are distinguished...

Question 8

____ is one of the options available from the Page Layout group on the PRINT PREVIEW tab when previewing how a report will print.

Accepted Answer

A)  Changing page orientation 
B)  Changing the report name 
C)  Adding conditional formatting 
D)  Changing font colors 
A)  Changing page orientation 
B)  Changing the report name 
C)  Adding conditional formatting 
D)  Changing font colors

Question 9

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

Question 10

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 11

The REPORT LAYOUT TOOLS tabs are ____ tabs available only when working with report objects.

Accepted Answer

A)  formatting 
B)  design 
C)  alignment 
D)  contextual 
A)  formatting 
B)  design 
C)  alignment 
D)  contextual

Question 12

The appearance of text on a form or report is changed using the Design group on the FORMAT tab on the Ribbon. ____________________

Accepted Answer

A) True 
 B)False

Question 13

Case-Based Critical Thinking Questions Case 4-2
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 14

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

Accepted Answer

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

Question 15

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 16

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 17

In the accompanying figure, the icons and titles shown in bracket number 1 represent which Access database object?

Accepted Answer

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

Question 18

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 19

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 20

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

Accepted Answer

A) True 
 B)False

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

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

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

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

The Tabular and Justified form report layouts display the fields from multiple records at one time. ____________________

Records printed in Form view are distinguished from one another in Print Preview by ____________________.

____ is one of the options available from the Page Layout group on the PRINT PREVIEW tab when previewing how a report will print.

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

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

The REPORT LAYOUT TOOLS tabs are ____ tabs available only when working with report objects.

The appearance of text on a form or report is changed using the Design group on the FORMAT tab on the Ribbon. ____________________

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

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

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

In the accompanying figure, the icons and titles shown in bracket number 1 represent which Access database object?

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

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.

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

Managing Your Files

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 Forms

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 Sharing a Database

Filters

Exam 5: Creating Forms and Reports

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

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

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

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

The Tabular and Justified form report layouts display the fields from multiple records at one time. ____________________

Records printed in Form view are distinguished from one another in Print Preview by ____________________.

____ is one of the options available from the Page Layout group on the PRINT PREVIEW tab when previewing how a report will print.

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

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

The REPORT LAYOUT TOOLS tabs are ____ tabs available only when working with report objects.

The appearance of text on a form or report is changed using the Design group on the FORMAT tab on the Ribbon. ____________________

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

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

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

In the accompanying figure, the icons and titles shown in bracket number 1 represent which Access database object?

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

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.

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

Managing Your Files

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 Forms

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 Sharing a Database

Filters