These training classes use broadcast quality audio and video to deliver concise and informative training right to your desktop. The course is presented via an intuitive, easy-to-use interface, allowing you to learn at your own pace.

These Advanced Microsoft Access 2010 Tutorials break even the most complex subjects down into easy to follow segments, following along is simple. Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of training.

01. Getting Started

• 0101 What Will This Course Cover
• 0102 Relational Databases Demystified
• 0103 Using The Working Files
• 0104 About The Author

02. Advanced Table Design

• 0201 Creating And Using Input Masks
• 0202 Indexing - The Hows And Whys
• 0203 Multiple Field Primary Keys

03. Advanced Queries

• 0301 Selecting Unique Values
• 0302 Use Of Parameter Queries
• 0303 Adding A Calculated Field
• 0304 Using iif In A Calculated Field
• 0305 Creating A Cross Tab Query
• 0306 A Cross Tab Without The Wizard
• 0307 Why Change The Join Type In Queries
• 0308 Viewing And Writing SQL
• 0309 Introducing The Expression Builder
• 0310 The Power Of The Sub Query
• 0311 Generating A Union Query In Access

04. Action Queries

• 0401 The Make Table Query - For Backups
• 0402 The Make Table Query From Multiple Tables Of Data
• 0403 Changing Data Using An Update Query
• 0404 Update Query With A User Driven Parameter
• 0405 Add Records To A Table Using The Append Query
• 0406 Delete Records Using The Delete Query
• 0407 Backup And Restore Data Using Action Queries

05. Advanced Form Design

• 0501 Adding Linked Objects And Displaying On A Form
• 0502 Sub Forms Unbound Or Bound
• 0503 Using Tabs To Display Multiple Sub Form Data
• 0504 Referencing Combo Box Unbound Columns
• 0505 The NEW Navigation Forms
• 0506 Creating A Form To Use As A Menu Or Dialog
• 0507 Adding A Form Button With The Wizard
• 0508 Creating Buttons WITHOUT The Wizard
• 0509 Open Another Form-Filtered By Current Form (Method 1)
• 0510 Open Another Form-Filtered By Current Form (Method 2)
• 0511 Building A Search Form
• 0512 Check Whether The Search Criteria Is Entered
• 0513 Use Double Click To Open Related Data
• 0514 Dynamically Changing The Row Source Of A Combo Or List Box

06. Advanced Reports

• 0601 Creating A Report From Scratch Without The Wizard
• 0602 Adding Images To The Report
• 0603 Calculations On A Report
• 0604 Sorting And Grouping A Report
• 0605 Totals On Reports Groups
• 0606 Creating And Adding Sub Reports
• 0607 Concatenation With Carriage Returns
• 0608 Adding A Chart Or Graph
• 0609 A Chart Filtered By The Report Section
• 0610 Pie Charts In Reports

07. Macros

• 0701 Creating A New Macro
• 0702 Example Functionality Of Macros
• 0703 Assigning Macros To Buttons On Forms
• 0704 Using if In A Macro To Control Program Flow
• 0705 Commenting Your Macro Code For Future Reference
• 0706 NEW - The Embedded Macro
• 0707 Sub Macros And Their Uses
• 0708 Trigger A Macro From The Ribbons
• 0709 Controlling Startup Actions With The AutoExec Macro
• 0710 Creating An AutoKeys Macro For Customizing Keyboard Shortcuts
• 0711 Adding An OK/Cancel Confirmation Box

08. Database Utilities

• 0801 Compact And Repair - A Useful Utility
• 0802 Converting Access To Previous Versions
• 0803 Saving A Backup Copy
• 0804 Tracking Object Dependencies
• 0805 The Start Up Settings

09. Application Making And Security

• 0901 Main Menu Tidying Requirements
• 0902 Restricted Access By Use Of The ACCDE Format
• 0903 Download And Distribute Access 2010 Runtime
• 0904 Encrypting And Password Protecting A 2010 Database
• 0905 Splitting The Database In Two For Final Security

10. Access With SQL Server

• 1001 Upgrade An Existing Application To Use SQL Server
• 1002 Linking a New Database To SQL Server
• 1003 Introducing The Access Project File
• 1004 Running A Stored Procedure From The Access Project

11. Summary

• 1101 What Have You Learned?