Access Advanced Training - San Francisco

Our Access Advanced training in San Francisco will introduce you to advanced functionality within Microsoft Access databases, including basic SQL scripting commands, crosstab queries and query parameters, creating and utilizing custom macros, import/export functions, and database optimization. Upon completion of this class, you will be able to:

  • Write simple SQL statements to create queries and subqueries, and easily assign aliases
  • Attach SQL-specific inquiries to a command button to initiate an action or set of actions
  • Create crosstab queries to efficiently summarize grouped data and define precise query parameters
  • Automate tasks by creating custom macros and attach those macros to events of database objects
  • Create powerful macros for data validation, data entry, parameter queries, import/export and many other tasks
  • Import/Export data and objects from/to other Access databases, Excel, CSV files and XML documents
  • Link objects across databases, and create/modify hyperlink fields
  • Optimize resources and define properties with database utilities
  • Secure your database with high-level encryption and password protection
  • See full outline for Access Advanced training

Access Advanced Course Reviews:

Rated 4.7/5 based on 64 student reviews.

"Very informative while at the same precise to cover a wide range of material. I learned a lot of little short cuts and a foundation of skills that I can expand upon in my everyday work."
- , U.S. Department of Education

"Great class, [the trainer] was very adept in Access and showed us lots of tricks and helped us understand some of the more esoteric features."
- , Williams-Sonoma Inc.

The class was good and the teacher was very available for everyone and answered all the questions.
- , Diestel Turkey Ranch, Sonora

Extremely knowledgeable instructor and informative class.
- , EVault , SF

Very well organized training. Will help me out tremendously with what I need to do.
- , San Mateo

Great instructor with a great deal of insight. Very helpful!!!
- , Lumetra Healthcare Solutions, San Francisco

It was great. Learned a lot. instructor was very attentive to all the questions we had.
- , intel, San Jose

► More reviews...

* Note: This course description is for our Access Advanced course in San Francisco. We also offer Access courses in Sacramento, Los Angeles, and San Jose.