Question 1

Often information such as report totals (averages,sums,etc.)are displayed in a report ________.

Accepted Answer

footer

Question 2

It is possible to set up restrictions which allow records to be added,but not deleted using a form.

Accepted Answer

A) True 
 B)False  True

Question 3

A section ________ marks the top boundary of a section.

Accepted Answer

A) bar 
B) line 
C) area 
D) row 
A) bar 
B) line 
C) area 
D) row A

Question 4

Forms can be customized so that users can only view the data.

Accepted Answer

A) True 
 B)False

Question 5

A graphic line can be considered a form control.

Accepted Answer

A) True 
 B)False

Question 6

To display information from more than one table,forms often have ________.

Accepted Answer

The answer of To display information from more than one...

Question 7

The controls toolbar will tell you if a control is a bound or unbound control.

Accepted Answer

A) True 
 B)False

Question 8

What is the name of the button/command in the Tab Order dialog box that allows Access to reorder your tabs as it sees 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 9

A form footer displays at the bottom of every page in a form.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is not true about making a table the source data for a Combo Box?

Accepted Answer

A) It is quicker for Access to index the data. 
B) The data is then in an easy-to-edit location. 
C) The user can be forced to choose from only those records in the table. 
D) New records can be added or existing records deleted very easily. 
A) It is quicker for Access to index the data. 
B) The data is then in an easy-to-edit location. 
C) The user can be forced to choose from only those records in the table. 
D) New records can be added or existing records deleted very easily.

Question 11

Text box controls cannot display numeric data,currency,or dates.

Accepted Answer

A) True 
 B)False

Question 12

What key is often used in a form to advance from one field to another?

Accepted Answer

A) Right Arrow key 
B) Shift Tab 
C) Space bar 
D) Tab 
A) Right Arrow key 
B) Shift Tab 
C) Space bar 
D) Tab

Question 13

A tab stop should always be set for AutoNumber fields.

Accepted Answer

A) True 
 B)False

Question 14

To make sure that a user can only pick from an item on the list in a Combo Box,what property must be enabled?

Accepted Answer

A) Limit to List 
B) Restrict to List 
C) Limit to Menu 
D) Restrict to Menu 
A) Limit to List 
B) Restrict to List 
C) Limit to Menu 
D) Restrict to Menu

Question 15

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 16

Which of the following would not be an example of an unbound control?

Accepted Answer

A) Title of the report 
B) Lastname field 
C) Graphic line 
D) Rectangle 
A) Title of the report 
B) Lastname field 
C) Graphic line 
D) Rectangle

Question 17

Match between columns
                        Premises: Tab Stop
Allow Deletions
Allow Additions
Allow Edits
Row Source

Accepted Answer

The Answer of Records can be deleted. and What table is...

Question 18

If you create a form based on a table with a lookup field,the lookup field becomes a(n)________ Box control on the new form.

Accepted Answer

The answer of If you create a form based on...

Question 19

Where does a form header appear?

Accepted Answer

A) At the top of each page 
B) At the left of each page 
C) Once,at the left of the form 
D) Once,at the top of the form 
A) At the top of each page 
B) At the left of each page 
C) Once,at the left of the form 
D) Once,at the top of the form

Question 20

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.

Often information such as report totals (averages,sums,etc.)are displayed in a report ________.

It is possible to set up restrictions which allow records to be added,but not deleted using a form.

A section ________ marks the top boundary of a section.

Forms can be customized so that users can only view the data.

A graphic line can be considered a form control.

To display information from more than one table,forms often have ________.

The controls toolbar will tell you if a control is a bound or 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 sees fit?

A form footer displays at the bottom of every page in a form.

Which of the following is not true about making a table the source data for a Combo Box?

Text box controls cannot display numeric data,currency,or dates.

What key is often used in a form to advance from one field to another?

A tab stop should always be set for AutoNumber fields.

To make sure that a user can only pick from an item on the list in a Combo Box,what property must be enabled?

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

Which of the following would not be an example of an unbound control?

If you create a form based on a table with a lookup field,the lookup field becomes a(n)________ Box control on the new form.

Where does a form header appear?

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

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters

Exam 8: Advanced Forms and Reports

Often information such as report totals (averages,sums,etc.)are displayed in a report ________.

It is possible to set up restrictions which allow records to be added,but not deleted using a form.

A section ________ marks the top boundary of a section.

Forms can be customized so that users can only view the data.

A graphic line can be considered a form control.

To display information from more than one table,forms often have ________.

The controls toolbar will tell you if a control is a bound or 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 sees fit?

A form footer displays at the bottom of every page in a form.

Which of the following is not true about making a table the source data for a Combo Box?

Text box controls cannot display numeric data,currency,or dates.

What key is often used in a form to advance from one field to another?

A tab stop should always be set for AutoNumber fields.

To make sure that a user can only pick from an item on the list in a Combo Box,what property must be enabled?

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

Which of the following would not be an example of an unbound control?

If you create a form based on a table with a lookup field,the lookup field becomes a(n)________ Box control on the new form.

Where does a form header appear?

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

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters