A New York State Certified Woman-Owned Business Enterprise
BEAHIVE Training in Downtown Albany!
MicroKnowledge, Inc.
21 British American Blvd.
Latham, NY 12110
Phone: 518.786.1181
Fax: 518.786.6221
Access 2007 Intermediate Essentials
Description:
This course is designed to develop skills in Access that are essential for creating, maintaining, and using a database. Learn to define relationships, write complex queries, insert charts and PivotTables, and enhance forms and reports.
This course is appropriate for individuals who are familiar with the basics of Access and are seeking to increase their understanding or quickly fill in gaps in knowledge.
The course provides similar content to that included in Access 2007 Intermediate Comprehensive, with participants in this course prefering an overview of topics over a shorter time period. This course may also be more suitable for those who do not need to create their own database from scratch.
Includes:
Microsoft Office Specialist (MOS) approved courseware
Downloadable CertBlaster© MOS Exam Preparation software
Access to participant data files
Follow-up support by email or phone for an unlimited period
Lesson 1: Relational databases
- Database normalization
- Relating tables
- Implementing referential integrity
Lesson 2: Related tables
- Lookup fields
- Modifying Lookup fields
- Subdatasheets
Lesson 3: Complex queries
- Joining tables in queries
- Calculated fields
- Summarizing and grouping values
Lesson 4: Advanced form design
- Adding unbound controls
- Adding graphics
- Adding calculated values
- Adding combo boxes
- Advanced form types
Lesson 5: Advanced reports
- Customized headers and footers
- Adding calculated values
- Subreports
- Labels
Lesson 6: Charts
- Charts in forms
- Charts in reports
Lesson 7: PivotTables and PivotCharts
- PivotTables
- Modifying PivotTables
- PivotCharts
- PivotTable forms
