clear-dot.gif
Search for a Title:
AddThis Social Bookmark Button
clear-dot.gif ON NOW: ALL Training CD's on sale for $99.95 CDN!!! clear-dot.gif
clear-dot.gif
   Master Microsoft Access 2000 - Free Tutorials!
clear-dot.gif
clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif
Microsoft Access 2000 gives you powerful new tools for managing you data. You can share your database with coworkers over an intranet, find and retrieve information quickly, and take advantage of pre-packaged automated solutions to quickly create databases. In Virtual Training Company's tutorial, author Lorie Flenner begins very basic, explaining the key concepts behind Access and relational database theory. Go through using an existing database, then smoothly into creating a new database and new forms, queries, and reports. Click any of the topics below to get started right away.
Microsoft Access 2000 Training
Access the complete Microsoft Access 2000 Training title online with just your Web browser. Join our Online University and have unlimited access to these tutorials for Microsoft Access 2000 plus all our 400+ other titles for one low price! LEARN MORE or SIGN UP NOW FOR INSTANT ACCESS
OR
Learn Microsoft Access 2000 from our PC and Mac compatible CDRom. The affordable price of $124.95 gives you high quality software training that is easy for anyone to understand and follow. Start training straight away with our Free lesson links on the right or BUY THIS CD NOW!

Are you ready to start your learning RIGHT NOW? You can have immediate access to more than 2500 hours of VTC Training just minutes from now, and for the incredibly low price of $30/month OR LESS!

The VTC Online University provides unlimited 24/7 access to ALL of VTC's incredible training content.

-- More Info / Subscribe Now! --

FREE Updates
VTC adds training for new software every week, and with the VTC Online University, you get immediate access to these new titles, for no additional cost! There are currently over 450 different software titles, and more are added EVERY MONTH!

-- More Info / Subscribe Now! --

No Long Term Committment
With the VTC Online University, you can signup for as little as ONE MONTH only! There is no minimum time committment, and you can cancel your membership at any time.

-- More Info / Subscribe Now! --

Training a Group?
Our Multi-User Online Account makes training groups of people efficient and cost effective. Businesses, Schools (from Elementary through Post Secondary), and Government Departments alike all over the world enjoy the freedom and benefits of our online training and tutorials from office, school, home, and on the go.

-- Multi-User Licensing Info --

Microsoft Access 2000
- Information About This Title -
Click Here To Purchase
Proper Title: Microsoft Access 2000
Description: Click here to open / close full description
Microsoft Access 2000 gives you powerful new tools for managing you data. You can share your database with coworkers over an intranet, find and retrieve information quickly, and take advantage of pre-packaged automated solutions to quickly create databases. In Virtual Training Company's tutorial, author Lorie Flenner begins very basic, explaining the key concepts behind Access and relational database theory. Go through using an existing database, then smoothly into creating a new database and new forms, queries, and reports. Click any of the topics below to get started right away.

-Close-
Instructor: Angie Rawling/NMG (more by this author)
Instruction: 132 Tutorials - Duration: 12 hrs
First Release: 2000-05-01
Compatitibility: Vista, XP, NT, 2000, 98, Mac OS9, Mac OS X 10.1+
In Stock? Yes - 2-5 days shipping
Price: $124.95 $99.95 ON SALE!
Click Here To Purchase
Why Learn With VTC?!
  1. Let an expert teach you Microsoft Access 2000
  2. No classrooms or schedules - you learn on YOUR terms
  3. No books to read - watch instructional video right on your computer
  4. VTC training methods ensure the highest possible retention and fastest learning
  5. Use VTC materials for future reference / refresher
  6. Share CDRom training with others, friends, colleagues
  7. Used by many schools, universities, and big business world wide
  8. The most cost effective training available for Microsoft Access 2000
 
Below is content list for all of the lessons included with the Microsoft Access 2000 Training. Click on the linked lessons to watch Free. You must have Quicktime installed on your computer - if you are using a recent computer, then chances are you already do.
Free Demo Lessons

Introduction
movie image Introduction
movie image Design Basics
movie image Example Databases
movie image The 7 Access Objects
movie image Relationships

Access Basics
movie image Starting Access 2000
movie image Screen Tips
movie image Keyboard Setup
movie image Accessing Help
movie image The Office Assistant
movie image Setting Options

Table Strcuture and Data Types
movie image The Structure of a Table
movie image 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 through our Online University, or you can purchase the CDRom version!

. Subscribe Now!
. Online University Info
. Purchase CDRom Now

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
alculated Fields
aving 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
Create a Switchboard
Add Buttons
Improve Appearance
clear-dot
blue dot
clear-dot

Want to be notified of new releases and other product information?
Enter your email address below to signup for our newsletter.

clear-dot
blue dot
clear-dot
Online Learning | Contact Us | Tech Support | XML RSS Feed
clear-dot
blue dot

VTC Canada
sales@vtcCanada.com


©2012 VTC Canada All Rights Reserved.