Downloading Resources

Welcome

The WHERE Syntax

Understanding NOT, !, BETWEEN...AND, IN, NULL, NOT NULL

Understanding Filtering Operators LIKE, , and [ ]

WHERE Part I

WHERE Part II

The SELECT Syntax

Aliasing Columns

SELECT Statements

The ORDER BY Syntax

ORDER BY

Intro to Aggregate Functions

AVERAGE

MIN and MAX

COUNT

Date

Now

Day

MonthName

DatePart

DateAdd

DateDiff

DateValues

Formatting Dates

Using CONCATENATE

LCase and UCase

Left and Right

Mid

Len

Trim, LTrim, and RTrim

Replace

The UPDATE Syntax

The DELETE Syntax

UPDATE

DELETE

Primary Key and Foreign Key

The JOIN Syntax

Common Types of Joins

Aliasing Tables in Joins

JOIN

Subqueries

The CREATE TABLE Syntax

CREATE TABLE I

CREATE TABLE II

The INSERT INTO Syntax

INSERT INTO

ALTER TABLE

Using DISTINCT

Using TOP

Using TRANSFORM and PIVOT to Create Crosstabs

UNION Queries

Get Ready to Transition to VBA

Creating Macros vs. Programming in VBA

Example of an Access Macro

Converting Macros to VBA

Naming Modules

Accessing the Visual Basic Editor

VBA Windows & Toolbars

Adding and Removing Modules

A Few Time Savers When Writing VBA

What to do When You Have Error in Your Code

How VBA Accesses an Object's Properties and Methods

Working with Procedures

Object Oriented Programming

Structure of Sub Procedures

Structure of Functions

Event Procedures

Calling a Sub Procedure or Function

Comments

Introduction

Variable Declaration

The Importance of Data Types

Object Variables

Declaring Constants

About Me

Text Box Values

Exercise Arithmetic Operators

Carriage Return-Line Feed

Test Your Skills

Arrays

Controlling Access of Your Variables & Procedures with Scope

Introduction to Functions

String Functions UCase, and LCase

String Functions Left, Right, and Mid

String Functions InStr

Date and Time Functions Date, and Now

Date and Time Functions Day, Month, and Year

Date and Time Functions DateDiff

Date and Time Functions Time

Date and Time Functions Second, Minute, and Hour

The Format Function Using Named Format Expressions

Using the FormatCurrency Function

Overview of Object Events

Click Events

Focus Events

Mouse Events

Text box Events

Keyboard Events

Test Your Skills

Combo box Events

Introductions to DoCmd

DoCmd OpenTable

DoCmd ApplyFilter

DoCmd OpenReport

DoCmd OpenForm

DoCmd CopyObject

DoCmd OutputTo

DoCmd RunCommand

DoCmd SendObject

DoCmd TransferDatabase

DoCmd RunSQL

DoCmd TransferSpreadsheet

The Select Case Statement

Test Your Skills II

The IF THEN Statement

Test Your Skills

Input Boxes

Message Boxes

Exercise Input Boxes & Message Boxes

Introduction to Loops

For Next Loop Introduction

For Each Next Loop Introduction

For Next Loop

For Each Loop

Do While Loop Introduction

Do Until Loop Introduction

Do While Loop

Opening and Closing a Recordset

Adding New Records

Editing a Record

Deleting a Record

Counting Records

Introduction to Debugging and Error Handling

Debugging The Watch Window

Debugging The Locals Window

Error Handling The On Error Resume Next Statement

Debugging Setting a Breakpoint & Stepping Through Code

Debugging The Immediate Window

Error Handling The Err Object