United States Microsoft Access 97 Tutorials
Online Contents For This Course
We have made some of the video tutorials for
Microsoft Access 97
freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
Course Description
To get started, simply click one of the topics below.
Choose your media type:
|
Introduction
|
|||
| Introduction | (02:22) | ||
| Design Basics | (00:53) | ||
| Example Databases | (03:01) | ||
| The 6 Access Objects | (02:00) | ||
| One to Many Relationships | (03:28) | ||
|
Access Basics
|
|||
| Starting Access97 | (05:05) | ||
| Screen Tips | (00:49) | ||
| Keyboard Setup | (00:55) | ||
| Accessing Help | (01:29) | ||
| Help Menu | (04:58) | ||
| The Office Assistant | (01:07) | ||
| Setting Option | (00:39) | ||
|
Table Structure & Data Types
|
|||
| The Structure of a Table | (01:38) | ||
| Data Types | (07:06) | ||
|
Field Properties
|
|||
| Intro/Field Size | (03:15) | ||
| Format | (01:08) | ||
| Input Mask | (02:45) | ||
| Caption | (00:31) | ||
| Default Value | (00:41) | ||
| Validation Rule/Text | (01:58) | ||
| Required | (00:35) | ||
| Indexed | (00:57) | ||
| Primary KeY | (01:37) | ||
|
Working with an Existing DB
|
|||
| Open an Existing Database | (01:12) | ||
| Passwords | (02:47) | ||
| Relationships | (01:32) | ||
| Documenter | (02:23) | ||
|
Working in DataSheet View
|
|||
| DataSheet View | (01:35) | ||
| Sort & Find | (02:41) | ||
| Filter by Selection | (03:14) | ||
| Filter by Form | (05:47) | ||
| Saving a Filter | (01:51) | ||
| Navigating DataSheets | (02:33) | ||
| Adjust Column Width | (03:06) | ||
| Freeze/Unfreeze | (03:16) | ||
| Appearance | (03:35) | ||
| Data Entry | (11:22) | ||
| Delete, Copy, Paste | (05:14) | ||
| Printing DataSheets | (05:06) | ||
| Save & Close DataSheets | (00:48) | ||
|
Using Forms
|
|||
| Introduction to Forms | (04:01) | ||
| Form Design Basics | (02:22) | ||
| Form Types | (01:10) | ||
| Form Views | (02:07) | ||
| Data Entry using Forms | (03:09) | ||
| Printing Forms | (01:15) | ||
| Save and Close Forms | (00:38) | ||
| Pop-up and Modal Forms | (04:25) | ||
|
Using Queries
|
|||
| Introduction to Queries | (01:03) | ||
| Query Types | (04:50) | ||
| Query DataSheet View | (01:45) | ||
| Query Design View | (04:58) | ||
| SQL View | (01:04) | ||
| Saving Queries | (02:14) | ||
|
Using Reports
|
|||
| Introduction to Reports | (02:38) | ||
| Viewing a Report | (02:13) | ||
| Report Types | (03:31) | ||
| Printing Reports | (00:58) | ||
|
Create a New Database
|
|||
| Database Structure | (04:01) | ||
| Create a Database | (02:16) | ||
|
Creating Tables
|
|||
| Ways to Create a Table | (02:14) | ||
| Creating Fields | (06:21) | ||
| Setting Properties | (05:23) | ||
| Adding Fields | (01:40) | ||
| Setting a Primary Key | (02:59) | ||
| Lookup Wizard | (05:42) | ||
| Table Wizard | (04:46) | ||
| The Contacts Table | (05:28) | ||
|
Setting up Relationships
|
|||
| Relationship - Why? | (01:12) | ||
| Prerequisites | (01:52) | ||
| The Relationships Window | (04:37) | ||
| Referential Integrity | (01:02) | ||
|
Creating Forms
|
|||
| Create Forms Manually | (02:23) | ||
| Autoforms | (02:12) | ||
| Forms Wizards | (02:50) | ||
| Form Design Facilities | (03:44) | ||
| Controls Overview | (01:17) | ||
| Moving & Sizing Controls | (05:23) | ||
| Formatting Controls | (04:16) | ||
| Alignment | (02:09) | ||
| Add & Delete Controls | (05:29) | ||
| Changing Form Size | (01:37) | ||
| Headers & Footers | (01:29) | ||
| Calculations (1) | (03:04) | ||
| Calculations (2) | (07:41) | ||
| Calculations(3) | (01:36) | ||
| Creating Command Buttons | (05:03) | ||
| Add a Combo-box | (06:13) | ||
| Create a Main & SubForm | (08:51) | ||
|
Creating Queries
|
|||
| Introduction to Queries | (02:06) | ||
| New Query Options | (01:29) | ||
| Query Design View | (04:45) | ||
| Adding fields to QBE grid | (03:04) | ||
| Adding a Table | (02:07) | ||
| Running Queries | (01:08) | ||
| Sorting in a Query | (03:15) | ||
| Entering Criteria | (03:56) | ||
| Ranges in Criteria | (04:31) | ||
| Tips on Criteria | (08:32) | ||
| More Tips on Criteria | (06:40) | ||
| And/Or | (06:40) | ||
| Calculated Fields | (05:29) | ||
| Names & Numbers Query | (02:56) | ||
| Saving Queries | (02:46) | ||
| Parameter Queries | (09:12) | ||
| Totals Queries | (06:42) | ||
| Expression Builder | (05:13) | ||
|
Creating Reports
|
|||
| Introduction to Reports | (02:44) | ||
| Creating Reports | (03:17) | ||
| Report Design View | (04:03) | ||
| Sorting & Grouping | (09:47) | ||
| More Sorting and Grouping | (10:26) | ||
| Layout Problems | (09:44) | ||
| Layout Problems, continued | (10:08) | ||
| Mailing Labels | (06:10) | ||
| Adding Calculated Fields | (05:49) | ||
| Adding Group Totals | (06:32) | ||
| Adding Sum Totals | (02:58) | ||
|
External Data
|
|||
| Introduction | (01:03) | ||
| Importing Data | (06:13) | ||
| Importing from Excel | (02:39) | ||
| Mailmerging with Word | (03:14) | ||
| Linking/Attaching Tables | (02:17) | ||
|
Replication
|
|||
| Replication Introduction | (01:16) | ||
| Replication Help | (00:57) | ||
| Considerations | (01:27) | ||
|
Security/Backing Up
|
|||
| Security Introduction | (00:41) | ||
| Further Information | (01:28) | ||
| Everything about backing up | (00:51) | ||
|
Macros
|
|||
| Macro Introduction | (01:08) | ||
| Example Macro | (05:36) | ||
| Conditional Macros | (01:36) | ||
|
Publish on the Web
|
|||
| Introduction | (01:02) | ||
| The Web Wizard | (05:27) | ||
| View the Web Page | (02:22) | ||
|
Switchboards
|
|||
| Create a Switchboard | (03:10) | ||
| Add Buttons | (01:10) | ||
| Improve Appearance | (03:15) | ||
Email this Page 
Send us FeedbackCourse Information
| Course: | Microsoft Access 97 |
| Author: | John Baddeley |
| SKU: | 33042 |
| ISBN: | 1889347396 |
| Release Date: | 1998-04-02 |
| Duration: | 8 hrs / 138 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.