Learn Microsoft Access 97

Unlimited Online Training and Tutorials

Microsoft Access 97 Online Video Training and Tutorials by John Baddeley consists of approximately 8 hours of training over 138 lessons. Start learning right now, free. Just click any lesson below to begin.

Course Outline For:

Microsoft Access 97

Start learning Microsoft Access 97 right away, Free! Click on the highlighted lesson links below to view the lessons immediately. You will require Quicktime. If you have any problems viewing the lessons, click here

Introduction

One to Many Relationships

Access Basics

Table Structure & Data Types

The Structure of a Table

Data Types

More lessons below ...

Would you like to continue? You can have instant access to the rest of this training for just $30.00

Subscribe Now!

Field Properties

Intro/Field Size

Format

Input Mask

Caption

Default Value

Validation Rule/Text

Required

Indexed

Primary KeY

Working with an Existing DB

Open an Existing Database

Passwords

Relationships

Documenter

Working in DataSheet View

DataSheet View

Sort & Find

Filter by Selection

Filter by Form

Saving a Filter

Navigating DataSheets

Adjust Column Width

Freeze/Unfreeze

Appearance

Data Entry

Delete, Copy, Paste

Printing DataSheets

Save & Close DataSheets

Using Forms

Introduction to Forms

Form Design Basics

Form Types

Form Views

Data Entry using Forms

Printing Forms

Save and Close Forms

Pop-up and Modal Forms

Using Queries

Introduction to Queries

Query Types

Query DataSheet View

Query Design View

SQL View

Saving Queries

Using Reports

Introduction to Reports

Viewing a Report

Report Types

Printing Reports

Create a New Database

Database Structure

Create a Database

Creating Tables

Ways to Create a Table

Creating Fields

Setting Properties

Adding Fields

Setting a Primary Key

Lookup Wizard

Table Wizard

The Contacts Table

Setting up Relationships

Relationship - Why?

Prerequisites

The Relationships Window

Referential Integrity

Creating Forms

Create Forms Manually

Autoforms

Forms Wizards

Form Design Facilities

Controls Overview

Moving & Sizing Controls

Formatting Controls

Alignment

Add & Delete Controls

Changing Form Size

Headers & Footers

Calculations (1)

Calculations (2)

Calculations(3)

Creating Command Buttons

Add a Combo-box

Create a Main & SubForm

Creating Queries

Introduction to Queries

New Query Options

Query Design View

Adding fields to QBE grid

Adding a Table

Running Queries

Sorting in a Query

Entering Criteria

Ranges in Criteria

Tips on Criteria

More Tips on Criteria

And/Or

Calculated Fields

Names & Numbers Query

Saving Queries

Parameter Queries

Totals Queries

Expression Builder

Creating Reports

Introduction to Reports

Creating Reports

Report Design View

Sorting & Grouping

More Sorting and Grouping

Layout Problems

Layout Problems, continued

Mailing Labels

Adding Calculated Fields

Adding Group Totals

Adding Sum Totals

External Data

Introduction

Importing Data

Importing from Excel

Mailmerging with Word

Linking/Attaching Tables

Replication

Replication Introduction

Replication Help

Considerations

Security/Backing Up

Security Introduction

Further Information

Everything about backing up

Macros

Macro Introduction

Example Macro

Conditional Macros

Publish on the Web

Introduction

The Web Wizard

View the Web Page

Switchboards

Create a Switchboard

Add Buttons

Improve Appearance

Microsoft Access 97 Video Training Detail:

Instructor:	John Baddeley
Course Lessons:	138 Total Lessons
Course Duration:	8hrs total
First Release Date:	1998-04-02
Course Price:	N/A - Included with membership
Monthly Membership:	$30 month to month
Annual Membership:	$250 annually
Courses Included:	ALL Training Titles

Sign Up Now and Start Learning!

Course Description:

To get started, simply click one of the topics below.

Sign Up Now and Start Learning!

WHY BECOME A MEMBER?

This is the easiest, best, most cost effective way to learn Microsoft Access 97 from VTC Instructor John Baddeley?

Huge Learning Library Included - Access to one course includes access to our entire learning library of over 400 courses with 55,000+ lessons.

Superior Teaching Methods - No Books or classrooms! Combined video and audio delivered on your PC or Mac in bite size lessons - superior learning and retention. Many courses includes downloadable work files!

Flexible Learning - Learn on your schedule, at your pace... starting 60 seconds from now if you like!

Certifications - Downloadable (and third party verifiable) Certificates of Completion with each course you complete.

No Long Term Commitment - You CAN subscribe for a year to save $$, but you are also welcome to go month to month and cancel or suspend at anytime, no questions asked.

Proven Worldwide - Tens of thousands of students, professionals, small businesses, big businesses, schools, and governments around the globe use our training - Over 400 new members join every day.

Sign Up Now and Start Learning!

Students | Small Business | Big Business | Government | Schools

Try ANY Course Free | Available Courses | Complete F.A.Q. | Multi-User Accounts | Training on CDRom