Microsoft Access 2010 Foundation Training Materials

Courseware Training Materials

Training Course Outline

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

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

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