Microsoft Access 97 Video Tutorial - Training CD

Affordable Training you can depend on. Learn from an Expert from the comfort of your own desk, at a pace that suits you.

Benefits

• Works on PC or Mac
• Professional Tutition by Experts
• Self-Paced Learning Interface
• Builds Practical Skills Quickly
• Rapid Learning - High Retention
• Free Certificate with each Tutorial

Client Testimonials

• I just joined your Online University, and so far you guys are great! I love the amount of training that I can watch day or night. Tasks that had me baffled in the past are now put in to plain English right before my eyes in my own home. I sure wish I had found you guys before.
  Jake Holt
  Pinecrest Florida

Just Released Training

Just Released this week.
• 
Poser 8 Tutorial Video

Topics covered on this Tutorial Video
are Listed Below:-

Introduction

• Introduction
• Design Basics
• Example Databases
• The 6 Access Objects
• One to Many Relationships

Access Basics

• Starting Access97
• Screen Tips
• Keyboard Setup
• Accessing Help
• Help Menu
• The Office Assistant
• Setting Option

Table Structure & Data Types

• The Structure of a Table
• Data Types

The purchased version of this product contains all the movies listed below as well as all the featured samples above. US$ 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

An effective training video that teaches using practical based examples and easy to follow instructions.

A self-paced learning interface that simplifies learning and breaks even the most complex topics down into easy to follow step-by-step instructions making it ideal for users of all levels

A proven video training product that's created by professionals and used by companies, schools, government and individuals the World over.

A verifiable Certificate Proving your Skills

Microsoft Access 97 Training - VIDEO INFO

TitleMicrosoft Access 97

TutorJohn Baddeley

Duration8 hours - 138 Movies

Price US$ 99.95

OSWin Vista XP, 2000, 98. Mac OS X

Delivery Ground / 2 day / Next Day

Product Code33042