MS Access 2003 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 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17

Form Design View

1. In the Design View you can see the table you used as a data source for your form. If you want move fields on your form, simply drag and drop on the form.

2. As shown in the screenshot, this is the From Header. Right now you don’t have anything as the form header. If you want you can expand this area simply by dragging the top border of ‘Detail’ down. The header will expand and will look as shown below.

Click on the header area and then from menu bar click ‘Insert’ and then ‘Date and Time’. Now the header of our form will look as follows.

Once you go back to run-time view of your form, you will see the date and time showing at the top of the form. The run-time view of the form can be accessed by clicking the icon on the tool bar as shown below.

You can also access the run-time view of the form by clicking View on the menu bar and then clicking the ‘Form View’ command as shown below.

Try entering data through your form and then access your data directly from the table and verify the data entry happened or not. Using MS Access forms you can also do the data entry or update operation on Oracle tables.

Chapter 4: MS Access Reports & Forms

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17

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: