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.
2 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.
2 students enrolled
Last updated 1/2017
English
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
Requirements
  • 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
Description

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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
30 Lectures
03:25:40
+
Exploring the MS-Access environment
12 Lectures 01:06:00



Quick access toolbar
03:35

Backstage view
07:42

Exploring the ribbons
09:12

Navigation pane
04:47

Components of a database
05:04

Planning and designing your database
04:56

Create a table in Layout View
04:56

Understanding the structure of a table
06:59

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

Field Properties
07:44

Importing data into Access
09:21

Formatting tools
10:52

Linking the tables (Part 1)
05:46

Linking the tables (Part 2)
06:38

Using Query wizard for Simple Queries
10:29

Using design Query
07:16

Sorting data using Queries
05:43

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

Create compound forms
09:46

Modifying forms in Layout and design view
10:36

Report on single table
06:30

Report on multiple table and formatting
07:56

Create reports through queries
03:39

Exporting data from Access
03:41

Creating a mail merge
10:19
About the Instructor
Learning Academy The Global Training Hub
3.9 Average rating
31 Reviews
204 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 ...