Learn Microsoft Access 2000

Unlimited Online Training and Tutorials

Microsoft Access 2000 Online Video Training and Tutorials by Angie Rawling/NMG consists of approximately 12 hours of training over 132 lessons. Start learning right now, free. Just click any lesson below to begin.

Course Outline For:

Microsoft Access 2000

Start learning Microsoft Access 2000 right away, Free! Click on the highlighted lesson links below to view the lessons immediately. You will require Quicktime. If you have any problems viewing the lessons, click here

Introduction

Access Basics

Table Strcuture and Data Types

The Structure of a Table

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

Subscribe 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

Microsoft Access 2000 Video Training Detail:

Instructor:	Angie Rawling/NMG
Course Lessons:	132 Total Lessons
Course Duration:	12hrs total
First Release Date:	2000-05-01
Course Price:	N/A - Included with membership
Monthly Membership:	$30 month to month
Annual Membership:	$250 annually
Courses Included:	ALL Training Titles

Sign Up Now and Start Learning!

Course 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.

Sign Up Now and Start Learning!

WHY BECOME A MEMBER?

This is the easiest, best, most cost effective way to learn Microsoft Access 2000 from VTC Instructor Angie Rawling/NMG?

Huge Learning Library Included - Access to one course includes access to our entire learning library of over 400 courses with 55,000+ lessons.

Superior Teaching Methods - No Books or classrooms! Combined video and audio delivered on your PC or Mac in bite size lessons - superior learning and retention. Many courses includes downloadable work files!

Flexible Learning - Learn on your schedule, at your pace... starting 60 seconds from now if you like!

Certifications - Downloadable (and third party verifiable) Certificates of Completion with each course you complete.

No Long Term Commitment - You CAN subscribe for a year to save $$, but you are also welcome to go month to month and cancel or suspend at anytime, no questions asked.

Proven Worldwide - Tens of thousands of students, professionals, small businesses, big businesses, schools, and governments around the globe use our training - Over 400 new members join every day.

Sign Up Now and Start Learning!

Students | Small Business | Big Business | Government | Schools

Try ANY Course Free | Available Courses | Complete F.A.Q. | Multi-User Accounts | Training on CDRom