Mkirkendall
Computer Programmer

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
Hi,
we maintain employee records , mediclaim records,Skill inventory records,Birthday list seperately in excel sheet. Instead of maintaing seperately in xcel sheet...will MS.Access help in maintaing ?
Regards,
Kavitha

From India, Madras
Hello,

Microsoft Access can be very useful, but unfortunately there is a learning curve. Access is a relational database allowing you to have multiple related tables. This is great for reducing redundancy, but can be difficult if you have never done it before.

The basic concept is elimination of duplicate data. As an example, in a basic employee database you could have an EMPLOYEE table. Each employee would have a single record or row in this table with a unique identifier. EMPLOYEE POSITION HISTORY could be a separate table. For Each single employee record in the EMPLOYEE table, you could have multiple related rows in the EMPLOYEE POSITION HISTORY table based on each past position the employee has held.

Access can be a very powerful tool, but look into it before jumping in. I have seen many poorly designed access databases in my time.

http://support.microsoft.com/kb/209534 gives some great information for DATABASE NORMALIZATION (Organization of Data) in Microsoft Access.

Good Luck!

Mark




From United States, Sonora
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™