The Ultimate Microsoft Access 2010 and 2013 Training Bundle

The Most Convenient Way to Boost Your Confidence And Learn MS Access Inside And Out—Quickly, No Travel or Classes.
4.4 (25 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.
517 students enrolled
$19
$200
90% off
Take This Course
  • Lectures 160
  • Length 35 hours
  • Skill Level All Levels
  • 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/2013 English

Course Description

In today’s workplace, data management skills are absolutely crucial, and Microsoft Access is the most widely available software for the job. Whether you need to use Access 2010 or 2013, our Ultimate Microsoft Access Training Bundle has got you covered. Starting with the absolute basics, these courses will take you to the level of total data mastery in both editions of the program, as you work through both beginners and advanced courses.

If you need to manage data at all in your job, or are looking for a promotion to a role where you do, then you can’t afford to give this a miss.

This bundle includes:

  • 35 hours of video tutorials
  • Over 150 individual video lectures
  • 4 quizzes with 170 test questions
  • Certificate of completion

Courses included with this bundle:

Learn Microsoft Access 2013

Starting with the basics, our certified instructor will teach you to add and delete records to your database. Then, learn to create desktop databases and apps for multiple users before diving into importing data from other sources. Build forms to capture information online. Implement pre-designed templates that track project, employee, issue, or task details. Protect databases with permissions. Run reports that provide valuable business intelligence. And walk away with a solid grasp of how tie it all together with this Microsoft Access Training. Includes exercise files.

Learn Microsoft Access 2013 - Advanced

Your professional trainer will show you how to use macros, tables, forms, queries, and other tools to create a professional, working database. Follow along as you learn to create and maintain macros, then see how to effectively link to other data sources. Get helpful techniques that allow you to link, report, and package your data quickly, and find out how to split a database by splitting the frontend and backend.

With this informative course, you’ll learn the skills you need to make an impact with sleek, high-performing databases that help you do your job better. Includes exercise files.

Learn Microsoft Access 2010

Discover the fundamentals of database design and construction, which will allow you to construct a strong relational database that makes future modifications and data analysis easier.

Each chapter builds on the previous one, walking you through topics on tables and their attributes, structures, and field properties. Forms are presented to make information gathering and input a breeze. Learn data analysis using functions, formulas, expression builder, conditional formatting, sorting, filtering, and queries. Discover practical techniques for improving designs, adding existing fields, and grouping/sorting—as your instructor gives you easy to understand methods for working with reports.

Learn Microsoft Access 2010 - Advanced

Beyond just getting data into the database, you will be taught to create both form and function. Discover how to create switchboards, autoexec functions, macros, creative reports, custom buttons, deep custom queries for detailed data analysis, and reports that shine—in terms of how they look on paper and the data they provide. Additionally, you will learn best practices to employ during initial design and creation steps. These will help you minimize headaches as the database design evolves, and enable mass distribution as the amount of data and number of users increases.

Where else can you find so many extra tools to help you master Access?

What people are saying:

"Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials."

- TopTenReviews.com

"Thank you very much for an extraordinaire online tutorial of Access, it has helped me a lot and even enabled me to get a job. Now I work for an asset management bureau in Paris programming and updating databases from Bloomberg on a daily basis!"

- Lisa R., France.

Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.

What are the requirements?

  • Microsoft Access 2010 and Microsoft Access 2013

What am I going to get from this course?

  • Essential training for Microsoft Access 2010
  • Essential training for Microsoft Access 2013
  • Advanced training for Microsoft Access 2010
  • Advanced training for Microsoft Access 2013

What is the target audience?

  • Anyone new to Microsoft Access 2010 or Access 2013, or upgrading from previous versions of Microsoft Access

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: Learn Microsoft Access 2013 Beginner Course
Acquiring Access 2013; Course Overview
Preview
14:32
IMPORTANT - Read this to ensure the best video quality!
Article
What's New in Access 2013
Preview
09:26
Access 2013 Exercise Files
Article
Using Touch
05:53
Database Templates; Creating, Opening and Saving Databases
11:26
Workspace and Backstage View
10:31
Online, Offline, and Contextual Help
05:49
Finding Keyboard Shortcuts and Key Tips
05:57
Customizing the Settings and Use of Access 2013
11:23
The Ribbon
Preview
11:22
Quick Access Toolbar
04:49
Customizing the Status Bar
03:42
Overview of the Main Features of Access Database
16:43
Web App Basics
10:42
Creating Tables - Part 1
Preview
15:29
Creating Tables - Part 2
14:46
Relationship between Tables - Part 1
14:32
Relationships Between Tables - Part 2
08:38
Inserting and Formatting Fields; Field Validation; Navigation Buttons
12:19
Sorting, Filtering and Finding Data
13:21
Entering Data; Changing the Order of Columns, Field Width and Height
08:00
Design View; Field Properties
13:36
Saving Data; Data Types, Attachments and Field Size
14:06
Input Masks; More on Field Properties
15:06
Creating Forms; Form Wizard
14:36
Single Forms; Insert, Delete, Modify, Sort and Filter Records
12:35
Layout View; Adding Existing Fields
15:55
Design View; Arranging Fields
16:27
Controls
14:06
Form Design
13:25
Query Design
15:30
Joins and Query Wizard
15:03
Query Types
13:51
Operators and Expressions - Part 1
Preview
12:00
Operators and Expressions - Part 2
07:32
Operators and Expressions - Part 3
15:04
Subforms
12:32
Report Wizard; Previewing a Report
09:41
Report Design
13:57
Grouped and Summary Reports; Modifying a Report
15:27
Adding Subreports
11:40
Documenter; Print Properties and Options
09:20
Import and Append; Copy and Paste; Export Access Database
13:45
Database Templates and Application Parts
14:21
Navigation Form
10:45
Modal Dialogs - Part 1
Preview
11:52
Modal Dialogs - Part 2
13:33
Modal Dialogs - Part 3
09:39
Actions; Example of VBA; Creating AutoExec Macro
15:25
More Access Options
08:45
Info Tab
11:49
Trust Center
12:58
Updates; Closing
02:22
Access 2013 Quiz
50 questions
Section 2: Learn Microsoft Access 2013 Advanced Training Course
Prerequisites and Basic Knowledge of Access 2013
Preview
09:10
Access 2013 Advanced Exercise Files
Article
Indexes and Introduction to the Movies Database
14:36
Basics in Working with Datasheet View
Preview
10:29
Controlling the Display and Advanced Sorting and Filtering in Datasheet View
15:21
Linking to Other Access Database Tables
Preview
14:41
How to Install SQL Server Express
14:49
Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server
16:50
Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end
15:19
Consequences of the Split; Moving a Database; Adding a Trusted Location
16:07
Access Options relating to Multi-user Issues; Record Locking
14:58
Basics of Macros and Properties of Macro Editor
14:24
Examples of Macros; Autoexec
14:29
More Autoexec
14:43
Macro Security
08:37
Customizing the Quick Access Toolbar and the Ribbon
15:17
Convert Macro to VBA; VBA Editor
14:13
Reorganizing VBA Workspace; Developing, Debugging and Running VBA Codes
14:27
Modules, Subs, Options Explicit, and Variables
15:58
Scope of Variables
16:13
Branch and Loop
14:38
Customizing Events
Preview
15:08
Responding to Events and Developing Error Handles
14:00
More on Events
14:12
Getting Help with Events
08:24
Basics of Forms: Review and Tips and Tricks
15:39
Advanced Features of Forms - Part 1
Preview
17:19
Advanced Features of Forms - Part 2
14:33
Advanced Features of Forms - Part 3
14:49
Advanced Features of Forms - Part 4
15:19
Basics of Queries: Review
13:57
Main Features and Syntax of SQL Statements
15:53
Use of Multiple Criteria of a Where Clause
12:55
How Joins Look in SQL Statements and using Query Grids
15:50
Update Query
15:42
Delete and Make Table Queries
12:20
Append Query
07:13
Protecting your Database and Codes
15:08
Making your Database More User-Friendly
07:23
Setting up an Access Web App
16:33
Building Basic Web Apps
16:48
Closing
00:44
Access 2013 Advanced Quiz
45 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Simon Sez IT, Over 270,000 Students, Used in 180 Countries, 115 Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,000+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 250,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.

Ready to start learning?
Take This Course