Course

Microsoft Access Part 2: Creating Efficient Workflows and Custom Tools


More Information
Directions
Accommodations
A course video is available. Click to watch.
(Course 2 of 2 in a series)
Course Title: Microsoft Access Part 2: Creating Efficient Workflows and Custom Tools
Course ID: COMP-402
Status: CLOSED
Date(s): June 6, 2013: 8:30am - 4:30pm
Location: The Mark Spencer Hotel

Portland, OR
Instructor: Adam Wilbert
Tuition: $350
Class is Closed

 

Description:

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

"It was good to hav this third day to finish the course...Adam does a very good job. [He] is very knowlegeable & patient. Great resource." A. Sturdevant, December 2013

"Instructor is extremely knowledgeable and explained software very well. It was very valuable that examples were specific to environmental data." Anonymous, December 2013

"Very useful, class was hands on. I feel like I learned a lot." B. Barry, December 2013

 

Intended Audience:

 

This course is beneficial for any professional who works with a large amount of data, and needs to improve their Access skills to be able to make the most of the power of the software. Past attendees include environmental managers, engineers, field staff, scientists, and government agency staff.

 

Continuing Education Units: 0.70 CEUs

More Information

Course Topics

  • Applied Query Functions
  • Form Controls
  • Customizing Controls
  • Building Reports from Calculated Queries
  • Working with Pivot Charts and Pivot Tables
  • Designing Macros
  • Creating Switchboard Forms

About the Instructor

Adam Wilbert

Adam Wilbert

Adam Wilbert is a cartographer and database consultant. He has developed Access databases for the National Park Service as well as database and GIS solutions for small businesses and non-profit organizations. In 2007 Adam founded CartoGaia, a freelance cartography firm that merges a passion for data with aesthetic design. CartoGaia produces data management solutions and high-end custom maps for land use agencies, non-profit organizations and recreational groups. He is also the author of "Access 2007: Queries in Depth" available in the Lynda.com online training library. When Adam's not working at the computer, he's out exploring the world through the lens of infrared photography.

What to Bring

A personal laptop with Access 2010 (Access 2007 acceptable). Please bring a pen or pencil, and notepad if you would like to take notes (you may also choose to take notes in your book). If you are not able to provide a laptop with Access we can provide one at a fee. Please contact us at 425-270-3274 to make arrangements.

Billing Information

In order to guarantee a space in a course, the tuition must be paid in full TWO WEEKS before the first day of the course by either check or credit card. State and government agencies paying with a purchase order are allowed payment under the two-week time frame if a copy of the purchase order is received by NWETC.

If You Need to Cancel

Cancellations*

  • With 31 or more days notice, we will offer a 100% refund or credit towards a future course. The credit is good for one year and may be applied to any course.
  • With 30-8 days notice, we will offer a course credit towards a future course. The credit is good for one year and may be applied to any course.
  • With fewer than 8 days notice, there is no course credit available


*Please note that attendee replacement is welcome at any time

Disability Accommodations

Disability Accommodations:

To request disability accommodations, please contact us at info@nwetc.org or (425) 270-3274 at least 30 days prior to the event.

 


Directions

  • From:

  • To:
  •   409 Southwest 11th Avenue Portland, OR 97205

Accommodations

 



*Reduced tuition available to employees of Native American tribes, nonprofits, and government agencies; students; and NAEP members.

If you have any trouble registering please call (425) 270-3274 ext 103
Please wait to receive a course confirmation email, roughly one month prior to the class, before making any travel arrangements. Please review what to bring!

 

*Follow NWETC on twitter, and "like" us on Facebook by clicking the icons: