Office 2010 Training Materials – Access 2010 Foundation Courseware
Office 365 training resources from the Cheltenham Group Free SamplesMicrosoft 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
- Word 2010 Foundation
- Word 2010 Intermediate
- Word 2010 Advanced
- Excel 2010 Foundation
- Excel 2010 Intermediate
- Excel 2010 Advanced
- Access 2010 Foundation
- Access 2010 Intermediate
- Access 2010 Advanced
- Outlook 2010 Foundation
- PowerPoint 2010 Foundation
- PowerPoint 2010 Intermediate
- PowerPoint 2010 Advanced
- Project 2010 Foundation
- Windows 10 Foundation