MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Microsoft Access 2010 Tutorial - Learn At Your Own Pace

Course Summary

A practical Microsoft Access 2010 tutorial that allows you to learn at your own pace using hands-on lessons.

  • +

    Course Syllabus

    • Getting Started
      • Working Files - Download These First
      • Overview Of Access 2010
      • How to obtain your Certificate of Completion for this Infinite Skills course.
      • The New File Menu In Access 2010
      • Making The Most Of The Navigation Pane
      • Customize The Quick Access Toolbar
      • Enable Content Using A Trusted Location
      • Choose Between Tabbed Or Overlapping Windows
      • Using The Files Included With This Course
      • What Will I Be Able To Do At The End Of This Course
    • Database Theory And Design
      • What Constitutes A Database
      • The Components That Make Up A Database
      • Why Do We Need A Relational Database Like Access
      • Creating A Database Using The Database Wizards
      • Create A Database WITHOUT The Wizard (Recommended)
    • Tables
      • Designing Then Creating A Single Table Database
      • Using The Correct Data Types
      • Managing The Each Fields Properties
      • Adding Lookup Options To A Field
      • Adding An Input Mask To Safeguard Data Entry
      • Adding A Validation Rule To Safeguard Data Entry
      • The New Calculated Field In Access 2010
      • The Primary Key
      • Entering Data Into A Table
      • Sorting Data In A Table
      • Deleting Records From A Table
      • Editing Records In A Table
      • Finding Records In A Table
      • Find And Replace Field Values
      • Filtering Table Data
    • Queries
      • What Is A Query
      • Creating Saving And Running A New Query
      • CAREFUL Editing Data In A Query
      • Changing The Design Of A Query
      • Add Criteria To A Text Field To Filter Records
      • Filtering A Query On A Number Field
      • Using Date Filters In A Query
      • Boolean Fields In Querying
      • Adding Wildcards To Query Criteria
      • Retrieving Empty Values With A Query (NULL)
      • Selecting Using Different Criteria On The Same Field (OR)
      • Selecting Using Different Criteria On Different Fields (AND)
      • Sorting The Results Of A Query
      • Hiding Filtering Columns From A Query Result
      • Evaluating Calculations With Queries
      • Working Out The Current Age Of Contacts
      • Produce Totals Using An Access Query
      • Finding Duplicate Records With A Query
    • Forms
      • Creating A Form Using The Wizard
      • Column Or Tabular Forms - Which To Choose
      • Viewing And Editing Records Through A Form
      • Adding Records Through Forms And Associated Problems
      • Searching For Records In Forms
      • Deleting A Record In A Form
      • Sorting Records
      • Applying Filters Within Forms
      • Modifying The Design Of A Form
      • Adding Fields Not Currently Displayed
      • Aligning And Spacing Form Controls
      • Amending The Tab Order
      • Add Logos And Images
      • Adding Todays Date
      • Calculating Fields In Forms
    • Reports
      • Creating A Basic Report Using The Wizard
      • Grouped Reports Through The Wizard
      • Basing A Report On A Query
      • The Quick Report Tool
      • Editing The Layout Of A Wizard Generated Report
      • Printing Reports
      • Creating A PDF From A Report
    • Multiple Table Databases
      • How To Create A Multi Table Database
      • Creating Links Between Tables
      • What Is The Foreign Key
      • Removing Or Editing A Relationship
      • Referential Integrity
      • Viewing And Editing Data In A Sub Datasheet
      • Creating A Query That Extracts Data From More Than One Table At A Time
      • Create A Form Based On A Multi Table Query
      • Generating A Report Based On More Than One Table
    • Database Normalization
      • What Is Normalization
      • Normalizing The Sample Database
    • Advanced Tables
      • Importing Data Into Access From Excel
      • Importing Data Into Access From Access
      • Importing Data Into Access From Text Files
      • Converting An Access 2010 Database To A Previous Version
      • Making Use Of Lookups In Tables
      • Why Do I Need To Index Fields In Tables
      • Multiple Field Primary Keys
      • Printing The Relationship Diagram
    • Advanced Select Queries
      • Using More Than One Table To Feed A Query
      • Changing The Join Type Of Links In Queries
      • Watch Out For The Cartesian Join
      • Parameter Queries
      • Introducing The Crosstab Query
    • Action Queries
      • The Make Table Query
      • Use An Update Query To Change Data
      • Appending Records To A Table Using The Append Query
      • Removing Data Using The Delete Query
    • Advanced Forms
      • Creating A Form With A Sub Datasheet
      • Creating A Data Form With NO Wizard
      • Adding A Drop Box (Combo Box)
      • Special Use Of A Combo Box To Find Records
      • Creating A Blank Form For Use As A Menu
      • Adding Simple Action Buttons To A Form
    • Sub Forms
      • Use A Sub Form To Display Related Data On One Screen
      • Create A Sub Form And Add To The Main Form
      • Using The Tab Control To Group Information Or Sub Forms
    • Advanced Reports
      • Creating A Blank Report
      • Adding Sorting And Grouping
      • Adding New Fields To Carry Out Calculations
    • Sub Reports
      • What Is A Sub Report
      • Creating A Sub Report
      • Inserting Sub Reports Into Main Report

Course Fee:
USD 99

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top