Learn MS Access

Course details

This course is meant for professionals who are not from Programming  world and want to store and analyze lot of data. MS Access is a great product from Microsoft which helps in Quick and Easy storage of lot of data, conveniently and without using any complex command.

This course explores all the major features of MS Access which actually not only acts as a small Database but also helps in creating Reports out of that data. There is another big advantage of MS Access and that is it can also be used as a simple Data Entry interface also. So, as a result we get all three functionalities to enter Data, store Data and finally analyse/present it as well. Lot of Business Analysts across the world use MS Access a lot for the great set of features it has and is also very popular in the Data Analysis community as well because of the increased productivity it offers. 

Internally MS Access , uses SQL like most of the Relational Databases. But if you are from a non-programming background, still you can use the direct options present in MS Access and quick start analyzing lot of data inside MS Access. This has proved to be biggest selling point of MS Access as it can be leveraged by people from both programming and non-programming background. The data entry tool in Access is again a great feature because it provides a really simple and convenient interface to enter data inside the MS Access database. 

This course is divided into 3 sections majorly viz. the data entry layer (Forms), data storage layer (Tables) and the data presentation interface (Reports). The course does not really have any prerequisite as it is meant to be course for people who want to use MS Access for its simple features. After understanding the basic features the student will be comfortable using Access along with Microsoft Excel as well because the 2 tools can be integrated together very comfortably without any kind of programming. 

This course will also be helpful to the people who own small business/enterprise and want a simple application that can take care of their Data Management tasks/activities. Through Access you can comfortably create simple Database for 
1. Product Inventory Management 
2. Student Information Management
3. Asset Management
4. Sales related Information
5. Issue Tracking

and many more such applications can be created using MS Access in just a few clicks through the sample templates available with MS Access.