|
|
| The next task in our database design is to create a Form to simplify the adding of rows (records) into the table. A form is used to arrange and present the fields so it is easy for users to add all the names and addresses etc. of everyone into the database. I will use the form wizard in Access to create the form. |
From the main database window, (if it is not visible press the F11 key) follow the path below: Forms \ Create form by using wizard (double click) If you followed the path correctly you get the following box: |
|
The field names are listed on the left pane and the right pane is empty. We need to move the ones we want on the form, over from the left pane to the right pane. Notice the small buttons between the two panes. They have >, >>, and <, and << on them. The > button moves the field that is highlighted in the left pane over to the right pane.
The >> button will move all fields from the left pane to the right pane. Try it. Nothing permanent will happen until you click the Next > button.
|
Since we want all fields moved except the ID field, we can just click the >> button and then highlight the ID field on the right pane and then click the < button to put it back on the left pane. If you did everything correctly, you should see the following:
|