Get Ahead in Your Career-Learn Microsoft Access 2013
4.5 (2 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.
1,011 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Get Ahead in Your Career-Learn Microsoft Access 2013 to your Wishlist.

Add to Wishlist

Get Ahead in Your Career-Learn Microsoft Access 2013

Basic to Advanced Guide for Microsoft Access 2013, learn on your pace and get a step closer to your career position.
4.5 (2 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.
1,011 students enrolled
Created by Gaurav Chauhan
Last updated 12/2014
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Become Well Versed in Using Microsoft Access 2013
  • Good Understanding of database management system concepts
  • Added Advantage in professional career towards the field of data analytics.
  • Lifetime access to lectures, E-Books and Practices files.
View Curriculum
Requirements
  • You should have basic understanding of Computers
  • You should have Microsoft Access 2010 or higher installed on your computer
Description

At any given time, there 60,000 Jobs in america alone asking for MICROSOFT ACCESS as an additional skill in your resume (Jobs only above $5000 Per Month).

All you need to do is spend 5+ hours of our course and you gain that knowledge which makes you eligible for those jobs. So Choice is Yours!!!


So what we want for you??

Our Main Objective is for you to become awesome in Microsoft Access 2013.

Beginning with the fundamentals, our instructor will start with basic fundamentals of database and its functionality.

Then he will move towards basics explaining what is Microsoft Access and why do we need it?

Then he will move on basics of Microsoft Access database, and how to use Microsoft Access with its various functionality.

Then we will move towards basics and advanced version of tables. Post which there will major focus on practical commands which are required for you to become successful in Microsoft Access 2013.

You will learn in form to How-to tutorials:

  1. Straight to point topics - 5+ hours of Lectures
  2. 94 individual video lectures
  3. Certificate of completion

Instructor would be available in discussion forum to answer your queries on the course material. So Enjoy!!!

Who is the target audience?
  • Anyone who is interested in field of data analytics
  • Anyone who wants to learn Microsoft Access 2013 to enhance their career
Students Who Viewed This Course Also Viewed
Curriculum For This Course
94 Lectures
05:50:09
+
Microsoft Access Basics
6 Lectures 25:16
Opening an Existing Database
02:24



Introduction to Data Types
04:09

Numeric and Text Data
06:02

Primary Keys
05:58
+
Microsoft Access Functions Basic
7 Lectures 23:30
Creating New Variables
03:31

Adding date and Caption and Default
04:32

Using Functions in Expressions Builder
03:50

Converting Between Data Types Part 1
03:21

Converting Between Data types Part 2
01:51

Fields Validation
03:41

Sort Ascending and Descending
02:44
+
Tables in Microsoft Access
4 Lectures 17:51
Design View of Table
04:26

Update Table Statement
05:15

Delete a Table
02:06

Export Data
06:04
+
Forms in MS Access
5 Lectures 25:53
Forms Part 1
02:52

Forms Part 2
08:05

Importing Excel Data Into Access Part 1
05:52

Importing Excel Data into access Part 2
04:10

Insert Into Statement
04:54
+
SQL Overview in Excel
3 Lectures 06:09
Overview of SQL in MS Access
03:17

SQL its Classification
01:58

Basic SQL Syntax
00:54
+
SELECT Statement in MS Access
4 Lectures 17:34
Select Variables From
06:45

Variables Position in Results
02:42

All Variables from Table
02:27

Create New Variables
05:40
+
WHERE Clause - Microsoft Access
10 Lectures 38:10
Where Clause Part 1
05:15

Where Clause Part 2
04:10

Where Clause Part 3
05:04

Operators
01:42

Arithmetic Operators
01:59

Comparison Operators
05:01

Operators in Operators
03:42

Like Operator
04:34

Between Operator
03:04

Not Operator
03:39
+
GROUP By Clause - Microsoft Access
3 Lectures 16:10
Group By Part 1
03:21

Group By Part 2
07:00

Group BY Part 3
05:49
+
HAVING Clause - Microsoft Access
3 Lectures 10:05
Having Clause Part 1
04:13

Having Clause Part 2
03:05

Having Clause Part 3
02:47
7 More Sections
About the Instructor
Gaurav Chauhan
4.5 Average rating
2 Reviews
1,368 Students
3 Courses
Instructor

I am Lead IT professional for one of largest IT companies in the world. I have been trained and certified in various IT stream and analytics. I am ex- American Express, ex-Airtel. I have been working in IT domain for last 15 years and I have been a system administrator, Six Sigma expert & experienced project manager who has handled global projects on massive scale. 

I have software patents in my name and have been involved with IT industry for a long time.


Going forward, my courses would be based on cloud and analytics domain with new skills. I will start from basics and by the end of each courses you can become a proficient expert in that particular. Please add me on Linkedin or Follow me on Twitter.