Our technicians know that the best way for people to get the most out of their computers is to get the right training for the tools they use. Contact your Tech Hero today to find out how to get training on the most popular programs used today.
Microsoft Office Training
Microsoft Office Training
Microsoft Office is the most commonly used suite of programs used in the business world. Click on the links below for details on each of the programs available.
Click on the title below to view a list of course offerings
Microsoft Access
Microsoft Access
Outline:
- Lesson 1: Access 2003 Basics
Introducing Access 2003
Screen Layout
Create an Open Database
Help in Access 2003
- Lesson 2: Design a Database
Plan A Database
Define Relationships
Review the Design
- Lesson 3: Build a Database
Database Wizards
Create A Table
Work With Table Data
- Lesson 4: Modify A Table
Build A Relational Database
- Lesson 5: Access Forms
Create A Form Automatically
- Lesson 6: Sort, Retrieve & Analyze Data
Sort Data
Find Data
Use Filters
- Lesson 7: Use Queries
What Is A Query?
Create A Select Query
Add A Calculated Field To A Query
- Lesson 8: Access Reports
Create Reports Automatically
- Lesson 9: Import Data Into Access
Link To External Data
Export Data From Access
- Lesson 10: Customize Access 2003
Advanced Features & Customizations
Customizing Access 2003
Customize Menus
Creating Custom Menus
- Lesson 11: Build & Work With Databases
Build A Relational Database
Control Data Entry In Tables
Create Lookup Fields
Import & Export Access Data
Link To External Data
Import & Export XML Files
- Lesson 12: Work With Forms
Create Forms In Design View
Create A Calculated Control
Modify Control Properties
Use Subforms
- Lesson 13: Work With Filters & Queries
Retrieve Database Data
Filter Data
Use Select Queries
Use Multi-Table Queries
Use Complex-Criteria Queries
Use Parameter Queries
Use Action Queries
- Lesson 14: Work With Reports
Create Reports In Design View
Modify Reports
Sort & Regroup Data
Use Subreports
- Lesson 15: Manage an Access Database
Database Security
Database Replication
Database Splitter
Visual Basic Modules
Optimize A Database
Switchboard & Startup Options
- Lesson 16: Operate Access on the Web
Use Data Access Pages
Use PivotTables & PivotCharts