Microsoft Word 2007 Courseware
Microsoft Access 2007 Full Day Courseware Titles
Click a title to move down the page.
- Access 2007 Level 1:
A Beginner's Guide to Microsoft Access - Access 2007 Level 2:
An In-Depth Look at Reports, Queries, and Tables in Microsoft Access - Access 2007 Level 3:
Advanced Database Concepts in Microsoft Access
Stand-alone 90-minute Microsoft Word 2007 workshops/modules
- Coming Soon
Microsoft Access 2007 Level 1:
A Beginner's Guide to Microsoft Access
Microsoft Access 2007 Level 1: A Beginner's Guide to Microsoft Access introduces database concepts and functionality to the beginner.
Course Objectives:
- Navigate the Access 2007 Interface
- Create a new database
- Identify the components of a relational database
- Create tables, queries, reports, and forms
- Modify tables, queries, reports, and forms
- Sort, find, and filter data
Cost: $19.95
Microsoft Access 2007 Level 2:
An In-Depth Look at Reports, Queries, and Tables in Microsoft Access
Microsoft Access 2007 Level 2: An In-Depth Look at Reports, Queries, and Tables in Microsoft Access offers further skills in working with the major Access database objects. Understanding how table relationships work is covered in order to work with database objects at this level.
Course Objectives:
- Understand and create table relationships
- Enforce table referential integrity
- Modify table field properties
- Import and export data
- Create and use lookup and value lists
- Create multi-table queries
- Use the expression builder to create calculations in queries
- Customize reports
- Add calculated controls to reports
Cost: $19.95
Access Level 3:
Advanced Database Concepts in Microsoft Access
Access Level 3: Advanced Database Concepts in Microsoft Access takes users through advanced features and capabilities of Access. In particular, advanced formulas, queries, and forms & reports allow for your database to behave more like a custom application.
Course Objectives:
- Integrating with Microsoft Office Word and Excel
- Customizing Field Properties
- Understanding Join Properties
- Working with Action Queries
- Aggregating Formulas in Queries
- Applying Functions in Queries
- Creating Subreports in Main Reports
- Creating Grouped Reports
- Adding Functions and Formula Text Boxes in a Report
- Working with Forms and Subforms
- Passing Values between Subforms and Main Forms
- Creating Switchboards to Navigate in a Database
Cost: $19.95
