A form is the most central aspect of the Access database. With it, a user may view, enter, manipulate, and search data. The forms wizard provides a fast and easy way to create a form in MS Access. If you have an existing table in Access, or the one created from the October 17, 2006 tip, you can follow these steps to create a form.
- Open MS Access and you will see your existing tables (databases).
- Click the Forms button.
- On the toolbar click New.
- Highlight and click on Create form by using wizard.
- On the box on the bottom of the window, choose the table (database) that you wish to use for your form.
- Click OK.
- Click the Select All Fields button
- Click Next.
- Accept or choose the Columnar Layout, click Next.
- Select a style for your form. Click next.
- Accept the name of the form, or change it to whatever you wish it to be and click Finish. A form will be created for your database.
- You can close the form by clicking on the X in the top right-hand corner.
Now that you have your form created, when you open MS Access, you can open the form instead of the table (database). The form is much more user friendly, as well as attractive, when viewing your database. You are ready now to enter data, search, view or change information, as needed.
*Caution: Access should not be used for data stored on public servers (I.e., Mustang). It has a number of security "holes" and should only be used for internal databases on your local computer.
Last updated: 2/07/07