Step by step exercise. Creating forms


Objective.

 

To learn how to create forms using the wizard.

 

Open the Classes.mdb database.

We are firstly going to create a form with which to edit the data in the Students table, we will use the forms wizard for this.

1 Position yourself in the Forms tab in the Database window.

2 Double click on the Create form by using wizard option.

3 Select the Students table from the Table/query box in the first page of the assistant.

4 Click on the button to add all the fields to the form.

5 Click on the Next button to go to the wizard's next screen.

6 Leave the Columnar option activated as the distribution of the form.

7 Click on the Next button.

8 Leave the style of the form as Standard.

9 Click on the Next button.

10 Type the title as students columnar.

11 Click on the Finish button.

Observe how on creating the form the data stored in the first record from the table appears.

By clicking on the buttons of the Navigation bar we can access the records.

12 Click and you will see the next record, click it several times.

13 Click and you will see that you return to the previous record.

14 Click and you will be positioned in the first record.

15 Click and you will be positioned in the last record.

16 Close the form, saving the changes.

 

We will now create a form for the Courses table so that there will be various courses in the same screen.

1 Position yourself in the Forms tab in the Database window if you are not already there..

2 Double click on the Create form by using wizard option.

3 Select the Courses table from the Table/query box in the first page of the wizard.

4 Click on the button to add all the fields to the form.

5 Click on the Next button to go to the wizards next screen.

6 Select the Tabular option as the form distribution.

7 Click on the Next button.

8 Leave the style of the form as the Industrial option.

9 Click on the Next button.

10 Type the name of the form as Courses Tabular.

11 Click on the Finish button.

12 Close the form.

 

Now we are going to introduce data into the Courses table using the form created:

1 Position yourself in the Forms tab in the Database window if you are not already there..

2 Click on Courses Tabular.

3 Click on the button in the Database window.

If you want you can summarize steps 2 and 3 by double clicking on the Courses Tabular name.

4 Once the form is opened we only need to change the data by changing the field with the ENTER key.

There is no need to save the records as this is done automatically.

The data to change is:

 

Course code Course name Nš Hours Star date Finish date
1 Computers 300 07/15/00 10/20/00
2 Spanish 150 07/25/00 09/10/00
3 French 340 07/10/00 10/25/00
4 Design 250 07/30/00 10/05/00

5 Close the form.



   
   
Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited. April-2006.