Title Language  : 

Find a Course... Try for Free!

 

Microsoft Access 2000 Tutorials

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

лл Hide This
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)

Email this Page     Send us Feedback
Tutorial Information / Pricing
Title: Microsoft Access 2000
Author: Angie Rawling/NMG
SKU: 33106
ISBN: 1889347949
Duration: 12 hrs / 132 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

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)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

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 (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products