Home
Username:
Password:
Microsoft Access 2000 Training

CD Contents For This Title

 All the chapters and lesson contents of Microsoft Access 2000 are listed below.

To help you evaluate our training, we have made some of the tutorials for Microsoft Access 2000 freely available. Click on any of the linked lesson listings below to preview FREE!

Microsoft Access 2000 gives you powerful new tools for managing your 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.

Choose your media type:


QT To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.

Introduction
  Introduction (02:35)
  Design Basics (03:04)
  Example Databases (04:44)
  The 7 Access Objects (10:50)
  Relationships (03:44)
Access Basics
  Starting Access 2000 (07:10)
  Screen Tips (04:36)
  Keyboard Setup (01:06)
  Accessing Help (02:10)
  The Office Assistant (06:18)
  Setting Options (01:51)
Table Strcuture and Data Types
  The Structure of a Table (04:59)
  Data Types (08:58)
Field Properties
  Intro/Field Size (03:54)
  Format (03:20)
  Input Mask (02:03)
  Caption (01:04)
  Default Value (02:55)
  Validation Rule/Text (02:15)
  Required (01:10)
  Indexed (00:57)
  Primary Key (02:50)
Working with an Existing Database
  Open an Existing Database (03:05)
  Passwords (02:51)
  Relationships (02:00)
  Documenter (02:59)
Working in Datasheet View
  DATASHEET VIEW (01:16)
  Sort & Find (06:19)
  Filter by Selection (01:57)
  Filter by Form (05:00)
  Save a Filter (01:03)
  Navigating Data Sheets (05:53)
  Adjust Column Width (04:00)
  Freeze & Unfreeze (02:42)
  Appearance (03:58)
  Data Entry (06:53)
  Delete, Copy, Paste (05:54)
  Printing Datasheets (03:08)
  Selecting Records To Print (02:16)
Using Forms
  Introduction to Forms (05:05)
  Form Design Basics (03:11)
  Form Types (03:05)
  Form Views (04:42)
  Data Entry Using Forms (05:34)
  Printing Forms (02:59)
  Save & Close Forms (01:31)
  Pop-up & Modal Forms (03:22)
Using Queries
  Intro to Queries (01:43)
  Query Types (02:45)
  Query Views (04:50)
  Calculation Queries (02:29)
  Saving Queries (02:42)
Usign Reports
  Intro to Reports (03:42)
  Viewing a Report (05:02)
  Report Types (03:51)
  Printing a Report (03:13)
Create a New Database
  Database Structure (04:36)
  Create a Database (02:57)
Creating Tables
  Ways to Create a Table (01:39)
  Creating Fields (08:22)
  Setting Properties (06:25)
  Adding Fields (01:23)
  Setting a Primary Key (01:37)
  Lookup Wizard (04:04)
  Table Wizard (06:58)
  The Contacts Table (03:44)
Setting up Relationships
  Relationships - Why? (04:58)
  Prerequisites (01:10)
  The Relationships Window (07:51)
  Referential Integrity (06:40)
Creating Forms
  Create Forms Manually (09:21)
  Auto Forms (03:17)
  Form Wizard (03:23)
  Form Design Facilities (05:27)
  Form Controls Overview (03:29)
  Moving & Sizing Controls (05:42)
  Formatting Controls (05:21)
  Alignment (04:28)
  Add & Delete Controls (04:15)
  Changing Form Size (01:41)
  Headers & Footers (03:10)
  Create a Main and Sub-Form (12:22)
  Calculations (1) (04:04)
  Calculations (2) (14:03)
  Creating Command Buttons (06:57)
  Add a Combo Box (04:18)
Creating Queries
  Intro to Queries (02:45)
  New Query Options (02:17)
  Query Design View (03:03)
  Adding Fields to QBE Grid (04:51)
  Adding a Table (07:21)
  Running Queries (02:00)
  Sorting in a Query (03:09)
  Entering Criteria (05:33)
  Ranges in Criteria (02:30)
  Tips on Criteria (03:13)
  More Tips on Criteria (05:32)
  AND/OR (09:20)
  Calculated Fields (05:34)
  Saving Queries (02:52)
  Parameter Queries (04:04)
  Totals Queries (05:27)
  Expression Builder (02:31)
Creating Reports
  Intro to Reports (02:25)
  Creating Reports (04:50)
  Report Design View (04:49)
  Sorting & Grouping (12:40)
  Layout Problems (11:09)
  Mailing Labels (06:41)
  Adding Calculated Fields (07:13)
  Adding Group Totals (05:17)
  Adding Sum Totals (03:12)
Creating Data Access Pages
  Intro to Pages (05:53)
  Creating Pages (04:26)
  Use the Page Wizard (08:44)
  Accessing Data from the Web (04:59)
External Data
  Introduction (01:04)
  Importing Data (09:39)
  Importing from Excel (05:13)
  Mail Merging with Word (04:47)
  Linking & Attaching Tables (04:53)
Replication
  Replication Overview (01:49)
  Setting Up Replicas (05:10)
  Types of Security (03:36)
  User-Level Security Wizard (11:00)
  Backing Up Data (02:08)
Macros
  Introduction (03:54)
  Example Macro (03:36)
  Conditional Macros (07:32)
Switchboards
  Create a Switchboard (03:25)
  Add Buttons (01:40)
  Improve Appearance (03:57)

Title Information / Pricing

Title: Microsoft Access 2000
Author: Angie Rawling/NMG
SKU: 33106
ISBN: 1889347949
Release Date: 2000-05-01
Price:
Duration: 12 hrs / 132 lessons
Work Files: No
Captions: No
Compatibility: Vista/XP/2000, OS X, Linux
QuickTime 7

Online University Access all our Training for only 30

The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)


Select Bandwidth

Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection. The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

* Bandwidth selection only available for QuickTime versions of tutorials, not Flash.


Select:

Now Shipping

Autodesk Sketchbook Pro 6 for Desktop and iPad

Autodesk Sketchbook Pro 6 for Desktop and iPad

View the first three chapters of this tutorial FREE!


Client Testimonials

What a great product! I have purchased alot of training for 3DS Max and they don't even come close to yours. Your training cd taught me so much...

Danny Doyle