Microsoft Office Training Materials – Access 2010 Foundation Training Manuals
Microsoft Office 365 Training Materials, plus Office 2013 & Windows 10 Manuals Free SamplesMicrosoft 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
Other Microsoft Office Training Materials
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