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
2we 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
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
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Ms-excel_shortc uts_237.doc
Ms-excel_part1_ 710.ppt