Learn MS Access
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn MS Access to your Wishlist.

Add to Wishlist

Learn MS Access

Learning MS Access for data storage, data entry and report generation
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3 students enrolled
Last updated 1/2017
Current price: $12 Original price: $30 Discount: 60% off
3 days left at this price!
30-Day Money-Back Guarantee
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • At the end of this course ,you will understand the nuances of using MS-Access for Data Analysis and Reporting
View Curriculum
  • There are no specific pre-requisites for this course. Student needs to just have an awareness that huge amount of data in a tabular format can be subjected to various kinds of analysis

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.

Who is the target audience?
  • Students aiming to learn simple Data Analysis tasks
  • Business Analysts who want to prepare quick reports for their Business data
  • Programmers who want a small scale application that can serve as a data repository
  • Anyone who wants to enhance his expertise in MIS Reporting and Data Analysis
Compare to Other Microsoft Access Courses
Curriculum For This Course
30 Lectures
Exploring the MS-Access environment
12 Lectures 01:06:00

Quick access toolbar

Backstage view

Exploring the ribbons

Navigation pane

Components of a database

Planning and designing your database

Create a table in Layout View

Understanding the structure of a table

Create a table using design view
Exploring the Advance features in MS-Access
10 Lectures 01:20:32
Create a table using calculated field

Field Properties

Importing data into Access

Formatting tools

Linking the tables (Part 1)

Linking the tables (Part 2)

Using Query wizard for Simple Queries

Using design Query

Sorting data using Queries

Building calculated fields
Understanding the Report creation Interface in MS-Access
8 Lectures 59:08
Create data entry forms

Create compound forms

Modifying forms in Layout and design view

Report on single table

Report on multiple table and formatting

Create reports through queries

Exporting data from Access

Creating a mail merge
About the Instructor
Learning Academy The Global Training Hub
3.6 Average rating
35 Reviews
230 Students
4 Courses
Learning Partner for all your educational requirements

The Global Training Hub (TGTH) is a world class Learning Academy and has a inter-connect network of several professionals who aim to excel in their respective fields and share this knowledge with other people who aspire to excel as well. We have full time dedicated network of working professionals who wish to share their expertise with rest of world.

Our course modules have been designed keeping in mind the requirement of today's Business and there by created by the same set of people who wish are engaged in answering all the questions related to today's problems.

We aspire to reachout to a large population of students by offering the learning and experience of our course creators to as many people as possible. Overall, our learning experience is more than 20 years old in terms of delivering quality education and we are gaining more and more experience in this context with every passing day.

Join in our courses and get benefitted in your career development.

Wish you a Happy Learning ...