Question 1

A locked form displays data but does not allow any changes to the data.

Accepted Answer

A) True 
 B)False  False

Question 2

The expression IIf(IsNull([ClosedDate]),"Open","Closed")displays ________.

Accepted Answer

A)  Closed when the ClosedDate field has no value and Open otherwise 
B)  Open when the ClosedDate field has no value and Closed otherwise 
C)  Closed when the ClosedDate field has no value and nothing otherwise 
D)  Open when the ClosedDate field has no value and nothing otherwise 
A)  Closed when the ClosedDate field has no value and Open otherwise 
B)  Open when the ClosedDate field has no value and Closed otherwise 
C)  Closed when the ClosedDate field has no value and nothing otherwise 
D)  Open when the ClosedDate field has no value and nothing otherwise B

Question 3

You can adjust the tab order to control the advancement from one field or control to the next.

Accepted Answer

A) True 
 B)False  True

Question 4

By using a ________,you can create a form that displays records from two related tables.

Accepted Answer

A)  linked form 
B)  subordinate form 
C)  subform 
D)  mini-form 
A)  linked form 
B)  subordinate form 
C)  subform 
D)  mini-form

Question 5

To prevent any changes to a form,select the No option for Allow Additions,Allow Deletions,and Allow Edits in the ________.

Accepted Answer

A)  Changes dialog box 
B)  Property Sheet 
C)  Protection dialog box 
D)  Attributes Sheet 
A)  Changes dialog box 
B)  Property Sheet 
C)  Protection dialog box 
D)  Attributes Sheet

Question 6

If you want users to view a form but not make any changes to its data,you would use a ________ form.

Accepted Answer

A)  protected 
B)  locked 
C)  secure 
D)  read-only 
A)  protected 
B)  locked 
C)  secure 
D)  read-only

Question 7

Form headers or report footers are examples of form or report ________.

Accepted Answer

A)  subdivisions 
B)  divisions 
C)  segments 
D)  sections 
A)  subdivisions 
B)  divisions 
C)  segments 
D)  sections

Question 8

A combo box is used to display a drop-down menu containing a list of options from which users choose a single option.

Accepted Answer

A) True 
 B)False

Question 9

You would use a ________ box control to display a drop-down menu containing a list of customer satisfaction options from which users would select one.

Accepted Answer

A)  selection 
B)  check 
C)  list 
D)  combo 
A)  selection 
B)  check 
C)  list 
D)  combo

Question 10

Sections can be used in reports but not in forms.

Accepted Answer

A) True 
 B)False

Question 11

Advanced controls can be used in forms but not in reports.

Accepted Answer

A) True 
 B)False

Question 12

A text box can be converted into a combo box.

Accepted Answer

A) True 
 B)False

A locked form displays data but does not allow any changes to the data.

The expression IIf(IsNull([ClosedDate]),"Open","Closed")displays ________.

You can adjust the tab order to control the advancement from one field or control to the next.

By using a ________,you can create a form that displays records from two related tables.

To prevent any changes to a form,select the No option for Allow Additions,Allow Deletions,and Allow Edits in the ________.

If you want users to view a form but not make any changes to its data,you would use a ________ form.

Form headers or report footers are examples of form or report ________.

A combo box is used to display a drop-down menu containing a list of options from which users choose a single option.

You would use a ________ box control to display a drop-down menu containing a list of customer satisfaction options from which users would select one.

Sections can be used in reports but not in forms.

Advanced controls can be used in forms but not in reports.

A text box can be converted into a combo box.

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

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

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

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

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

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and SQL in Access: Advanced Techniques

Filters

Exam 7: Advanced Forms and Reports: Hands-On-Exercise Videos

A locked form displays data but does not allow any changes to the data.

The expression IIf(IsNull([ClosedDate]),"Open","Closed")displays ________.

You can adjust the tab order to control the advancement from one field or control to the next.

By using a ________,you can create a form that displays records from two related tables.

To prevent any changes to a form,select the No option for Allow Additions,Allow Deletions,and Allow Edits in the ________.

If you want users to view a form but not make any changes to its data,you would use a ________ form.

Form headers or report footers are examples of form or report ________.

A combo box is used to display a drop-down menu containing a list of options from which users choose a single option.

You would use a ________ box control to display a drop-down menu containing a list of customer satisfaction options from which users would select one.

Sections can be used in reports but not in forms.

Advanced controls can be used in forms but not in reports.

A text box can be converted into a combo box.

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

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

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

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

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

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Get Connected: Exchanging Data Between Access and Other Applications

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and SQL in Access: Advanced Techniques

Filters