- Applied Query Functions
- Form Controls
- Customizing Controls
- Building Reports from Calculated Queries
- Working with Pivot Charts and Pivot Tables
- Designing Macros
- Creating Switchboard Forms
More Information Directions Accommodations |
Other Payment Methods Click to pay by Check or Purchase Order | |||||||||||||||||
|
Description: Description: *This is a recording of a live webinar that took place in February 2016 in three 2-hour sessions.** The webinar was presented by Sustainable City Networks and NWETC. Purchase includes 5 files:
After purchase, you will receive instructions regarding how to access files. 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-WEBINAR (COMP-401W)", students learn the basic elements of constructing queries, forms, macros and reports. In this recommended follow up, 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. NOTE: COMP-402W is not meant to be taken as a stand-alone class without first taking COMP-401W. After completing this course, participants will be able to:
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.60 CEUs More InformationCourse Topics
About the InstructorAdam 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 BringAttendees should have a computer with an internet connection, and a headset or speakers are recommended. Further instructions will be provided after registration. 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 CancelCancellations*
*Please note that attendee replacement is welcome at any time Disability AccommodationsDisability Accommodations:To request disability accommodations, please contact us at info@nwetc.org or 425-270-3274 at least 30 days prior to the event. |
||||||||||||||||||
© 2024 NWETC. All rights reserved