A form is nothing more than a graphical
representation of a table. You can add, update, delete records in your table by
using a form. NOTE: Although a form can be named different from a table,
they both still manipulate the same information and the same exact data. Hence,
if you change a record in a form, it will be changed in the table also.
A form is very good to use when you have numerous fields in a table. This way
you can see all the fields in one screen, whereas if you were in the table view
(datasheet) you would have to keep scrolling to get the field you desire.
Create a Form using
It is a very good idea to create a form using the
wizard, unless you are an advanced user and know what you are doing. Microsoft
Access does a very good job of creating a form using the wizard. The following
steps are needed to create a basic form:
Switch to the Database Window. You can do this by pressing F11 on the
Click on the Forms button under Objects on the left side
Double click on Create Form Using Wizard
On the next screen select the fields you want to view on your form. Most
of the time you would select all of them.
Select the layout you wish
Select the style you desire...HINT: if you plan on printing your
form, I suggest you use a light background to save on printer toner and ink
Give you form a name, and select Open the Form and enter information
You should see your form. To adjust the design of your form, simply hit
the design button (same as with the tables), and adjust your form
No Microsoft Access Articles could be found as of now.
Share And Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages.
Introduction into Microsoft Access,Creating New, and Opening Existing Databases,Creating a database using a wizard,Creating a database without using a wizard,Tables - What they are and how they work,Create a table from scratch in Design view,Primary Keys,Switching Views,Entering Data,Manipulating Data