Books & Videos

Table of Contents

Chapter: Introduction

Introduction to Access 2013 LiveLessons

04m 17s

Chapter: Lesson 1: Access As A Development Tool

Learning Objectives

00m 24s

Why Microsoft Access?

02m 13s

What Types of Applications Can I Build with Microsoft Access?

02m 55s

Chapter: Lesson 2: VBA: The Basics

Learning Objectives

00m 31s

What Types of Modules are Available?

03m 5s

Working with Variables

06m 28s

Working with Constants

03m 5s

Adding Comments to Your Code

01m 15s

Using the Line Continuation Character

02m 52s

Using VBA Control Structures

11m 55s

Passing Parameters and Returning Values

06m 0s

Executing Procedures in the Code Window

03m 38s

The DoCmd Object: Performing Macro Actions

02m 12s

Working with Built-In Functions

07m 32s

Using Built-In Dialog Boxes

03m 27s

Editor Tips and Tricks

07m 13s

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

Learning Objectives

00m 36s

Understanding Access’s Object Model

03m 53s

Understanding Objects, Properties, Events, and Methods

03m 36s

Referring to Objects

04m 11s

Declaring and Assigning Object Variables

03m 15s

Differences Between Objects and Collections

04m 18s

Passing Objects to Subroutines and Functions

02m 44s

Determining the Type of a Control

05m 16s

Special Properties That Refer to Objects

02m 57s

Chapter: Lesson 4: Debugging: Your Key To Successful Development

Learning Objectives

00m 35s

Avoiding Bugs

02m 10s

Harnessing the Power of the Immediate Window

07m 23s

Using Breakpoints to Troubleshoot

01m 38s

Stepping Through Code

04m 34s

Setting the Next Statement to Execute

02m 17s

Using the Call Stack Window

02m 4s

Working with the Locals Window

03m 22s

Working with the Watch Window

05m 30s

Chapter: Lesson 5: Error Handling: Preparing For The Inevitable

Learning Objectives

00m 37s

Implementing Error Handling

03m 52s

Using On Error Statements

04m 10s

Using Resume Statements

03m 51s

The Cascading Error Effect

02m 50s

Raising an Error

01m 19s

Using the Errors Collection

02m 14s

Creating a Generic Error Handler

06m 38s

Preventing Your Own Error Handling from Being Invoked

01m 57s

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

Learning Objectives

00m 36s

DAO versus ADO – When to Use Each

02m 15s

The Data Access Object Model

01m 4s

Getting to Know DBEngine

01m 34s

Using CurrentDB()

01m 14s

Working with DAO Recordset Types

02m 46s

DAO Recordset Properties and Methods

08m 22s

Using DAO Code to Modify Table Data

04m 19s

Using DAO Code to Modify Database Objects

06m 31s

Examining the ADO Object Model

00m 47s

Working with Connections

01m 16s

Working with ADO Recordset Types

02m 41s

ADO Recordset Properties and Methods

11m 24s

Using ADO Code to Modify Table Data

05m 36s

Using ADO Code to Modify Database Objects

06m 25s

Chapter: Lesson 7: Advanced Form Techniques

Learning Objectives

00m 33s

Form Events and When To Use Them?

08m 36s

Order of Events for Forms

00m 47s

Utilizing Section and Control Events

07m 47s

Taking Advantage of Built-In Form-Filtering Features

07m 39s

Switching a Form’s Record Source

04m 29s

Power Combo Box and List Box Techniques

07m 3s

Synchronizing a Form with Its Underlying Recordset

02m 37s

Chapter: Lesson 8: Advanced Report Techniques

Learning Objectives

00m 27s

Report Events and When to Use Them

06m 46s

Order of Events for Reports

00m 53s

Practical Applications of Report Techniques

11m 34s

Chapter: Lesson 9: Advanced Query Techniques

Learning Objectives

00m 25s

Self-Joins

03m 9s

Union Queries

04m 4s

Subqueries

