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)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Ms-excel_shortc uts_237.doc
Ms-excel_part1_ 710.ppt