Access 2010 - Advanced

Overview

About this course

Self-paced lessons on advanced Access 2010: application design, data macros, advanced queries and forms, and macros.

Curriculum

Curriculum

8 modules

Introduction

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

Different Data Macro Types
Event-Driven Data Macro
The Application Log

Using Left and Right Joins
Creating a Crosstab Query
Using Access Function Within a Query

Creating an Autofill Form
Forms and Subforms
Advanced Calculated Controls
Using the Tab Control
Option Group Control

Different Macro Types
Reviewing the Object Events
Creating Macros

AutoStart Options
Documenting a Database
Encrypting and Decrypting a Database
Converting to an .accde File
Packaging the Database

Course Recap

Who it's for

Who it's for

Users maintaining Access 2010 databases.

Before you start

No formal prerequisites. Bring curiosity and a willingness to practise.