Microsoft Access 2010 Advanced Training Tutorial Course

Learn Access 2010 Advanced

Microsoft Access 2010 Advanced training with the best professionals.

During this advanced 8-hour Access 2010 course, you'll get hands-on practice while our professional trainer explains how to use macros, tables, forms, queries and other tools to create a professional, working database. Follow along as you learn how to maintain and create macros and relationships, create and use reports, link pages/sheets from other applications and VBA.

For optimal viewing of these high-definition videos, please set your desktop resolution to at least 1024 X 768.

Title: Access 2010 - Adv.
Duration: 8 hours
Lessons: 35

Chapter 1 - Introduction
Introduction to Advanced Access 2010 10:50
Chapter 2 - Macros
Working with Macros 15:57 AutoExec Macro 15:24
Chapter 3 - Database Options before Distribution
Database Options 11:40 More Database Options 15:35
Chapter 4 - Naming
Renaming Database Objects 11:13
Chapter 5 - Tables
Review of Table Basics & Understanding Data Types 13:34 Table Field Properties 14:22 Validation Rules & Text 13:31
Chapter 6 - Keys and Indexes
Understanding & Using Keys and Indexes 15:47
Chapter 7 - Normalization
Data Normalization 15:38
Chapter 8 - Relationships
Types of Relationships 12:39 Maintaining Relationships 7:29
Chapter 9 - Queries
Using & Understanding Queries 11:47 Complex Queries 16:04 Creating Queries and Using Join & Sub-Queries 16:03
Chapter 10 - Datasheet View
Datasheet View 15:30
Chapter 11 - Forms
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 9:39
Chapter 12 - Visual Basic for Applications
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 Error Handling 16:24
Chapter 13 - Polishing Up
Cleaning Up Before Distribution 16:48
Chapter 14 - Security
Security Techniques 15:59
Chapter 15 - Import/Export
External Data & Importng/Exporting Data 16:39
Chapter 16 - Linking to Data
Linking to Excel & Linking to Another Database 9:25
Chapter 17 - Splitting Database
Separating/Splitting Up Forms, Reports, etc from Database 9:37
Chapter 18 - Multi-User
Options for Making Changes When Database is Multi-User 14:56
Chapter 19 - Reports
Advanced Features for Reports 12:35 Advanced Features for Reports part 2 12:50
Chapter 20 - Package & Distribute
Distributing Application 15:00

Microsoft Access 2010 Online Training Course Overview

Our Microsoft Access 2010 Advanced training course can be accessed anytime, anywhere. Why purchase another training DVD or CD with fancy packaging when you can watch our Microsoft Access 2010 training tutorials from any computer!

During this 8-hour Access 2010 advanced level online training class, your trainer will take you through the ever-important steps to ensure your database is fully functional.

Here are some of the topics we'll cover during the Learn Microsoft Access 2010 training videos:

Importing and exporting your database.

Learn the basics of VBA - Visual Basic for Applications.

Creating relationships between tables within your database.

And much more!

Any subscription includes access to our entire training library. Watch, rewind and repeat the training as often you like while you subscription is active. Any new course released while your subscription is active can be viewed too..

ANNUAL Membership to SimonSezIT.com ($147 for 365 days. SAVE 51% per month. Includes FREE training DVD!) This is an annual membership to SimonSezIT.com which includes access to all online training courses. You will NOT be charged again when your membership expires. Only $12.25 per month.

MONTHLY Membership to SimonSezIT.com
($25 for the first 30 days. Then $25.00 for each 30 days.) Does not include free training DVD. This is a monthly membership to SimonSezIT.com which includes access to all online training courses. You will be charged each month as long as you are a member. You can cancel at any time.

As you've seen on: