Microsoft Access 2010 Training Video

expand all / collapse all

• 01. Getting Started

  • 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

• 02. 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)

• 03. 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

• 04. Queries

  • 0401 What Is A Query
  • 0402 Creating Saving And Running A New Query
  • 0403 CAREFUL Editing Data In A Query
  • 0404 Changing The Design Of A Query
  • 0405 Add Criteria To A Text Field To Filter Records
  • 0406 Filtering A Query On A Number Field
  • 0407 Using Date Filters In A Query
  • 0408 Boolean Fields In Querying
  • 0409 Adding Wildcards To Query Criteria
  • 0410 Retrieving Empty Values With A Query (NULL)
  • 0411 Selecting Using Different Criteria On The Same Field (OR)
  • 0412 Selecting Using Different Criteria On Different Fields (AND)
  • 0413 Sorting The Results Of A Query
  • 0414 Hiding Filtering Columns From A Query Result
  • 0415 Evaluating Calculations With Queries
  • 0416 Working Out The Current Age Of Contacts
  • 0417 Produce Totals Using An Access Query
  • 0418 Finding Duplicate Records With A Query

• 05. Forms

  • 0501 Creating A Form Using The Wizard
  • 0502 Column Or Tabular Forms - Which To Choose
  • 0503 Viewing And Editing Records Through A Form
  • 0504 Adding Records Through Forms And Associated Problems
  • 0505 Searching For Records In Forms
  • 0506 Deleting A Record In A Form
  • 0507 Sorting Records
  • 0508 Applying Filters Within Forms
  • 0509 Modifying The Design Of A Form
  • 0510 Adding Fields Not Currently Displayed
  • 0511 Aligning And Spacing Form Controls
  • 0512 Amending The Tab Order
  • 0513 Add Logos And Images
  • 0514 Adding Todays Date
  • 0515 Calculating Fields In Forms

• 06. Reports

  • 0601 Creating A Basic Report Using The Wizard
  • 0602 Grouped Reports Through The Wizard
  • 0603 Basing A Report On A Query
  • 0604 The Quick Report Tool
  • 0605 Editing The Layout Of A Wizard Generated Report
  • 0606 Printing Reports
  • 0607 Creating A PDF From A Report

• 07. Multiple Table Databases

  • 0701 How To Create A Multi Table Database
  • 0702 Creating Links Between Tables
  • 0703 What Is The Foreign Key
  • 0704 Removing Or Editing A Relationship
  • 0705 Referential Integrity
  • 0706 Viewing And Editing Data In A Sub Datasheet
  • 0707 Creating A Query That Extracts Data From More Than One Table At A Time
  • 0708 Create A Form Based On A Multi Table Query
  • 0709 Generating A Report Based On More Than One Table

• 08. Database Normalization

  • 0801 What Is Normalization
  • 0802 Normalizing The Sample Database

• 09. Advanced Tables

  • 0901 Importing Data Into Access From Excel
  • 0902 Importing Data Into Access From Access
  • 0903 Importing Data Into Access From Text Files
  • 0904 Converting An Access 2010 Database To A Previous Version
  • 0905 Making Use Of Lookups In Tables
  • 0906 Why Do I Need To Index Fields In Tables
  • 0907 Multiple Field Primary Keys
  • 0908 Printing The Relationship Diagram

• 10. Advanced Select Queries

  • 1001 Using More Than One Table To Feed A Query
  • 1002 Changing The Join Type Of Links In Queries
  • 1003 Watch Out For The Cartesian Join
  • 1004 Parameter Queries
  • 1005 Introducing The Crosstab Query

• 11. Action Queries

  • 1101 The Make Table Query
  • 1102 Use An Update Query To Change Data
  • 1103 Appending Records To A Table Using The Append Query
  • 1104 Removing Data Using The Delete Query

• 12. Advanced Forms

  • 1201 Creating A Form With A Sub Datasheet
  • 1202 Creating A Data Form With NO Wizard
  • 1203 Adding A Drop Box (Combo Box)
  • 1204 Special Use Of A Combo Box To Find Records
  • 1205 Creating A Blank Form For Use As A Menu
  • 1206 Adding Simple Action Buttons To A Form

• 13. Sub Forms

  • 1301 Use A Sub Form To Display Related Data On One Screen
  • 1302 Create A Sub Form And Add To The Main Form
  • 1303 Using The Tab Control To Group Information Or Sub Forms

• 14. Advanced Reports

  • 1401 Creating A Blank Report
  • 1402 Adding Sorting And Grouping
  • 1403 Adding New Fields To Carry Out Calculations

• 15. Sub Reports

  • 1501 What Is A Sub Report
  • 1502 Creating A Sub Report
  • 1503 Inserting Sub Reports Into Main Report

• 16. About The Author

  • 1601 About The Author

In this Microsoft Access 2010 training video, expert author Guy Vaccaro introduces you to the creation of Access databases and associated forms and reports.

Starting with the basics of the interface, this computer based training video takes you through the creation of a single table, field types and properties, creating an input form, report generation, and all the associated functions you would expect. As you move through the video tutorial, Guy covers some advanced features such as Crosstab Queries, importing data from various sources, Join queries, and much much more.

By the completion of this software training tutorial, you will be fully versed in the creation and use of Microsoft Access 2010 databases, and how to get data in and out of the databases. Extensive exercise files are included to allow you to work alongside the author as you learn.