Data Base creation

[Susann]

Hello All!

Not sure where else to put this.

I want to create a method for clients to come to my website and enter in simple employee data as people are hired and terminated.

I will need to know a few key things when a new employee is hired: Hire date, SSN, Date of Birth, Salary, etc.
Likewise when someone gets canned, I need to know who and when. This data will serve as a basis for billing purposes, so it has to be in Access or Excel.
Can I build an existing data base of current names and allow the additions to be made via the website? This will be key for establishing new clients.

This would also have to be password protected.

What would be the best method of setting this up so that the data dumps into say an Access database?
Also, what type of server requirements am I looking at here? SQL, PHP, both?

I invision some sort of form for the data entry process. I guess.

There will be multiple companies that will be performing this function, so I need multiple databases. I guess.


So many questions~
Any ideas, pointers or takers?
:?: :?:

[bud]

Well from reading your post... I think you will be better off using
Access or SQL for a backend.

First thing you should do is get yourself a pack of index cards...
Start by giving a couple cards titles... Look at them as Objects...

1) Company
2) Employee
3) AccessType
etc...

Then list some properties for each below the title...

1) Company
   a) ID
   b) Name
   c) Address
   d) etc...

2) Employee
   a) ID
   b) FirstName
   c) LastName
   d) etc...

3) AccessType
   a) ID
   b) Access

4) etc...

Now with that done, you need to make it so they can work
togeather...

One way to look at it... Pick up a card, say the Employee card.

Say, the employee Has A or Is A????

So we could say the the Employee Is A member of a
Company... so add a caracteristic to that to the card...

2) Employee
   a) ID
   b) FirstName
   c) LastName
   d) Address
   e) City
   f) State
   g) Zip
   h) Phone
   i) CompanyID

Then we can say that the Employee Has A AccessType

2) Employee
   a) ID
   b) FirstName
   c) LastName
   d) Address
   e) City
   f) State
   g) Zip
   h) Phone
   i) CompanyID
   j) AccessTypeID

Then we can say that the Employee Has A UserName
Then we can say that the Employee Has A Password
Then follow through with the other cards...

Once you have that done you can go into Access and design your
Tables...

Once the Tables are defined you can setup relationships and begin entering data...

For AccessTypes I would place

Administrator Able to maintain all companies and employee's
Manager Able to maintain one company and its emplyee's
Member Able to access there own record only...

Do the rest for the other tables, even if it's just test data...
Now it's time to proceed to the creation of the Queries...

Once you have this done you can go into FP and create your
page based on the Tables or Queries that you created...

Once you get to this point. Andrew has a great little tutorial on
setting up Secure logins with Access databases...

Keep us posted on your progress, and if you need assistance.

[Susann]

Thanks Bud!
looks like I have some work to do!!!!