Microsoft Access 97 Tutorial Video - Try for FREE

Introduction

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

Access Basics

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

Table Structure & Data Types

• The Structure of a Table Demo
• Data Types Demo

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