01m 26s

The Propagation of Nulls and Query Results

02m 12s

Using User-Defined Functions with Queries

04m 11s

Chapter: Lesson 10: Macro Basics

Learning Objectives

00m 33s

The Basics of Creating and Running a Macro

04m 39s

Harness the Power of Submacros

04m 8s

Control your Macros Using Program Flow

05m 29s

Run a Macro from the Macros Group of the Navigation Pane

01m 16s

Trigger a Macro from a Form or Report Event

03m 25s

Modify an Existing Macro

01m 50s

Create an Embedded Macro

03m 53s

Chapter: Lesson 11: Advanced Macro Techniques

Learning Objectives

00m 32s

Create Data Macros

03m 47s

Create a Drillthrough Macro

03m 38s

Learn What Other New Features Are Available in Macros

06m 33s

Debug a Macro

03m 58s

Convert a Macro to VBA Code

03m 51s

Create an AutoExec Macro

02m 15s

Chapter: Lesson 12: Advanced VBA Techniques

Learning Objectives

00m 34s

Working with Arrays

05m 29s

Advanced Function Techniques

09m 45s

Working with Empty and Null

07m 39s

Creating and Working with Custom Collections

02m 50s

Chapter: Lesson 13: Exploiting The Power Of Class Modules

Learning Objectives

00m 27s

Creating and Using a Class Module

10m 43s

Creating Multiple Class Instances

03m 22s

More About Class Modules

16m 57s

Class Modules in Use

08m 42s

Chapter: Lesson 14: Using External Data

Learning Objectives

00m 29s

Using Code to Import External Data

02m 40s

Using Code to Link to External Data

06m 30s

Refreshing and Removing Links

02m 7s

Chapter: Lesson 15: Automation: Communicating With Other Applications

Learning Objectives

00m 31s

Creating an Automation Object

04m 31s

Controlling Excel from Access

08m 28s

Closing an Excel Automation Object

02m 10s

Creating a Graph from Access

04m 33s

Controlling Word from Access

03m 30s

Controlling PowerPoint from Access

04m 35s

Controlling Outlook from Access

04m 14s

Chapter: Lesson 16: Exploiting The Power Of The Windows API

Learning Objectives

00m 38s

Declaring a Windows API Function

01m 21s

Using a Windows API Function

01m 38s

Getting Information About the Operating Environment

03m 31s

Determining Drive Information

04m 32s

Chapter: Lesson 17: Developing Client/Server Applications

Learning Objectives

00m 44s

Understanding the Client/Server Model

03m 20s

Deciding Whether to Use the Client/Server Model

03m 51s

Roles Access Plays in the Application Design Model

02m 18s

Defining an ODBC Data Source

04m 27s

Upsizing an existing Access Database

08m 54s

Working with Linked Tables

04m 13s

Working with SQL Server Views

05m 22s

Using Pass-Through Queries

05m 9s

Executing Stored Procedures

11m 39s

Working with SQL User-Defined Functions

03m 33s

Building Client/Server Friendly Forms

08m 45s

Building Client/Server Friendly Reports

02m 53s

Chapter: Lesson 18: Working With And Customizing Ribbons

Learning Objectives

00m 31s

Customizing the Ribbon

05m 8s

Applying a Custom Ribbon when a Database Opens

02m 19s

Associating a Custom Ribbon with a Form or Report

06m 1s

Executing a Macro from a Ribbon

03m 20s

Chapter: Lesson 19: Putting It All Together – A Complete Application

Learning Objectives

00m 32s

Designing the Tables to Store Your Data

01m 49s

Building the Queries to Extract the Data You Need

01m 32s

Building the Forms to Edit Your Data

02m 3s

Designing the Reports to Display Your Data

02m 33s

Building the Macros Necessary to Automate Your Application

03m 8s

Polishing Off Your Application with the Necessary VBA Code

05m 17s

Chapter: Summary

Summary of Access 2013 LiveLessons

01m 21s