Microsoft Access as an Audit Tool!

Microsoft Access is part of the Microsoft Office Suite. It is usually available in every computer setup powered by MS Windows operating systems like XP or Vista.

MS Access is a full featured database software that is both powerful and easy to learn and use. It can be utilized by accountants and auditors to assist them in their work.

My initial curiosity about the workings of MS Access started in 1997 while working for Sharp (Phils.) Corporation. I purchased a book about Access in order to learn the functionality of this program. I soon discovered the power of its query and report capability. I used it to convert Dbase files into MS Access tables and begin to improve my skills creating queries and reports. Instead of printing the Dbase files and manually calculating discounts to give to dealers based on their purchases from Sharp, I can now produce the information through MS Access queries in 30 minutes or less what usually took hours and days. In addition, reports can be prepared out of query results in a flash. More on how to utilize Access in my next blog post.