Microsoft Access 2000 Tutorials
Online Contents For This Title
We have made some of the video tutorials for Microsoft Access 2000 freely available to help you evaluate our training.
Click on any of the linked lesson listings below to preview FREE!
Title Description
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.
|
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) | ||
This title is just part of the entire VTC collection of over 625 courses, 66,000 video tutorials (12,500+ free), available to you for just $30 a month.
Tutorial Information
| Title: | Microsoft Access 2000 |
| Author: | Angie Rawling/NMG |
| SKU: | 33106 |
| ISBN: | 1889347949 |
| Release Date: | 2000-05-01 |
| Duration: | 12 hrs / 132 lessons |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
Subscription / Purchase Information
This title is just part of the entire VTC collection of over 625 courses, 65,000 video tutorials (12,500+ free), available to you for just $30 a month.
Select Bandwidth
Now Shipping
Client Testimonials
Excellent course material with clear cut working examples to understand the concepts thouroghly.
Jamuna
United States
View All Titles 
Email this Page
Send us Feedback
Purchase/Add to Cart