Create an electronic form

We do an annual TNA where Line Managers submit the training required for the forthcoming year, can I create an electronic form from which the information could be directly inserted into a database created in office97.

At the moment the forms are sent electronically although the data contained still has to be manually entered into the database.
--
Hazel Haldane
IT Training Administrator

"Hazel Haldane" wrote in message
...
We do an annual TNA where Line Managers submit the training required for
the forthcoming year, can I create an electronic form from which the
information could be directly inserted into a database created in office97.

At the moment the forms are sent electronically although the data
contained still has to be manually entered into the database.

Yes, there are several ways (in order of complexity):

1. You can build an asp front-end and use the Internet to directly update
the database.
2. You can use Terminal Services to update an Access form.
3. You can have separate databases and replicate the data on a regular
basis.
4. You can email the database and import the data.
5. You can output to a spreadsheet or text file and import the data.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access