Corporate Training By Zack Academy - Microsoft Access Part 1 - Introduction to Building Environmental Databases
Why Should You Take This Microsoft Access Part 1 - Introduction to Building Environmental Databases Course?
This two day Microsoft Access Part 1 - Introduction to Building Environmental Databases course 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 two day class. For additional exposure, a recommended third day, "Creating Efficient Workflows and Custom Tools in Microsoft Access (COMP-402)" is also offered immediately following this course.
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.
After completing this course, participants will be able to:
- Understand concepts of database structure and design
- Create relationships between tables
- Import and export datasheets
- Perform simple queries on multiple tables
- Construct and customize forms for retrieving data
- Build 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.
Topics To Be Covered Include:
- 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
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. 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 1 - Introduction to Building Environmental Databases 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
