Access databases are more than just data tables. An Access database includes a collection of objects that all work together to perform specific tasks quickly and efficiently. By building on the knowledge gained in part one of this course, we will create highly efficient customized workflows that can reduce complex data processing and reporting tasks down to a single click.

This is the second course in a 2-part series. In "Introduction To Building Environmental Databases With Microsoft Access (COMP-401)", students learn the basic elements of constructing queries, forms, macros and reports. In this recommended third day, you will build on those skills by creating end-user application examples that bring the newly learned elements together. Access analytic tools, PivotCharts, and PivotTables will be introduced, and an SQL primer will be included. This course is separate from COMP-401 so that students may take it at a later date if you do not have flexibility in their schedule, however we highly recommend that the two courses be taken together. COMP-402 is not meant to be taken as a stand-alone class without first taking COMP-401.

**Please bring a personal laptop with Access 2010 (Access 2007 acceptable) a pen or pencil and paper if you prefer not to write in your manual. If you are not able to provide a laptop with Office (various types acceptable, 2010 preferred) we can provide one at a fee. Please contact us at 425-270-3274 to make arrangements two weeks prior to course.

After completing this course, participants will be able to:

• Apply complex query functions to databases
• Create and design pivot charts and pivot tables
• Perform complex queries using multiple tables
• Create tools for forms and reports
• Build multi-step macros for automating tasks

Previous Events (click to view/hide)

Bennett, CO View details    June 12, 2014 - June 12, 2014   Anchorage, AK View details    April 10, 2014 - April 10, 2014   Sacramento, CA View details    November 21, 2013 - November 21, 2013   Austin, TX View details    October 24, 2013 - October 24, 2013   Aurora, CO View details    August 8, 2013 - August 8, 2013   Baton Rouge, LA View details    July 18, 2013 - July 18, 2013   Portland, OR View details    June 6, 2013 - June 6, 2013   Seattle, WA View details    April 11, 2013 - April 11, 2013   Sacramento, CA View details    February 13, 2013 - February 13, 2013   Helena, MT View details    October 25, 2012 - October 25, 2012   Honolulu, HI View details    September 27, 2012 - September 27, 2012   Atlanta, GA View details    September 13, 2012 - September 13, 2012   Portland, OR View details    August 9, 2012 - August 9, 2012   Albany, NY View details    July 19, 2012 - July 19, 2012   Austin, TX View details    May 24, 2012 - May 24, 2012   Anchorage, AK View details    April 12, 2012 - April 12, 2012   Seattle, WA View details    March 8, 2012 - March 8, 2012   Richmond, VA View details    February 23, 2012 - February 23, 2012   Sacramento, CA View details    January 26, 2012 - January 26, 2012