Have you unlocked your potential?
Satisfaction Guaranteed.
Here at LearnLocker, we are committed to providing the best possible experience we can. If at any time you are not completely satisfied, we invite you to contact us with your comments and feedback. In addition, you have the right to cancel your membership at anytime. You can even cancel online through our website. Our cancellation policy and terms are covered in detail in the terms and conditions found in the LearnLocker Subscription Membership Agreement.

Access 2000

Instructor: Dennis Taylor
Dennis P. Taylor has spent over 14 years presenting PC software training to individuals in classrooms and seminars, including employees at Amoco, IBM, and many other companies. He specializes in spreadsheet software and has co-authored several books for spreadsheets. Five years ago, he turned his attention to Excel spreadsheets and has become an Excel training specialist. Dennis brings a combination of in-depth knowledge and training experience to this course. Watch and Learn in minutes with Dennis.
Course Outlines
Level 1
1.0 Introduction
1.1 Basic Concepts
1.2 Overview of Access
1.3 Tables
1.4 Forms
1.5 Queries
1.6 Reports
1.7 Section Summary
2.0 Creating a Database
2.1 The Database Wizard
2.2 Create a Blank Database
2.3 Creating a Table Using the Wizard
2.4 Creating a Table in the Design View
2.5 Creating a Table with Data Entry
2.6 Creating a Table by Importing Data
2.7 Section Summary
3.0 Table Utilities
3.1 Editing Table Data
3.2 Adding & Deleting Records
3.3 Adding & Deleting Fields
3.4 Printing a Table
3.5 Section Summary
4.0 Table Appearance
4.1 Column Widths and Row Heights
4.2 Hiding, Freezing, and Moving Columns
4.3 Fonts and Colors
4.4 Section Summary
5.0 Table Data Features
5.1 Working with Fields in Design View
5.2 Finding & Replacing Data
5.3 Sorting Data
5.4 Filtering Data
5.5 Section Summary
6.0 Query Essentials
6.1 Creating a Simple Query
6.2 Setting Criteria
6.3 Wildcards
Level 2
1.0 Form Essentials
1.1 Using the Form Wizard
1.2 Creating Forms with AutoForm
1.3 Section Summary
2.0 Report Essentials
2.1 Using the Report Wizard
2.2 Exporting Reports
2.3 Using the Label Wizard
2.4 Section Summary
3.0 Field Properties
3.1 Field Size
3.2 Date & Time
3.3 Custom Formats
3.4 Yes & No Fields
3.5 Default Value & Expression Builder
3.6 Validation Rule
3.7 Section Summary
4.0 Creating a Lookup
4.1 Creating a Lookup Field
4.2 Limit to List
4.3 Section Summary
5.0 Importing & Exporting Data
5.1 Importing/Exporting
5.2 Linking Data from Excel
5.3 Section Summary
6.0 Relationships
6.1 Relationship Concepts
6.2 Creating Table Relationships
6.3 Enforcing Referential Integrity
6.4 Understanding Cascade Options
6.5 Printing Database Information
Level 3
1.0 Advanced Query Techniques
1.1 Using Parameter Queries
1.2 Reports Based on Parameter Queries
1.3 Setting up Calculated Fields
1.4 Overview of the Expression Builder
1.5 Creating Summary Queries
1.6 Section Summary
2.0 Access & HTML
2.1 Creating & Using Hyperlinks
2.2 Publishing Database to HTML Format
2.3 Data Access Pages
2.4 Section Summary
3.0 Action Queries
3.1 Making a Table Query
3.2 Running an Append Query
3.3 Running a Delete Query
3.4 Running an Update Query
3.5 Section Summary
4.0 Database Maintenance
4.1 Using Compact & Repair Utility
4.2 Database Backup
4.3 Section Summary
5.0 Advanced Form Design
5.1 Creating & Using Form Controls
5.2 Calculated Controls
5.3 Section Summary
6.0 Advanced Form Modification
6.1 Manipulating Form Controls
6.2 Adding Fields
6.3 Adjusting Tab Order
6.4 Section Summary
7.0 Advanced Report Design
7.1 Understanding the Report Design
7.2 Modifying Controls
7.3 Adding Controls
7.4 Sorting and Grouping Report Data
7.5 Working with the Pagebreak Control
Reset Password
Sign In:


You will be sent a link to the Reset Password page. Please note that the link may only be used today.