Corporate Training By Zack Academy - Microsoft Access Part 2 - Creating Efficient Workflows and Custom Tools
Why Should You Take This Microsoft Access Part 2 - Creating Efficient Workflows and Custom Tools course?
Microsoft Access Part 2 - Creating Efficient Workflows and Custom Tools 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.
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.
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
Prerequisites:
Completion of COMP-401: Introduction to Managing Environmental Data with Microsoft Access 2010.
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.
Topics To Be Covered Include:
- Applied Query Functions
- Form Controls
- Customizing Controls
- Building Reports from Calculated Queries
- Working with Pivot Charts and Pivot Tables
- Designing Macros
- Creating Switchboard Forms
What to Bring to Class: 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. Pen or pencil, and paper if you do not want to take notes in your manual. Drinks and snacks will be provided each day. Lunch will be on your own.
- Interactive training from an experienced instructor
- Course manual with workshop proceedings and reference material
- Microsoft Access Part 2 - Creating Efficient Workflows and Custom Tools course certificate
- Snacks and drinks provided
- Contact us and let us know how many employees need training.
- We will send a request for bid to our network of over 400 trainers.
- Sit back, relax, and within 24-48 hours you will have competitive pricing and a training date for this course.
Questions? 954-400-0595
