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
$19
$50
62% off
Take This Course
  • Lectures 94
  • Length 6 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2014 English

Course 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!!!

What are the requirements?

  • You should have basic understanding of Computers
  • You should have Microsoft Access 2010 or higher installed on your computer

What am I going to get from this course?

  • 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.

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Important things to know
What is Microsoft Access?
Preview
02:06
What is a Database?
Preview
02:50
What is a Database Management System?
Preview
02:24
What is Data?
Preview
02:52
How is Data Stored?
Preview
03:26
Data and Formats
Preview
04:39
Create a Blank Database
Preview
01:52
Section 2: Microsoft Access Basics
Opening an Existing Database
02:24
Difference Between Excel and Access
Preview
02:42
Overview of MS Access 2013
Preview
04:01
Introduction to Data Types
04:09
Numeric and Text Data
06:02
Primary Keys
05:58
Section 3: Microsoft Access Functions Basic
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
Section 4: Tables in Microsoft Access
Design View of Table
04:26
Update Table Statement
05:15
Delete a Table
02:06
Export Data
06:04
Section 5: Forms in MS Access
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
Section 6: SQL Overview in Excel
Overview of SQL in MS Access
03:17
SQL its Classification
01:58
Basic SQL Syntax
00:54
Section 7: SELECT Statement in MS Access
Select Variables From
06:45
Variables Position in Results
02:42
All Variables from Table
02:27
Create New Variables
05:40
Section 8: WHERE Clause - Microsoft Access
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
Section 9: GROUP By Clause - Microsoft Access
Group By Part 1
03:21
Group By Part 2
07:00
Group BY Part 3
05:49
Section 10: HAVING Clause - Microsoft Access
Having Clause Part 1
04:13
Having Clause Part 2
03:05
Having Clause Part 3
02:47
Section 11: ORDER BY Clause - Microsoft Access
Order by Part 1
02:40
Order by Part 2
02:58
Order by Part 3
02:24
All Statements
04:59
Section 12: Text Functions in Microsoft Access
Concatenate Two Strings
03:13
Case Functions
02:32
Left-Right Functions
06:44
Mid Text Functions
02:14
Functions Text Replace
03:23
Text Length
02:30
TRIM Function
03:20
Left TRIM & Right TRIM
04:52
Maximum and Minimum Text Function
02:31
Section 13: Numeric Functions in Microsoft Access
Maximum and Minimum Functions
04:26
Average Functions
02:16
Count Functions
03:02
Sum
04:12
SGN Function
02:07
INT Function
02:46
Round Function
02:51
FUnctions Numeric Exp
01:34
Section 14: Date Functions in MS Access
Date Function
01:59
Now Function
01:32
Time Function
00:59
Day/Month/Year Function
03:17
Second/Minute/Hour Function
01:58
Weekday/Weekday Name Function
04:01
DateAdd Function
04:26
DateDiff Function
07:13
TimeSerial Function
02:44
Section 15: SELECT INTO Function in Microsoft Access
Select Into
02:31
Section 16: JOINs and UNIONs in Microsoft Access
Introduction to Joins and Unions
03:00

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Gaurav Chauhan, 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.

Ready to start learning?
Take This Course