MicroKnowledge Inc.
Contact | Driving Directions | Home
Current Course Calendar
Featured Micro-Sessions
Course Descriptions
Featured Micro-Sessions
Basic Skills
Business Programs
Business Skills
Databases
Desktop Publishing & Graphics
Internet and Communications
Operating Systems
Presentations
Programming
Report Writing
Spreadsheets
Web Page Design
Word Processing
Free Events
Register for a Class
Customized Training
Proprietary Technology Training
On Site Training
About On Site Training
MobileKnowledge
Consulting Services
Technical Writing
Employment Opportunities
About Us
Site Map
Create Profile
Request Information
Support
Download Course Training Files

Access 2007 Intermediate

Register for a class
Personalized training and consulting is available upon request.

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
  

Lesson 5: Advanced reports

  • Customized headers and footers
  • Adding calculated values
  • Subreports

Lesson 6: Charts

  • Charts in forms
  • Charts in reports

Lesson 7: PivotTables and PivotCharts

  • PivotTables
  • Modifying PivotTables
  • PivotCharts

Optional topics

  • Internet integration
  • Hyperlink fields
  • Working with Outlook 2007

 

21 British American Blvd. Latham, NY 12110   Phone: 518.786.1181   Fax: 518.786.6221

Valid XHTML 1.0 TransitionalValid CSS!

 

 

 

 

Dates:
December 11
8:30-4:30

February 6
8:30-4:30

Price:
$169 for open enrollment courses, when available.

Length: 8 Hours

Quick Links

Request information

Register for a class

Get follow-up support

Create a My MicroKnowledge profile

Get Directions