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
Acknowledge(0)
Amend(0)
4we 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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.