MS Access 2007 Step By Step - Asim Abbasi

CH1: Overview | CH2:  MS Access Local & Linked Tables | CH3:  MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions

Chapter 4: MS Access Reports & Forms

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9

 

Forms are used as the source of data entry into the MS Access tables. Forms are basically GUI (Graphical Users Interface) using which users interact with MS Access database.

You can also do the data entry to MS Access table directly by double clicking the table and adding the records at the end of the table. Underneath a MS Access form, you may have multiple tables attached. Using forms, you don’t have to switch between tables during massive data entry. Moreover, the end users need not to know about SQL and inter-tables’ relationship to perform the data entry operation.

 

Step 1: Creating Form Using Form Wizard


Figure 4-19: Form Wizard lies under “More Forms” drop-down menu of “Create” command ribbon.
________________________________________

 

1. Click on “Create” command as shown in Figure 4-19 with label 1.

2. On the ribbon expand the “More Forms” drop-down menu.

3. Finally click the “Form Wizard” command.

We will be using Form Wizard to create new form. Once you have your hands round the MS Access Forms functionality, try using other ways to do the forms development.

 

Chapter 4: MS Access Reports & Forms

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9

CH1: Overview | CH2:  MS Access Local & Linked Tables | CH3:  MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions

Share with others: