Request a Quote or More Information on this Workshop >
WORKSHOP DESCRIPTION
Microsoft Access is a relational database designed to help your team track, manage, and report on large data sets. Whether you want to work with an inventory, track customer interactions, or build a repository of project data, this powerful application is up to the task! Our Microsoft Access training is designed to help your group build databases for a broad range of applications.
This hands-on course will teach you the important functions of this industry-leading software.
Other workshops on this topic: Microsoft Access – Introduction
WHO SHOULD ATTEND:
- Experienced Access users who work with sophisticated databases
YOU WILL LEARN:
- Understand the databases that will be used during the course.
- Enhance tables by creating lookups.
- Create various types of advanced queries.
- Create advanced forms by adding controls, subforms, calculations, and graphic images.
- Create advanced reports by adding controls, grouping, subforms, calculations, graphic images, and charts.
- Work with and create web-based objects.
COURSE OUTLINE
Database Overview
Database Overview
Enhancing Tables
Copying a Database Object, Lookup Fields, Creating a Lookup
Advanced Queries
Query Overview, The Query Wizard, Nested Queries, Query Joins, Make Table Queries, Append Queries, Summary Queries, Crosstab Queries
Advanced Forms
Form Design, Controls, Form Properties, Subforms, Advanced Calculations, Customizing Forms
Advanced Reports
Designing Reports, Sorting and Grouping, Layout Properties, Calculations, Subreports, Graphic Reports, Chart Wizard
Supplemental Topics: Working with Web Tools
Working with Web Pages, Hyperlinks
Summary and Evaluations
METHODOLOGY
- Live, instructor-led training with hands-on exercises
Participants are requested to bring their computers to the session. Laptops are also available to rent for an additional fee.