Course

Microsoft Access Webinar Parts 1 and 2


More Information
Directions
Accommodations
Course Title: Microsoft Access Webinar Parts 1 and 2
Course ID: COMP 401-402
Status: OPEN
Date(s): July 24, 2017
December 29, 2017
Location: Online-Recorded Webinar

, XX
Instructor: Adam Wilbert
Tuition: $400
Add to CartClick to pay by credit card and download course files

Other Payment Methods Click to pay by Check or Purchase Order

 

Description:

**This course was presented as a live webinar in early 2016 in six 2-hour sessions. **

Purchase includes 10 files:

  • Audio/Video recording of six 2-hour sessions,
  • Two course workbooks,
  • Exercise packets for each part

After purchase, you will receive instructions regarding how to access files.

A well designed database can increase the efficiency and can eliminate errors in your data storage protocols. By reducing redundancy, and eliminating the potential for human error, you can ensure that your data remains consistent and valid, and always up to date.

Access databases provide more than just a place to store your data. By creating a custom application that is specifically tailored to your project, an Access database creates the foundation through which you will quickly enter information, and more importantly, quickly retrieve answers to your questions about the data and build reports outlining the results.

Part 1 is designed for participants who wish to gain beginning to intermediate skills in using Microsoft Access to build relational databases for collecting, organizing, and analyzing their environmental data. It is applicable to anyone that manages environmental resources, sets or responds to environmental policy, or needs to evaluate regulatory compliance. This comprehensive class uses Access 2010 to cover in-depth the use of Tables, Queries, Forms, Reports, and Macro objects through extensive hands-on exercises. These Access database subjects are taught using real-world environmental examples with actual field data. This class is recommended for anyone desiring a concentrated exposure to Access training in a powerful tsix-hour class.

Part 2 will build on the skills introduced in Part 1 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.

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

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: 1.20 CEUs

More Information

Course Topics

Part 1

- Database Design Principles
- Relational Database Concepts
- Importing and Exporting Data
- Creating Tables
- Using Datasheets
- Data Validation
- Defining Table Relationships
- Performing Simple Queries
- Customizing Forms
- Using Calculated Values
- Parameter Queries
- Using Action Queries
- Creating and Using Forms
- Creating and Using Reports
- Designing Simples Macros
- Database Security/Permissions

Part 2

  • 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

N/A

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:

N/A


Directions

  • From:

  • To:
  •   , XX

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: