Microsoft Office Training Materials – Access 2010 Foundation Training Manuals

Microsoft Access 2010 Foundation Training Materials

Courseware Training Materials

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