Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
The Ultimate Microsoft Access 2010 and 2013 Training Bundle
Rating: 4.1 out of 5(224 ratings)
1,539 students
Created bySimon Sez IT
Last updated 5/2026
English

What you'll learn

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

Course content

4 sections166 lectures35h 6m total length
  • Acquiring Access 2013; Course Overview14:32
  • WATCH ME: Essential Information for a Successful Training Experience2:03
  • DOWNLOAD ME: Access 2013 Exercise Files0:22
  • DOWNLOAD ME: Course Transcript0:21
  • What's New in Access 20139:26
  • Using Touch5:53
  • Database Templates; Creating, Opening and Saving Databases11:26
  • Workspace and Backstage View10:31
  • Online, Offline, and Contextual Help5:49
  • Finding Keyboard Shortcuts and Key Tips5:57
  • Customizing the Settings and Use of Access 201311:23
  • The Ribbon11:22
  • Quick Access Toolbar4:49
  • Customizing the Status Bar3:42
  • Overview of the Main Features of Access Database16:43
  • Web App Basics10:42
  • Creating Tables - Part 115:29
  • Creating Tables - Part 214:46
  • Relationship between Tables - Part 114:32
  • Relationships Between Tables - Part 28:38
  • Inserting and Formatting Fields; Field Validation; Navigation Buttons12:19
  • Sorting, Filtering and Finding Data13:21
  • Entering Data; Changing the Order of Columns, Field Width and Height8:00
  • Design View; Field Properties13:36
  • Saving Data; Data Types, Attachments and Field Size14:06
  • Input Masks; More on Field Properties15:06
  • Creating Forms; Form Wizard14:36
  • Single Forms; Insert, Delete, Modify, Sort and Filter Records12:35
  • Layout View; Adding Existing Fields15:55
  • Design View; Arranging Fields16:27
  • Controls14:06
  • Form Design13:25
  • Query Design15:30
  • Joins and Query Wizard15:03
  • Query Types13:51
  • Operators and Expressions - Part 112:00
  • Operators and Expressions - Part 27:32
  • Operators and Expressions - Part 315:04
  • Subforms12:32
  • Report Wizard; Previewing a Report9:41
  • Report Design13:57
  • Grouped and Summary Reports; Modifying a Report15:27
  • Adding Subreports11:40
  • Documenter; Print Properties and Options9:20
  • Import and Append; Copy and Paste; Export Access Database13:45
  • Database Templates and Application Parts14:21
  • Navigation Form10:45
  • Modal Dialogs - Part 111:52
  • Modal Dialogs - Part 213:33
  • Modal Dialogs - Part 39:39
  • Actions; Example of VBA; Creating AutoExec Macro15:25
  • More Access Options8:45
  • Info Tab11:49
  • Trust Center12:58
  • Updates; Closing2:22
  • Access 2013 Quiz

Requirements

  • Microsoft Access 2010 and Microsoft Access 2013

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
  • Printable course transcriptions to follow along and take notes

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

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

** Updated June 2017. Course transcripts now available.

Who this course is for:

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