Create Submission form with email notification

[Guest]

I'm hoping to create a form that allows our general users to submit the name
and start date of a new employee. Ideally, the user would hit the SUBMIT
button and the data they've entered would be put in a database, AND an email
would be sent to our Administrators notifying them a submission has been
made.
This is in early planning stage: where to start?

 

[Rick B]

What do you want the database to do? You mention one very minor funtion
here - sending an emial that contains two fields on it. I think you need to
fisrt decide what all this database will do. Will it hold details like
address, phone, spouse, children, hobbies? Will it print birtday reports?
Will it track training or certifications? Will it contain salary
information and history?

If it is not going to do these types of things, if it will soley send an
email with two fields, then I would not do it in Access. I would just open
an email, type in the name and date, and send it.

If you plan to do more, give us some details and we can help you with your
table structure. At the very least, you will need an Employee table that
contains a unique identifier like employee number, the firstname, lastname,
middlename fields, start date, and any other data that pertains to that
person. If you track raises, or training classes, or certification, then
you will need several other tables to create one-to-many or many-to-many
relationships.

 

[Guest]

Thanks, Rick - We'll want the database to hold employee information (name,
type of employment, start date/end date, office number, title, etc, and to
keep track of what computer priveleges and building priveleges they'll need).
The purpose is so those who are hiring can submit a form online and the
administrative people can be notified of a staff change and start planning
for their arrival.
FYI - we've got about 110 employees at any given time.

We will also want a database with inventory (hardware, software, and who is
using them/what machine they are installed on...etc) but i don't think anyone
but the it/admin department will use that inventory database, so no
submission forms/notifications will be needed. It would be great if the user
tracking database and the inventory database were linked, though.