The Ultimate Microsoft Access 2010 and 2013 Training Bundle
4.6 (104 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.
972 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Ultimate Microsoft Access 2010 and 2013 Training Bundle to your Wishlist.

Add to Wishlist

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.6 (104 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.
972 students enrolled
Created by Simon Sez IT
Last updated 6/2017
English
Current price: $10 Original price: $200 Discount: 95% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 35 hours on-demand video
  • 8 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • Anyone new to Microsoft Access 2010 or Access 2013, or upgrading from previous versions of Microsoft Access
Students Who Viewed This Course Also Viewed
Curriculum For This Course
165 Lectures
35:05:22
+
Learn Microsoft Access 2013 Beginner Course
54 Lectures 10:18:05

Essential Information for a Successful Training Experience
01:36

Access 2013 Exercise Files
00:25


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


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 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 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 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
+
Learn Microsoft Access 2013 Advanced Training Course
43 Lectures 09:27:10

Essential Information for a Successful Training Experience
01:36

Access 2013 Advanced Exercise Files
00:26

Indexes and Introduction to the Movies Database
14:36


Controlling the Display and Advanced Sorting and Filtering in Datasheet View
15:21


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


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 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
+
Learn Microsoft Access 2010 Beginner Course
31 Lectures 07:10:44

Essential Information for a Successful Training Experience
01:17

Downloadable Course Transcripts
00:20

Start/Exit, Help Features, Shortcuts, Views, Templates
15:32

Course Review
00:43


Introduction to Design of a Database
14:19


Creating Tables & Basic Setup of Relationships
15:25

Using Quick Parts to Setup New Table, Importing Spreadsheet
16:18

Entering Data Types into Tables
15:18

Changing Table Attributes, Copy, Rename, Delete Records
16:21

Table Structures
15:15

Table and Field Properties
15:55

Auto-Create Forms, Filtering & Searching
15:13

Types of Different Forms & Creating New
14:56

Improve Look, Style, & Feel of Forms
15:13

Adding Fields to Existing Form
15:58

Understanding and Setting Up the Expression Builder
14:58


Sorting Single & Multiple Columns; Filter One Field Data Records
15:33

Sorting & Filtering Data in Form View; Find & Replace in Forms
15:10

Understanding Reports & Structure
15:24

Creating Reports; Using Print Preview to Check Report Outcome
15:35

Advanced Reporting; Formatting Reports
15:23

How to Improve Report Design, Add Existing Fields; Group/Sort
14:25

Select Queries; Sorting; Defined Criteria
15:00

Change Fields wthin Query; Specifying Criteria for Numbers/Text
15:31

Update Queries; Append Queries; Delete Queries
15:56

Inner/Outer Joins; Make Table Queries; Mail Merge
16:27

Securing Database and Views; New Features
14:01

Access 2010 Quiz
35 questions
+
Learn Microsoft Access 2010 Advanced Course
37 Lectures 08:09:49

Essential Information for a Successful Training Experience
01:17

Downloadable Course Transcripts
00:21




More Database Options
15:35

Renaming Database Objects
11:13

Basics & Understanding Data Types
13:34

Table and Field Properties
14:22

Validation Rules & Text
13:31

Understanding & Using Keys and Indexes
15:47

Data Normalization
15:38

Types of Relationships
12:39

Maintaining Relationships
07:29

Using & Understanding Queries
11:47

Complex Queries
16:04


Datasheet View
15:30

Creating & Working with Forms
13:56

Using Forms to Maintain Data
16:04

Command Buttons
14:10

Command Buttons Part 2
14:45

Form Features that Need VBA Code
09:39

Understanding When & How to Use VBA
16:01

More about VBA and Using It to Improve Database
14:46

VBA Language Structure & Making a Switchboard
15:19


Cleaning Up Before Distribution
16:48

Security Techniques
15:59

External Data & Importng/Exporting Data
16:39

Linking to Excel & Linking to Another Database
09:25

Separating/Splitting Up Forms, Reports, etc from Database
09:37

Options for Making Changes When Database is Multi-User
14:56

Advanced Features for Reports
12:35

Advanced Features for Reports Part 2
12:50

Distributing Application
15:00

Access 2010 Advanced Quiz
40 questions
About the Instructor
Simon Sez IT
4.4 Average rating
10,198 Reviews
292,957 Students
113 Courses
300,000+ Students | Wordwide Use 180 Countries |120+ 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,500+ 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 300,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.