company catalog schedule discounts register contact
Logo (916) 333-5710
sacramento@academyx.com

Sacramento Branch

Register:

Related Classes:

Nearby:

Price: $450 for two days
Time: 9am - 4pm
Held at: 180 Promenade Circle #110
Sacramento, CA 95834
checkmark Onsite training available
checkmark 1-on-1 training available
Call us for details

Access 2007/2010 Intermediate - Sacramento

Microsoft Access is a powerful data management system with features for information tracking, reporting and collaborating. During this Microsoft Access 2007/Access 2010 Intermediate class in Sacramento, you will master advanced Access skills in authoring queries, building user-friendly forms and designing visually powerful reports. AcademyX's Microsoft Access classes have been designed to help you develop proficiency with both Access 2007 as well as Access 2010. With this in mind, you instructor will work closely with you to ensure that the skills you acquire are relevant to the way you do business, regardless of the version which your company uses. Upon completing this course, you will learn to:

  • Eliminate redundant data and organize data efficiently for improved database performance.
  • Maintain logical relationships between tables and fields with referential integrity.
  • Use subdatasheets and lookup columns to more efficiently display information from multiple tables.
  • Author advanced queries, including inner, outer and self-joins, to generate results from unrelated tables.
  • Use calculated fields to display mathematical or logical expression results.
  • Assist the user with visual cues, such as shapes, borders and graphics.
  • Validate data entered by the user with form controls and menus.
  • Display data in a form or datasheet by using PivotTables and PivotCharts.
  • And many more topics! See full outline for the Intermediate Access 2007/2010 class.

Access 2007/2010 Class Reviews:


"Great instructor, course and material."
- student, PG&E, Sacramento


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

Newsletter subscribers can win $100 credit!