Access 2010 - Advanced

3 Hours, 55 Minutes
Delivery Method
LearnNow On Demand

This course builds on the Introduction and Intermediate courses to show techniques to bring all of the different Access objects together to make a cohesive application. It does this by showing the viewer how and why Microsoft Access utilizes the Properties and Events of the different objects. Finally, the course shows the viewer how to create macros using the new Macro editor and how to select the proper Control and Event for the best possible outcome.


Purchase This On Demand Title or a LearnNow On Demand subscription

Access 2010 - Advanced
  Buy Now $39.99 Purchase this course for 12 months.
  Buy Now $99.95 Purchase this course and hundreds of others with our LearnNow On Demand 12-month subscription.

Course Objectives

    Designing the Application, Table Data Macros, Creating Advanced Queries, Advanced Form Design, Macros, System Wrap-Up


1 - Introduction
  • Introduction
2 - Designing the Application
  • Reviewing Access Development Phases
  • Defining Database Architecture
  • Using an Entire Database on a Server
  • Splitting the Database
  • Creating a Database Project: SQL Server
  • Integrating with SharePoint
3 - Table Data Macros
  • Different Data Macro Types
  • Event-Driven Data Macro
  • The Application Log
4 - Creating Advanced Queries
  • Using Left and Right Joins
  • Creating a Crosstab Query
  • Using Access Function Within a Query
5 - Advanced Form Design
  • Creating an Autofill Form
  • Forms and Subforms
  • Advanced Calculated Controls
  • Using the Tab Control
  • Option Group Control
6 - Macros
  • Different Macro Types
  • Reviewing the Object Events
  • Creating Macros
7 - System Wrap-Up
  • AutoStart Options
  • Documenting a Database
  • Encrypting and Decrypting a Database
  • Converting to an .accde File
  • Packaging the Database
8 - Conclusion
  • Course Recap