Forms

Hello, I have been working with an existing Access Table and Queries that
were completely set up by someone else.... I have learned to run queries with
out any problems. Now I have been asked to design Forms with a new data base
and new data. My question is? What is the easiest way to build Forms so that
others may enter data into the same data base? The Tables to the new data
base have been formatted, should the information be loaded there or on a Form
page?

Users should never be interacting directly with tables (or queries). They
should always use a form to input data.

Nothing needs to be done so that others can use the forms: Access is enabled
for multi-user use right out of the box. However, your application should be
split into a front-end (containing the queries, forms, reports, macros and
modules), linked to a back-end (containing the tables and relationships).
Only the back-end should be on the server: each user should have his/her own
copy of the front-end, preferably on his/her hard drive.

See what Tony Toews has at
http://www.granite.ab.ca/access/splitapp/index.htm for more information.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"New Form Design" New Form wrote in
message ...
Hello, I have been working with an existing Access Table and Queries that
were completely set up by someone else.... I have learned to run queries
with
out any problems. Now I have been asked to design Forms with a new data
base
and new data. My question is? What is the easiest way to build Forms so
that
others may enter data into the same data base? The Tables to the new data
base have been formatted, should the information be loaded there or on a
Form
page?