Microsoft Access 2000 Training
CD Contents For This Title

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:

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

Select Bandwidth
Now Shipping
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