Office 2010 Training Materials – Access 2010 Foundation Courseware

Office 365 training resources from the Cheltenham Group
Free Samples

Microsoft Access 2010 Foundation Training Course Teaching Materials

Computer Courseware Training Materials

Training Course Outline

Microsoft Access 2010 Database Concepts

  • Database
  • Relational Database
  • Table
  • Record (Row)
  • Field (Column)
  • Data Types

Opening a Database & Security Issues

  • Opening a Database
  • Trusted Locations
  • Setting the Default Folder Location
  • Closing the Access Program

Tables, Fields and Field Types

  • Creating a New Blank Database
  • Adding Fields and Setting the Field Type
  • About Access Data Types
  • Closing and Naming a Table

Table Navigation & Modification

  • Opening a Table within a Database
  • ‘Datasheet View’ vs. ‘Design View’
  • Adding Records to a Table
  • Navigating Through Records
  • Adjusting Column Width
  • Automatically Resizing a Column Widths
  • Rearranging the Column Order

Field Properties

  • Field Properties
  • Input Masks
  • Validating Numbers
  • Validating Dates
  • Data Entry Required / Not Required
  • Field Properties – Reference Materials
  • Field Properties – Logical Operators
  • Field Properties – General
  • Field Properties – Format
  • Field Properties – Input Mask Characters

Manipulating Tables & Records

  • Renaming a Table
  • Editing Data within a Record
  • Deleting Data within a Record
  • Using the Undo Command
  • Deleting a Single Record
  • Deleting Multiple Records
  • Deleting a Table

Primary Keys and Indexing

  • Defining a Primary Key
  • Indexing
  • Creating a Single-Field Index
  • Creating a Multiple-Field Index
  • Deleting Multi-Field Indexes

Filtering

  • Text Filters
  • Single Filter
  • Multiple Filters

Sorting

  • Sorting Records
  • Removing a Sort
  • Sorting on Multiple Fields

Searching

  • Searching Through Records in Access 2010

Access 2010 Relationships

  • One-To-Many Relationship
  • Many-To-Many Relationship
  • One-To-One Relationships
  • Creating Relationships between Tables
  • Referential Integrity
  • Cascade Options
  • Cascade Update Related Fields
  • Cascade Delete Related Records
  • Enabling Cascade Options
  • Deleting Relationships

Microsoft Access 2010 Forms

  • Creating Forms in Access 2010
  • Modifying Forms
  • Saving a Form
  • Access 2010 Form View
  • Adding and Formatting Attachments
  • Modifying Data within Records
  • Deleting Records using a Form
  • Adding Records using a Form
  • Closing Forms
  • Deleting a Form
  • Filtering a Form
  • Removing a Filter from a Form
  • Inserting and Modifying a Form Header
  • Inserting and Modifying a Form Footer