Microsoft Access 97 Tutorial Video

Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. It works on both PC and Mac.

These Microsoft Access 97 tutorials offers detailed instruction for the beginner to advanced user who wishes to get more out of this powerful relational database application. The easy to follow method that's employed can be related to having your own personal tutor sat right next to you, using narrated QuickTime videos and real world examples users will be able to learn precisely what they need to be able to use this application in a business environment. No reading is needed, all training is presented right on your own computer screen. An excellent way to fit high quality training into a busy life style, and at a great price too. If your looking for training on a more recent version: Microsoft Access 2007 Tutorials.

try for free

Microsoft Access Tutorial CD / DVD

Create the best self-paced learning environment
right on your own desktop.

Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Learn for FREE - NOW. To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

Benefits
  • Professional Tuition from an Expert
  • Free Certificate with Each Tutorial
  • Works on PC or Mac
Just Released This Week
Apple Logic Pro 9 tutorial video
Logic Pro 9 Tutorial Video »
Topics Covered on this Training Video Include:
Introduction
Access Basics
Table Structure & Data Types
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
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
UK & Europe
Apex Web Media
PO Box 398
Bolton, BL7 9RZ
United Kingdom
T: 01204 592071
USA & Canada
600 17th Street, Suite 2800, Denver CO 80202
Open 8am - 5pm M to F (EST)
Tel - Toll free 1866 402 1903 ( USA )
Tel 434-878-4158
Fax 1 207 433 4356