creating an employee database (1 Viewer)

[Lisaj]

I am very new to access however i have been trying to create an employee database to record:
1. Name , Address
2. Telephone
3. Date of birth
4. employee ID#
5. Emergency contact -name, address, telephone
6. Photograph
7. Other pertinent information related to employees

So far I have incorporated the contacts database forms into my new database but I am unable to link the forms into one form that will incorporate all the information needed. Is there any way to assist me with this? Or is there an existing employee database that I may edit to suit my purposes?

 

[jdraw]

Best advice I can suggest is to get your tables and relationships designed before getting too deep into Access Forms etc.

This link is for a data model for an Employee database
http://www.databaseanswers.org/data_models/employees/index.htm

And here is a link on how to identify your tables, attributes and relationships. It will highlight Normalization and lead to a database design that meets your requirements.

http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

Good luck

 

[Lisaj]

Thanks for the link will try and follow it to continue working on my project. Much appreciated.