In message <40***********************@news.frii.net>, Ray Ortiz
<ra******@opyonline.net> writes
Yhank for the help Betnard,
First this is my first database, what I was trying to do was take a form
I spent hours crating in microsoft word and use it as the basic
printable form or report in access. So that I can keep a database of all
the forms that I filled out and allthe names of the people I filled them
out for later use in mailing and corresponence. If you can give me a
few suggestions I would greatly appriecate it.
It would help if you could give a bit more information about the type of
information you are collecting. That is what will drive the design of
the database behind the forms.
I'm not sure how much you know about database design, or whether you
just want information on how to make Access do what you want.
Assuming that you are more or less a beginner then what I suggest you do
is first make a list of all of the fields that are included in the form.
Sort them into groups. If you have information about a person put all of
that information together. If the form includes repeating groups of
information list that group separately.
For instance if the form was a purchase order you would have one group
of fields about the person or organisation doing the purchasing. You
would have a separate group of fields about the line-items (item name,
price, quantity) and which would be repeated for each item on the order.
Information about the person or organisation would go into one table in
the database. Information about line-items would go into a separate
table and appear on a subform in the report.
If you want to look up more detailed instructions on how to divide the
groups of data then look up the term normalisation (or normalization if
you want the American spelling.)
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.