Microsoft Access is found at organizations of all sizes, across industries, both in the public and private sector. Still, skilled Access database designers are in short supply. Upon completing AcademyX's Intermediate Microsoft Access class in San Francisco, you will have developed extensive skill with this powerful data management system, and its full array of utilities for information tracking, reporting and collaborating with others. AcademyX's Microsoft Access classes have been designed to help you develop proficiency with both Access 2007 as well as Access 2010. With this approach in mind, your instructor will share a broad base of real-world examples applicable to both versions, so that you will leave with practical knowledge you can apply right away, including how to:

Designate relationships between fields in related tables.
Boost database speed and performance by "normalizing" the data.
Use referential integrity to maintain logical relationships between tables and fields.
Display information from multiple tables efficiently with subdatasheets and lookup columns.
Link related data tables with complex queries, such as inner, outer and self-joins
Incorporate calculated fields to display the results of a mathematical or logical expression applied to your data.
Provide visual cues, such as shapes and borders which group related controls, to assist the user.
Assist the user in entering appropriate data by using form controls and menus.
Use PivotTables and PivotCharts as a means of displaying data within a datasheet or form.
And many more topics! See full outline for Intermediate Access 2007/2010 class.

Intermediate Access 2007/2010 Class Reviews:

"Very good presentation of material; knowledgeable instructor."
- student, San Francisco

"Great class. [The instructor] is a good teacher."
- student, Brown & Toland Physicians

"Great class! I enjoyed it. My head is full."
- student, UCOP, San Francisco

* Note: This class description is for intermediate Access classes in San Francisco. We also offer intermediate training for Access 2007/2010 in Los Angeles, San Jose, and Access 2007/2010 in Sacramento. Go to Access 2003 training in San Francisco.

Newsletter subscribers can win $100 credit!