FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Creating Forms and Reports

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

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.

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

E) B) and D)
F) B) and C)

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

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

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

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

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

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

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

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

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

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

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

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

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

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?

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.

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

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

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

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