Question 1

A(n)________ in a form or report is connected to a specific field in a table or query.

Accepted Answer

The answer of A(n)________ in a form or report is...

Question 2

Where would you go to change tab order in a form?

Accepted Answer

A) Design view - Tab order in Tools group 
B) Property sheet 
C) Datasheet view - Tab order in Tools group 
D) Detail section 
A) Design view - Tab order in Tools group 
B) Property sheet 
C) Datasheet view - Tab order in Tools group 
D) Detail section

Question 3

What type of break is used to cause each group to print on a separate page?

Accepted Answer

A) Page 
B) Section 
C) Footer 
D) Report 
A) Page 
B) Section 
C) Footer 
D) Report

Question 4

A(n)________ contains an expression that generates a calculated result.

Accepted Answer

A) calculated control 
B) rectangle control 
C) bound control 
D) unbound control 
A) calculated control 
B) rectangle control 
C) bound control 
D) unbound control

Question 5

Which of the following controls can you use to add emphasis to your form or report?

Accepted Answer

A) Line control and rectangle control 
B) Line control and unbound control 
C) Rectangle control and calculated control 
D) Line control and bound control 
A) Line control and rectangle control 
B) Line control and unbound control 
C) Rectangle control and calculated control 
D) Line control and bound control

Question 6

The ________ appears after adding a grouping to a form or report.

Accepted Answer

A) Group Header 
B) Group Footer 
C) Page Header 
D) Page Footer 
A) Group Header 
B) Group Footer 
C) Page Header 
D) Page Footer

Question 7

How do you switch on or off sections of a report or form?

Accepted Answer

A) Right-click a blank area 
B) Go to the property sheet 
C) Hide the detail section 
D) Grey out a section 
A) Right-click a blank area 
B) Go to the property sheet 
C) Hide the detail section 
D) Grey out a section

Question 8

Forms and reports based on a query can display calculated fields like any other field.

Accepted Answer

A) True 
 B)False

Question 9

Where is the Page Header located?

Accepted Answer

A) Top of each page 
B) Top of form/report 
C) At the end of each group 
D) Bottom of each page 
A) Top of each page 
B) Top of form/report 
C) At the end of each group 
D) Bottom of each page

Question 10

In which section of a form or report is a company logo usually added?

Accepted Answer

Generally in the Form Header o

Question 11

What is a subform?

Accepted Answer

A subform is created using For

Question 12

What is the difference between a form header and a page header?

Accepted Answer

The form footer appears one ti

Question 13

Which of the following controls contains to decorative elements,such as the title of the report?

Accepted Answer

A) Unbound 
B) Bound 
C) Calculated 
D) Rectangle and line 
A) Unbound 
B) Bound 
C) Calculated 
D) Rectangle and line

Question 14

The ________ is the sequential advancing in a form from one field to the next.

Accepted Answer

A) tab order 
B) bound control 
C) unbound control 
D) calculated control 
A) tab order 
B) bound control 
C) unbound control 
D) calculated control

Question 15

Match between columns
                        Premises: calculated control
bound control
tab order
read-only form
unbound control

Accepted Answer

The Answer of a control that is connected to a is...

Question 16

How would you add grouping to a report?

Accepted Answer

A) Group & Sort button 
B) Form footer 
C) Page footer 
D) Form header 
A) Group & Sort button 
B) Form footer 
C) Page footer 
D) Form header

Question 17

What is the reason for making a form read-only?

Accepted Answer

A) Users can lookup information but not modify the data 
B) Users can lookup and edit forms as needed 
C) Users can use the form instead of the table to edit data 
D) Users can add and delete data from the form 
A) Users can lookup information but not modify the data 
B) Users can lookup and edit forms as needed 
C) Users can use the form instead of the table to edit data 
D) Users can add and delete data from the form

Question 18

What is the group footer used for?

Accepted Answer

A) Totaling the data at the end of each group 
B) Totaling the data at the end of each page 
C) Totaling the data at the end of each section 
D) Totaling the data at the end of the form 
A) Totaling the data at the end of each group 
B) Totaling the data at the end of each page 
C) Totaling the data at the end of each section 
D) Totaling the data at the end of the form

Question 19

When choosing fields from two different tables using the Form Wizard,Access automatically assumes you want a form with a subform.

Accepted Answer

A) True 
 B)False

Question 20

What is the difference between a bound control and an unbound control?

Accepted Answer

A bound control is connected t

Exam 36: Access: Advanced Forms and Reports: Moving Beyond the Basics

A(n)________ in a form or report is connected to a specific field in a table or query.

Where would you go to change tab order in a form?

What type of break is used to cause each group to print on a separate page?

A(n)________ contains an expression that generates a calculated result.

Which of the following controls can you use to add emphasis to your form or report?

The ________ appears after adding a grouping to a form or report.

How do you switch on or off sections of a report or form?

Forms and reports based on a query can display calculated fields like any other field.

Where is the Page Header located?

In which section of a form or report is a company logo usually added?

What is a subform?

What is the difference between a form header and a page header?

Which of the following controls contains to decorative elements,such as the title of the report?

The ________ is the sequential advancing in a form from one field to the next.

How would you add grouping to a report?

What is the reason for making a form read-only?

What is the group footer used for?

When choosing fields from two different tables using the Form Wizard,Access automatically assumes you want a form with a subform.

What is the difference between a bound control and an unbound control?

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

Word: Desktop Publishing and Graphic Design: Creating a Newsletter, working With Graphics, and Linking Objects

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

Word: Word and the Internet: Web Page Creation and Enhancement, and Blogs

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

Power: Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Specialized Functions

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Access: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters