| Overview: This one day course teaches participants the skills necessary to save time by controlling data entry and automating tasks using Access' advanced features that enable you to customize tables, forms, lookups and reports.
Duration: 1 day
Fee: $350 per person
Upcoming Dates:
Mar. 6, May 6
Prerequisite: Microsoft Access: An Introduction - Database Design
Delivery: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities and assignments.
Materials: Participants receive reference materials related to course topics. Sample files used in class are available by email, or on disk. Follow up support by email or phone, on topics covered, is available to participants for 90 days.
|
|
Course Content::
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
- Data Access Pages
- Hyperlinks
|
|
Objectives: Upon successful completion attendees will be able to:
- Overview of 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 relationships between tables to ensure data accuracy and to deploy referential integrity.
- Work with and create web-based objects.
|
