Microsoft Access 2000 - Tutorial Videos - Training CD

Training CDs > Databases Tutorial Videos > MICROSOFT ACCESS 2000

Affordable Training you can depend on
This Microsoft Access 2000 tutorial video utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that brings a high degree of visual clarity to even the most complex applications. Being over 12 hours long these Microsoft Access 2000 tutorials on CD are extremely comprehensive and easy to follow. Video Training by Experts - Low Cost.

Not sure which Tutorial Video CD to buy?
The Online University allows unlimited access to the entire range of training titles for one low fee of only $30 per month. There is no fixed term, no limits, and you can cancel at any time. For corporate users and schools we also offer multi user accounts.
Find out more about the online video tutorials »

About the Free Video Online Training Course Demos
To allow you to evaluate the quality of these Microsoft Access 2000 training videos we have made the first 3 chapters of this tutorial available for free viewing online. The purchased version of this video training course contains all the topics listed below. Please Note: the free demos below have been compressed for faster playback over the internet, the audio and video quality of the purchased CD / DVD is far higher.

THIS TUTORIAL VIDEO COVERS THE FOLLOWING:

Details

This Microsoft Access Tutorial Video is the ideal learning resource for the beginner – intermediate user. The training covers both basic and advanced techniques. Users will learn about database structure, relationships, primary keys, queries, reports and much more. The tutorial video lessons use a fictitious database as the platform for this course, allowing users to follow along through the various different stages of Access database design and deployment. The visual nature of the training video aids learning, and users have total control of the speed at which the tutorial progresses.

The Blue Links below are free demos, when you purchase the video tutorial CD the enitre content listings below are included , not just the free demo videos.

Introduction

Access Basics

Table Strcuture and 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 Database

Open an Existing Database
Passwords
Relationships
Documenter

Working in Datasheet View

DATASHEET VIEW
Sort & Find
Filter by Selection
Filter by Form
Save a Filter
Navigating Data Sheets
Adjust Column Width
Freeze & Unfreeze
Appearance
Data Entry
Delete, Copy, Paste
Printing Datasheets
Selecting Records To Print

Using Forms

Introduction to Forms
Form Design Basics
Form Types
Form Views
Data Entry Using Forms
Printing Forms
Save & Close Forms
Pop-up & Modal Forms

Using Queries

Intro to Queries
Query Types
Query Views
Calculation Queries
Saving Queries

Usign Reports

Intro to Reports
Viewing a Report
Report Types
Printing a Report

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

Relationships - Why?
Prerequisites
The Relationships Window
Referential Integrity

Creating Forms

Create Forms Manually
Auto Forms
Form Wizard
Form Design Facilities
Form Controls Overview
Moving & Sizing Controls
Formatting Controls
Alignment
Add & Delete Controls
Changing Form Size
Headers & Footers
Create a Main and Sub-Form
Calculations (1)
Calculations (2)
Creating Command Buttons
Add a Combo Box

Creating Queries

Intro 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
Saving Queries
Parameter Queries
Totals Queries
Expression Builder

Creating Reports

Intro to Reports
Creating Reports
Report Design View
Sorting & Grouping
Layout Problems
Mailing Labels
Adding Calculated Fields
Adding Group Totals
Adding Sum Totals

Creating Data Access Pages

Intro to Pages
Creating Pages
Use the Page Wizard
Accessing Data from the Web

External Data

Introduction
Importing Data
Importing from Excel
Mail Merging with Word
Linking & Attaching Tables

Replication

Replication Overview
Setting Up Replicas
Types of Security
User-Level Security Wizard
Backing Up Data

Macros

Introduction
Example Macro
Conditional Macros

Switchboards

Create a Switchboard
Add Buttons
Improve Appearance

Microsoft Access 2000 Tutorial VIDEO INFO

» Studio quality audio and video
» Works on Pc or Mac
» Ideal for people that learn quicker by being shown
» Master complex application in days

Title	:	Microsoft Access 2000
Instructor	:	Angie Rawling/NMG
Price	:	US$ 99.95
Duration	:	12 hours - 132 Movies
OS	:	Win Vista XP 98,2000,ME. Mac OS 9, OS X
Delivery Options	:	Ground / 2 day / Next Day
Product Code	:	33106

BENEFITS OF THIS TUTORIAL TRAINING VIDEO

Learn Microsoft Access 2000 in the shortest time possible
Self paced tutorial, training on video, learn at your own pace
Just sit back and watch, no books to read, just easy to follow lessons
Training can be viewed from any location, on PC or Mac
All training is self-contained; you don’t even need the application you are learning loaded on your machine
The most affordable way to learn, benefit from a world-leading expert
High quality content for a fraction of the cost of a classroom training course
The tutorials can be rewound, fast forwarded or stopped at any time
Learn from the comfort of your own desk.

Prove your Skills. Free Certification with every course.

With every tutorial purchased a certificate is provided to prove you have embarked upon a course to improve your skills and expand your working knowledge. Each certificate has a unique verification number which enables third parties to check the authenticity of the certification using a special login verification process.