Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

In the accompany figure, editing mode is indicated by which numbered arrow?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 4

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

Accepted Answer

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

Question 5

Match between columns
                        Premises: The Access feature that asks a series of questions and creates a report based on the answers to those questions.

Accepted Answer

The Answer of (?) and Layout view and shading and is...

Question 6

Match between columns
                        Premises: The view that gives the most detailed view of the structure of a form or report.

Accepted Answer

The Answer of Report Wizard and # and shading and is...

Question 7

Why is it important to use Print Preview before printing a report in Access?

Accepted Answer

Students might include any of the follow

Question 8

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 9

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 10

In the accompanying figure, which record number is the current record?

Accepted Answer

A)  51 
B)  22539 
C)  33 
D)  06117 
A)  51 
B)  22539 
C)  33 
D)  06117

Question 11

In the accompanying figure, the arrow number 2 indicates the form is displayed in the ____ view.

Accepted Answer

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

Question 12

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 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.
 
By default, data in the reports created by Carmen will be grouped by ____.

Accepted Answer

A)  ParticipantID 
B)  LocationSite 
C)  table 
D)  subtable 
A)  ParticipantID 
B)  LocationSite 
C)  table 
D)  subtable

Question 14

A report formatted where the page is taller than it is wide is formatted in ____.

Accepted Answer

A)  landscape orientation 
B)  primary datasheet orientation 
C)  portrait orientation 
D)  Wizard orientation 
A)  landscape orientation 
B)  primary datasheet orientation 
C)  portrait orientation 
D)  Wizard orientation

Question 15

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 16

In addition to standard colors, the font color gallery displays ____ colors.

Accepted Answer

A)  Pantone 
B)  graphic 
C)  theme 
D)  print 
A)  Pantone 
B)  graphic 
C)  theme 
D)  print

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

In the accompanying figure, which numbered arrow corresponds to the button which, when clicked, moves all Available Fields to the Selected Fields box?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 19

Case-Based Critical Thinking Questions Case 4-1
Sergio and Carmen are planning the Spring Fling event for their college campus. The event will have exhibits, vendors, and entertainment for students. A database has been created to handle registration for all of the student groups, businesses, and other vendors who will be participating in the Spring Fling.  The tables in the database and the fields for each table are illustrated in the figure below.
 
Which field is the common field for the two tables Sergio used to create the form?

Accepted Answer

A)  LocationSite 
B)  AmountDue 
C)  ParticipantID 
D)  Other 
A)  LocationSite 
B)  AmountDue 
C)  ParticipantID 
D)  Other

Question 20

Match between columns
                        Premises: The button used to change the theme of a form from the default theme to another theme in Layout view.

Accepted Answer

The Answer of # and Design view and Find and is...

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

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

In the accompany figure, editing mode is indicated by which numbered arrow?

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

Why is it important to use Print Preview before printing a report in Access?

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.

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

In the accompanying figure, which record number is the current record?

In the accompanying figure, the arrow number 2 indicates the form is displayed in the ____ view.

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

A report formatted where the page is taller than it is wide is formatted in ____.

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

In addition to standard colors, the font color gallery displays ____ colors.

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

In the accompanying figure, which numbered arrow corresponds to the button which, when clicked, moves all Available Fields to the Selected Fields box?

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

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

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

In the accompany figure, editing mode is indicated by which numbered arrow?

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

Why is it important to use Print Preview before printing a report in Access?

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.

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

In the accompanying figure, which record number is the current record?

In the accompanying figure, the arrow number 2 indicates the form is displayed in the ____ view.

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

A report formatted where the page is taller than it is wide is formatted in ____.

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

In addition to standard colors, the font color gallery displays ____ colors.

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

In the accompanying figure, which numbered arrow corresponds to the button which, when clicked, moves all Available Fields to the Selected Fields box?

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