Microsoft Access 2010: Class 2
| Duration: | 1 day |
| Prerequisite: | Microsoft Access 2010: Class 2 or equivalent experience |
| Course Materials: | Course book with exercises files |
| Prices per day: | $225 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | Now that you know how to create queries, reports, and forms, you will learn how to create advanced reports and forms, and analyze data with crosstab queries and pivot tables. You will also learn how to forms that will help you navigate your database. This 3-day course can be easily customized to just include the topics you want or need to learn. |
Analyzing Data with Crosstab Queries
- Understanding Crosstab Queries
- Creating a Crosstab Query with the Wizard
- Creating a Crosstab Query from Scratch
-
Pivot Tables
- Building a Pivot Table
- Manipulating a Pivot Table
- Creating a Calculated Field
- Hiding and Showing Details
- Filtering Pivot Tables
Designing Advanced Reports
- Improving Reports in Design View
- The Design View Sections
- Understanding Controls
- Moving Fields Out of a Layout
- Adding More Controls
- Creating a Report from Scratch
- The Report Wizard
- Fine-Tuning Reports with Properties
- Expressions
- Grouping
Designing Advanced Forms
- Customizing Forms in Design View
- Form Sections
- Adding Controls to Your Form
- The Control Gallery: A Quick Tour
- Arranging Controls on Your Form
- Anchoring: Automatically Resizing Controls
- Tab Order: Making Keyboard Navigation Easier
- Taking Control of Controls
- Locking Down Fields
- Prevent Errors with Validation
- Performing Calculations with Expressions
- Organizing with Tab Controls
- Going Places with Links
- Showing Web Pages with the Web Browser
- Navigating with Lists
- Performing Actions with Command Buttons
- Tables Relationships and Simple Forms
- The Subform Control
- Creating Customized Subforms
Building a Navigation System
- Configuring the Navigation List
- Better Filtering
- Hiding Objects
- Using Custom Groups
- Searching the Navigation List
- Building Forms with Navigation Smarts
- Custom Menu Forms
- Designating a Startup Form
- Compound Forms
- Showing All Your Forms in a List
- Creating a Single-Level Navigation Form
- Creating a Two-Level Navigation Form
- Fine-Tuning Your Navigation Buttons
- Showing Linked Records in Separate Form
- Showing More Detailed Reports with Links