Programs: Microsoft Access : Lesson #3


Lesson #3: In this lesson, we will learn:

 ● About the Uses of a Form

● How to use the Form Wizard.

● About Controls and Their Importance

● About the Necessity of the Command Button

 

Lesson 3: Functions of a Microsoft Access Form

Description

Objective 1: Uses of a Form

 

 

 


 

(Form Design View above)

 

Forms can be used to make such things as fax forms, purchase orders, sales confirmations, bills, applications, and other business transactions. Forms are also essential for entering and keeping track of such data as contact information.

Objective 2: How to use the Form Wizard

 

 

 


 

(Form View Above)

 

 

 

 

 

 

The form wizard allows one to be able to view queries and tables to select certain fields to be placed on the form.  This also prevents any errors in trying to provide the correct spelling and character spacing when creating a form manually.

Objective 3: Controls and Their Importance

 

 

 

 

 

 

 

 

All forms consist of controls, which accept and display data, along with decorating the form and adding descriptive info. Microsoft access includes the following types of forms: design view, report design view, and data access page Design view.

Objective 4: Necessity of the Command Button

 

 

 

 

 

 

 

 

 

 

 

 

 

The command button is an essential part of Microsoft Access as it allows one to perform numerous operations within the program.  One will begin to comprehend how reports, forms, queries, macros, and tables can function just by creating a button to be placed on a form.

 

Lesson Review

In this Lesson, you learned what forms are used for in real life, along with the purposes of the form wizard, controls, and command buttons.  You learned about:

 ● The Uses of a Form: used to enter and keep track of data

● The Form Wizard: this allows one to view queries and select fields

● Controls and Their Importance: these accept and display data

● The Necessity of the Command Button: this allows many operations to be performed at once

Back to Lesson #2

Continue to Lesson #4

Back to Lessons Page 


Programs: Microsoft Access : Lesson #3