Question 1

Adding a(n) ________ Break control can insure that your report is paginated correctly.

Accepted Answer

The answer of Adding a(n) ________ Break control can insure...

Question 2

Given a five-page report, with two grouping levels, and the detail property set to hidden, match the following with the number of times they would appear in this report:
I. Page header/footer section(s)
II. Report header/footer section(s)
III. Sections (total)
IV. Group header/footer section(s)
V. Detail section
A. 1
B. 4
C. 5
D. 0
E. 2

Accepted Answer

The answer of Given a five-page report, with two grouping...

Question 3

What word would not describe an unbound control?

Accepted Answer

A)  Static 
B)  Unchanging 
C)  Dynamic 
D)  Decorative 
A)  Static 
B)  Unchanging 
C)  Dynamic 
D)  Decorative

Question 4

What is the name of the button/command in the Tab Order dialog box that allows Access to reorder your tabs as it see fit?

Accepted Answer

A)  Tab Order 
B)  Custom Order 
C)  Auto Order 
D)  Auto Tabs 
A)  Tab Order 
B)  Custom Order 
C)  Auto Order 
D)  Auto Tabs

Question 5

Match the following desired outcomes with the controls that would be used to produce that outcome:
I. Force new pages to start at the end of each group
II. Display a nice purple line after the data section
III. Allow the user to choose options from a list during data entry
IV. Decide how much a 10% raise would be for each employee
V. Add descriptive text to explain a field which displays travel pictures
A. Line
B. Calculated control in a Text box
C. Combo Box
D. Page Break
E. Label

Accepted Answer

The answer of Match the following desired outcomes with the...

Question 6

Which of the following is not a reason to restrict who can edit data in a form?

Accepted Answer

A)  Data can become unreliable. 
B)  Data can become hard to maintain. 
C)  The wrong people might be able to delete the records. 
D)  The file will get too large. 
A)  Data can become unreliable. 
B)  Data can become hard to maintain. 
C)  The wrong people might be able to delete the records. 
D)  The file will get too large.

Question 7

Which of the following would you typically not find in a calculated control?

Accepted Answer

A)  Aggregate function 
B)  Simple math 
C)  Function using the Expression Builder 
D)  Image 
A)  Aggregate function 
B)  Simple math 
C)  Function using the Expression Builder 
D)  Image

Question 8

A graphic line can be considered a form control.

Accepted Answer

A) True 
 B)False

Question 9

Which view gives the database designer more control over the look of the form or report?

Accepted Answer

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

Question 10

If you had a five-page report, which of the following statements is true?

Accepted Answer

A)  The form header and/or footer would display twice; one on the first page and one on the last page. 
B)  The page header and/or footer would display twice; one on the first page and one on the last page. 
C)  The form header and/or footer would display five times. 
D)  The page header and/or footer would display five times. 
A)  The form header and/or footer would display twice; one on the first page and one on the last page. 
B)  The page header and/or footer would display twice; one on the first page and one on the last page. 
C)  The form header and/or footer would display five times. 
D)  The page header and/or footer would display five times.

Question 11

Which of the following views is not used with forms or reports?

Accepted Answer

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

Question 12

Page headers and footers are turned ________ by default for forms.

Accepted Answer

The answer of Page headers and footers are turned ________...

Question 13

Unbound controls are connected to specific fields in a table or query.

Accepted Answer

A) True 
 B)False

Question 14

A form that enables users to view but not change data is a(n) ________ form.

Accepted Answer

read-only,

Question 15

What type of control is created if you create a form based on a table with a lookup field?

Accepted Answer

A)  Check Box 
B)  Option button 
C)  Combo Box 
D)  Lookup Box 
A)  Check Box 
B)  Option button 
C)  Combo Box 
D)  Lookup Box

Question 16

Where do you typically put a page break?

Accepted Answer

A)  Page footer 
B)  Group footer 
C)  Group header 
D)  Section footer 
A)  Page footer 
B)  Group footer 
C)  Group header 
D)  Section footer

Question 17

When the Allow Edit property of a form is set to No, no new records can be added.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following are not customizations you can make to a form?

Accepted Answer

A)  Change the tab order 
B)  Convert a form to a report 
C)  Convert a text box to a menu 
D)  Make a form read-only 
A)  Change the tab order 
B)  Convert a form to a report 
C)  Convert a text box to a menu 
D)  Make a form read-only

Question 19

________ controls are not connected to fields in a table or query.

Accepted Answer

The answer of ________ controls are not connected to fields...

Question 20

A form that enables users to view but not change data is a restrict-only form.

Accepted Answer

A) True 
 B)False

Adding a(n) ________ Break control can insure that your report is paginated correctly.

What word would not describe an unbound control?

What is the name of the button/command in the Tab Order dialog box that allows Access to reorder your tabs as it see fit?

Which of the following is not a reason to restrict who can edit data in a form?

Which of the following would you typically not find in a calculated control?

A graphic line can be considered a form control.

Which view gives the database designer more control over the look of the form or report?

If you had a five-page report, which of the following statements is true?

Which of the following views is not used with forms or reports?

Page headers and footers are turned ________ by default for forms.

Unbound controls are connected to specific fields in a table or query.

A form that enables users to view but not change data is a(n) ________ form.

What type of control is created if you create a form based on a table with a lookup field?

Where do you typically put a page break?

When the Allow Edit property of a form is set to No, no new records can be added.

Which of the following are not customizations you can make to a form?

________ controls are not connected to fields in a table or query.

A form that enables users to view but not change data is a restrict-only form.

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Get Connected

Fine-Tuning the Database

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters

Exam 7: Advanced Forms and Reports

Adding a(n) ________ Break control can insure that your report is paginated correctly.

What word would not describe an unbound control?

What is the name of the button/command in the Tab Order dialog box that allows Access to reorder your tabs as it see fit?

Which of the following is not a reason to restrict who can edit data in a form?

Which of the following would you typically not find in a calculated control?

A graphic line can be considered a form control.

Which view gives the database designer more control over the look of the form or report?

If you had a five-page report, which of the following statements is true?

Which of the following views is not used with forms or reports?

Page headers and footers are turned ________ by default for forms.

Unbound controls are connected to specific fields in a table or query.

A form that enables users to view but not change data is a(n) ________ form.

What type of control is created if you create a form based on a table with a lookup field?

Where do you typically put a page break?

When the Allow Edit property of a form is set to No, no new records can be added.

Which of the following are not customizations you can make to a form?

________ controls are not connected to fields in a table or query.

A form that enables users to view but not change data is a restrict-only form.

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Get Connected

Fine-Tuning the Database

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters