Video description

Table of Contents

Introduction

Introduction to Access 2013 LiveLessons

Lesson 1: Access As A Development Tool

Learning Objectives

Why Microsoft Access?

What Types of Applications Can I Build with Microsoft Access?

Lesson 2: VBA: The Basics

Learning Objectives

What Types of Modules are Available?

Working with Variables

Working with Constants

Adding Comments to Your Code

Using the Line Continuation Character

Using VBA Control Structures

Passing Parameters and Returning Values

Executing Procedures in the Code Window

The DoCmd Object: Performing Macro Actions

Working with Built-In Functions

Using Built-In Dialog Boxes

Editor Tips and Tricks

Lesson 3: Objects, Properties, Methods, And Events Explained

Learning Objectives

Understanding Access’s Object Model

Understanding Objects, Properties, Events, and Methods

Referring to Objects

Declaring and Assigning Object Variables

Differences Between Objects and Collections

Passing Objects to Subroutines and Functions

Determining the Type of a Control

Special Properties That Refer to Objects

Lesson 4: Debugging: Your Key To Successful Development

Learning Objectives

Avoiding Bugs

Harnessing the Power of the Immediate Window

Using Breakpoints to Troubleshoot

Stepping Through Code

Setting the Next Statement to Execute

Using the Call Stack Window

Working with the Locals Window

Working with the Watch Window

Lesson 5: Error Handling: Preparing For The Inevitable

Learning Objectives

Implementing Error Handling

Using On Error Statements

Using Resume Statements

The Cascading Error Effect

Raising an Error

Using the Errors Collection

Creating a Generic Error Handler

Preventing Your Own Error Handling from Being Invoked

Lesson 6: What Are Activex Data Objects And Data Access Objects And Why Are They Important?

Learning Objectives

DAO versus ADO – When to Use Each

The Data Access Object Model

Getting to Know DBEngine

Using CurrentDB()

Working with DAO Recordset Types

DAO Recordset Properties and Methods

Using DAO Code to Modify Table Data

Using DAO Code to Modify Database Objects

Examining the ADO Object Model

Working with Connections

Working with ADO Recordset Types

ADO Recordset Properties and Methods

Using ADO Code to Modify Table Data

Using ADO Code to Modify Database Objects

Lesson 7: Advanced Form Techniques

Learning Objectives

Form Events and When To Use Them?

Order of Events for Forms

Utilizing Section and Control Events

Taking Advantage of Built-In Form-Filtering Features

Switching a Form’s Record Source

Power Combo Box and List Box Techniques

Synchronizing a Form with Its Underlying Recordset

Lesson 8: Advanced Report Techniques

Learning Objectives

Report Events and When to Use Them

Order of Events for Reports

Practical Applications of Report Techniques

Lesson 9: Advanced Query Techniques

Learning Objectives

Self-Joins

Union Queries

Subqueries

The Propagation of Nulls and Query Results

Using User-Defined Functions with Queries

Lesson 10: Macro Basics

Learning Objectives

The Basics of Creating and Running a Macro

Harness the Power of Submacros

Control your Macros Using Program Flow

Run a Macro from the Macros Group of the Navigation Pane

Trigger a Macro from a Form or Report Event

Modify an Existing Macro

Create an Embedded Macro

Lesson 11: Advanced Macro Techniques

Learning Objectives

Create Data Macros

Create a Drillthrough Macro

Learn What Other New Features Are Available in Macros

Debug a Macro

Convert a Macro to VBA Code

Create an AutoExec Macro

Lesson 12: Advanced VBA Techniques

Learning Objectives

Working with Arrays

Advanced Function Techniques

Working with Empty and Null

Creating and Working with Custom Collections

Lesson 13: Exploiting The Power Of Class Modules

Learning Objectives

Creating and Using a Class Module

Creating Multiple Class Instances

More About Class Modules

Class Modules in Use

Lesson 14: Using External Data

Learning Objectives

Using Code to Import External Data

Using Code to Link to External Data

Refreshing and Removing Links

Lesson 15: Automation: Communicating With Other Applications

Learning Objectives

Creating an Automation Object

Controlling Excel from Access

Closing an Excel Automation Object

Creating a Graph from Access

Controlling Word from Access

Controlling PowerPoint from Access

Controlling Outlook from Access

Lesson 16: Exploiting The Power Of The Windows API

Learning Objectives

Declaring a Windows API Function

Using a Windows API Function

Getting Information About the Operating Environment

Determining Drive Information

Lesson 17: Developing Client/Server Applications

Learning Objectives

Understanding the Client/Server Model

Deciding Whether to Use the Client/Server Model

Roles Access Plays in the Application Design Model

Defining an ODBC Data Source

Upsizing an existing Access Database

Working with Linked Tables

Working with SQL Server Views

Using Pass-Through Queries

Executing Stored Procedures

Working with SQL User-Defined Functions

Building Client/Server Friendly Forms

Building Client/Server Friendly Reports

Lesson 18: Working With And Customizing Ribbons

Learning Objectives

Customizing the Ribbon

Applying a Custom Ribbon when a Database Opens

Associating a Custom Ribbon with a Form or Report

Executing a Macro from a Ribbon

Lesson 19: Putting It All Together – A Complete Application

Learning Objectives

Designing the Tables to Store Your Data

Building the Queries to Extract the Data You Need

Building the Forms to Edit Your Data

Designing the Reports to Display Your Data

Building the Macros Necessary to Automate Your Application

Polishing Off Your Application with the Necessary VBA Code

Summary

Summary of Access 2013 LiveLessons