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 2003

Course Outlines
Level 1
Course Introduction
1.0 Introduction to Databases
1.1 Database Concepts
1.2 Tour of Access
Questions
2.0 Database Wizards
2.1 Building a Database
Questions
3.0 Creating Databases ~From Scratch
3.1 Using Table Wizards
3.2 Tables from Scratch
Questions
4.0 Datasheet View
4.1 Changing Records
Questions
5.0 Table Appearance
5.1 Cell Effects
5.2 Managing Appearance of Columns
Questions
6.0 Filtering Techniques
6.1 Sorting-Finding & Filtering
Questions
7.0 Query Essentials
7.1 Relationships
7.2 Query Wizard
7.3 Adding Criteria
7.4 Using Wildcards
Questions
Post Course Exam
Level 2
Level Introduction
1.0 Form Essentials
1.1 Using the Form Wizard
1.2 Creating Forms with AutoForm
Questions
2.0 Report Essentials
2.1 Using the Report Wizard
2.2 Exporting Reports
2.3 Using the Label Wizard
2.4 Getting Help
Questions
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 Indexed Fields Unicode & IME
3.8 Smart Tags
Questions
4.0 Creating a Lookup
4.1 Inserting a Field
4.2 Inserting a Lookup Field
4.3 Adding to the Lookup List
4.4 Limit to List
Questions
5.0 Importing & Exporting Data
5.1 Exporting to Excel
5.2 Importing from Databases
5.3 Importing Data from Excel
5.4 Linking Data from Excel
5.5 Creating a Shared Database
Questions
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
Questions
Post Course Exam
Level 3
Level Introduction
1.0 Advanced Query Techniques
1.1 Query Design Tips & Tricks
1.2 Using Parameter Queries
1.3 Multiple-Parameter Queries
1.4 Report Based on a Parameter Query
1.5 Setting Up Calculated Fields
1.6 Overview of the Expression Builder
1.7 Creating Summary Queries
Questions
2.0 Access & HTML
2.1 Creating & Using Hyperlinks
2.2 Publish Database to HTML Format
2.3 Data Access Page
Questions
3.0 Merging Access into Word
3.1 The Mail Merge Wizard
3.2 Running the Merge
Questions
4.0 Action Queries
4.1 Make Table Query
4.2 Running an Append Query
4.3 Running a Delete Query
4.4 Running an Update Query
4.5 Printing
Questions
5.0 Database Maintenance
5.1 Compact & Repair Utility
5.2 Using Backup & Restore
Questions
6.0 Advanced Form Design
6.1 Printing the Selected Record
6.2 Creating & Using Form Controls
6.3 Calculated Controls
Questions
7.0 Advanced Form Modification
7.1 Selecting Controls
7.2 Sizing & Moving Controls
7.3 Adding Fields
7.4 Saving & Viewing Forms
7.5 Adjust Tab Order
Questions
8.0 Advanced Report Design
8.1 Understanding Report Design
8.2 Modifying Controls
8.3 Adding Controls
8.4 Sorting & Grouping Report Data
8.5 Working with the Pagebreak Controls
Questions
Post Course Exam
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.