Tech-Know Gypsy
Copyright 1999 Mary Saxton Griffin
Start with an opened Excel Spreadsheet. The above example is of a grade book.
Click on the word Data in the menu bar.
Then select MS Access Form
(If you do not see these options. Reinstall MS Office. Click here for the instructions)
This will give you the following dialog box:
Click on OK - because you want to make a New Database
Select which fields that you want in your form.
For instance, in this case, all the grades and the average will be
put into the form.
After all desired fields have been selected, click on the Next button
Choose the form layout, in this case, Columnar was selected.
Select the color background you want.
Note: some color combinations don't print well and are hard to read!
Type in a title for your form, then select Finish.
This is what your finished form looks like.
Depending on the number of fields in your form, 3 or 4 may fit on one
page when sent to the printer.