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 2010

Course Outlines
Level 1
1.0 Getting Started
1.1 Overview Of Access 2010
1.2 The New File Menu In Access 2010
1.3 Making The Most Of The Navigation Pane
1.4 Customize The Quick Access Toolbar
1.5 Enable Content Using A Trusted Location
1.6 Choose Between Tabbed Or Overlapping Windows
1.7 What Will I Be Able To Do At The End Of This Course
2.0 Database Theory And Design
2.1 What Constitutes A Database
2.2 The Components That Make Up A Database
2.3 Why Do We Need A Relational Database Like Access
2.4 Creating A Database Using The Database Wizards
2.5 Create A Database WITHOUT The Wizard (Recommended)
3.0 Tables
3.1 Designing Then Creating A Single Table Database
3.2 Using The Correct Data Types
3.3 Managing The Each Fields Properties
3.4 Adding Lookup Options To A Field
3.5 Adding An Input Mask To Safeguard Data Entry
3.6 Adding A Validation Rule To Safeguard Data Entry
3.7 The New Calculated Field In Access 2010
3.8 The Primary Key
3.9 Entering Data Into A Table
3.10 Sorting Data In A Table
3.11 Deleting Records From A Table
3.12 Editing Records In A Table
3.13 Finding Records In A Table
3.14 Find And Replace Field Values
3.15 Filtering Table Data
Level 2
1.0 Queries
1.1 What Is A Query
1.2 Creating Saving And Running A New Query
1.3 CAREFUL Editing Data In A Query
1.4 Changing The Design Of A Query
1.5 Add Criteria To A Text Field To Filter Records
1.6 Filtering A Query On A Number Field
1.7 Using Date Filters In A Query
1.8 Boolean Fields In Querying
1.9 Adding Wildcards To Query Criteria
1.10 Retrieving Empty Values With A Query (NULL)
1.11 Selecting Using Different Criteria On The Same Field (OR)
1.12 Selecting Using Different Criteria On Different Fields (AND)
1.13 Sorting The Results Of A Query
1.14 Hiding Filtering Columns From A Query Result
1.15 Evaluating Calculations With Queries
1.16 Working Out The Current Age Of Contacts
1.17 Produce Totals Using An Access Query
1.18 Finding Duplicate Records With A Query
2.0 Forms
2.1 Creating A Form Using The Wizard
2.2 Column Or Tabular Forms - Which To Choose
2.3 Viewing And Editing Records Through A Form
2.4 Adding Records Through Forms And Associated Problems
2.5 Searching For Records In Forms
2.6 Deleting A Record In A Form
2.7 Sorting Records
2.8 Applying Filters Within Forms
2.9 Modifying The Design Of A Form
2.10 Adding Fields Not Currently Displayed
2.11 Aligning And Spacing Form Controls
2.12 Amending The Tab Order
2.13 Add Logos And Images
2.14 Adding Todays Date
2.15 Calculating Fields In Forms
Level 3
1.0 Reports
1.1 Creating A Basic Report Using The Wizard
1.2 Grouped Reports Through The Wizard
1.3 Basing A Report On A Query
1.4 The Quick Report Tool
1.5 Editing The Layout Of A Wizard Generated Report
1.6 Printing Reports
1.7 Creating A PDF From A Report
2.0 Multiple Table Databases
2.1 How To Create A Multi Table Database
2.2 Creating Links Between Tables
2.3 What Is The Foreign Key
2.4 Removing Or Editing A Relationship
2.5 Referential Integrity
2.6 Viewing And Editing Data In A Sub Datasheet
2.7 Creating A Query That Extracts Data From More Than One Table At A Time
2.8 Create A Form Based On A Multi Table Query
2.9 Generating A Report Based On More Than One Table
3.0 Database Normalization
3.1 What Is Normalization
3.2 Normalizing The Sample Database
4.0 Advanced Tables
4.1 Importing Data Into Access From Excel
4.2 Importing Data Into Access From Access
4.3 Importing Data Into Access From Text Files
4.4 Converting An Access 2010 Database To A Previous Version
4.5 Making Use Of Lookups In Tables
4.6 Why Do I Need To Index Fields In Tables
4.7 Multiple Field Primary Keys
4.8 Printing The Relationship Diagram
Level 4
1.0 Advanced Select Queries
1.1 Using More Than One Table To Feed A Query
1.2 Changing The Join Type Of Links In Queries
1.3 Watch Out For The Cartesian Join
1.4 Parameter Queries
1.5 Introducing The Crosstab Query
2.0 Action Queries
2.1 The Make Table Query
2.2 Use An Update Query To Change Data
2.3 Appending Records To A Table Using The Append Query
2.4 Removing Data Using The Delete Query
3.0 Advanced Forms
3.1 Creating A Form With A Sub Datasheet
3.2 Creating A Data Form With NO Wizard
3.3 Adding A Drop Box (Combo Box)
3.4 Special Use Of A Combo Box To Find Records
3.5 Creating A Blank Form For Use As A Menu
3.6 Adding Simple Action Buttons To A Form
4.0 Sub Forms
4.1 Use A Sub Form To Display Related Data On One Screen
4.2 Create A Sub Form And Add To The Main Form
4.3 Using The Tab Control To Group Information Or Sub Forms
5.0 Advanced Reports
5.1 Creating A Blank Report
5.2 Adding Sorting And Grouping
5.3 Adding New Fields To Carry Out Calculations
6.0 Sub Reports
6.1 What Is A Sub Report
6.2 Creating A Sub Report
6.3 Inserting Sub Reports Into Main Report
7.0 About The Author
7.1 About The Author
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.