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

 

Form Design View


Figure 4-26: Design View of MS Access Form
________________________________________

 

1. In the Design View as shown in Figure 4-26, you can see the table you used as a data source for your form pointed by label 1. If you want, you can move fields on your form simply by dragging and dropping on the form.

2. As shown in Figure 4-26 with label 2 (Figure 4-29), this is the From Header. If you want you can expand this area simply by dragging the top border of ‘Detail’ down.

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.

 


Figure 4-27: Date and Time inserted on the Form.
________________________________________

 

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. Try entering data through your form and then access your data directly from the table and verify whether the data entry happened or not. Using MS Access forms you can also do the data entry or update operation on Oracle tables.

 


Figure 4-29: Close-up of Figure 4-26 Right-Hand-Side.
________________________________________

 

Figure 4-29: Close-up of Figure 4-26 Left-Hand-Side.
________________________________________

 

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: