Access 2010 Foundation Courseware

Microsoft Access 2010 Foundation Training Materials

Courseware Training Materials

Download IT Courseware Samples

Training Course Outline

 Access 2010 Database Concepts

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

 Access 2010  | Opening a Database & Security Issues

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

 Access 2010 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

 Access 2010 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

 Access 2010 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  Access 2010 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

 Access 2010 Primary Keys and Indexing

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

Filtering in  Access 2010

  •     Text Filters
  •     Single Filter
  •     Multiple Filters

Sorting within  Access 2010

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

Searching in  Access 2010

  •     Searching Through Records

 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

 Access 2010 Forms

  •     Creating Forms
  •     Modifying Forms
  •     Saving a Form
  •     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

Download IT Courseware Samples