Getting Started
  • Working Files - Download These First
  • Overview Of Access 2010
  • 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