Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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:
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."
"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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Learn Microsoft Access 2013 Beginner Course|
Acquiring Access 2013; Course OverviewPreview
IMPORTANT - Read this to ensure the best video quality!
What's New in Access 2013Preview
Access 2013 Exercise Files
Database Templates; Creating, Opening and Saving Databases
Workspace and Backstage View
Online, Offline, and Contextual Help
Finding Keyboard Shortcuts and Key Tips
Customizing the Settings and Use of Access 2013
Quick Access Toolbar
Customizing the Status Bar
Overview of the Main Features of Access Database
Web App Basics
Creating Tables - Part 1Preview
Creating Tables - Part 2
Relationship between Tables - Part 1
Relationships Between Tables - Part 2
Inserting and Formatting Fields; Field Validation; Navigation Buttons
Sorting, Filtering and Finding Data
Entering Data; Changing the Order of Columns, Field Width and Height
Design View; Field Properties
Saving Data; Data Types, Attachments and Field Size
Input Masks; More on Field Properties
Creating Forms; Form Wizard
Single Forms; Insert, Delete, Modify, Sort and Filter Records
Layout View; Adding Existing Fields
Design View; Arranging Fields
Joins and Query Wizard
Operators and Expressions - Part 1Preview
Operators and Expressions - Part 2
Operators and Expressions - Part 3
Report Wizard; Previewing a Report
Grouped and Summary Reports; Modifying a Report
Documenter; Print Properties and Options
Import and Append; Copy and Paste; Export Access Database
Database Templates and Application Parts
Modal Dialogs - Part 1Preview
Modal Dialogs - Part 2
Modal Dialogs - Part 3
Actions; Example of VBA; Creating AutoExec Macro
More Access Options
Access 2013 Quiz
|Section 2: Learn Microsoft Access 2013 Advanced Training Course|
Prerequisites and Basic Knowledge of Access 2013Preview
Access 2013 Advanced Exercise Files
Indexes and Introduction to the Movies Database
Basics in Working with Datasheet ViewPreview
Controlling the Display and Advanced Sorting and Filtering in Datasheet View
Linking to Other Access Database TablesPreview
How to Install SQL Server Express
Setting up a Database, Accessing MDF file, and Linking via ODBC using SQL Server
Reasons to Split a Database; Splitting a Database to a Front-end and a Back-end
Consequences of the Split; Moving a Database; Adding a Trusted Location
Access Options relating to Multi-user Issues; Record Locking
Basics of Macros and Properties of Macro Editor
Examples of Macros; Autoexec
Customizing the Quick Access Toolbar and the Ribbon
Convert Macro to VBA; VBA Editor
Reorganizing VBA Workspace; Developing, Debugging and Running VBA Codes
Modules, Subs, Options Explicit, and Variables
Scope of Variables
Branch and Loop
Responding to Events and Developing Error Handles
More on Events
Getting Help with Events
Basics of Forms: Review and Tips and Tricks
Advanced Features of Forms - Part 1Preview
Advanced Features of Forms - Part 2
Advanced Features of Forms - Part 3
Advanced Features of Forms - Part 4
Basics of Queries: Review
Main Features and Syntax of SQL Statements
Use of Multiple Criteria of a Where Clause
How Joins Look in SQL Statements and using Query Grids
Delete and Make Table Queries
Protecting your Database and Codes
Making your Database More User-Friendly
Setting up an Access Web App
Building Basic Web Apps
Access 2013 Advanced Quiz
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.