United States Microsoft Access 2000 Tutorials
Online Contents For This Course
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!
Course 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.
Choose your media type:
|
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 FeedbackCourse Information
| Course: | Microsoft Access 2000 |
| Author: | Angie Rawling/NMG |
| SKU: | 33106 |
| ISBN: | 1889347949 |
| Release Date: | 2000-05-01 |
| Duration: | 12 hrs / 132 tutorials |
| Captions: | No |
Subscription / Purchase Information
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Sign up for a Free Trial
Full Access Members have full access to VTC.com’s entire library of video tutorials.
If you are already a member, please login here.