Overview
Students will learn to perform complex queries, create more efficient forms and reports, and create macros. Students should be able to work with Access at an intermediate level and be comfortable with Access terminology.
Prerequisites
To ensure students’ success with this course, we recommend that they first take the following Content courses or have equivalent knowledge:
- Access 97: Level 1 (Windows 95)
- Access 97: Level 2 (Windows 95)
Performance-Based Objectives
- Make select queries more versatile by using parameters; and use action queries
to update data values and add or delete records.
- Refine the information derived from queries by creating outer joins and using
crosstab queries.
- Enhance form design by manipulating control object properties.
- Automate simple tasks by creating macros to open forms and control form properties.
- Make forms more functional and automate tasks by creating macros.
- Enhance the design of reports by hiding repetitive data, grouping data on prefix
values, and using functions in controls.
- Use Access to create links to Internet sites, and to save data as HTML documents.
Delivery Method:
This course is designed for instructor-led, group paced classroom-delivery, providing students with structured hands-on activities.
Course duration
1 Day(s)
Course outline
Lesson 1: Designing parameter and action queries
- Topic 1A: Creating parameter queries
- Topic 1B: Creating action queries
Lesson 2: Outer join and crosstab query techniques
- Topic 2A: Joining tables and working with join properties
- Topic 2B: Crosstab queries
- Topic 2C: Editing limitations in query datasheets
Lesson 3: Form design enhancements
- Topic 3A: Building a form based on joined tables; using functions
in forms
- Topic 3B: Using option groups and additional form design enhancements
Lesson 4: Using command buttons and macros with forms
- Topic 4A: Creating macros and command buttons
- Topic 4B: Using macros to control form properties
Lesson 5: Using macros to provide user interaction and automate
tasks
- Topic 5A: Using macros to provide user interaction
- Topic 5B: Using macros to automate tasks
Lesson 6: Advanced report techniques
- Topic 6A: Hiding duplicate data, grouping data, and using functions
in reports
Lesson 7: Introduction to the Internet
- Topic 7A: Using hyperlinks
Appendix A: Replicating databases
- Replicating databasesTopic
Appendix B: Using Access with other applications
- Linking and importing dataTopic
- Using the OfficeLinks toolTopic
Hardware/Software Requirements
You will need:
- a minimum of 12 megabytes (MB) Random Access Memory (RAM).
- a minimum of 47 MB of free space on the hard disk to install all components,
plus an additional 2 megabytes to install student data files.
- an IBM-compatible PC with a 40486 or higher processor.
- a VGA or higher resolution display adapter.
- a two-button mouse.
- Windows 95.
WINTRAC INC. - the one stop shopping center for IT training.
16523 S.W. McGwire Ct. Beaverton OR -97007
Phone: (503) 259-0312
Fax: 707-598-2268
Email: sales@wintrac.com
Send mail to webmaster@wintrac.com with questions or comments about this web site.
Copyright © 2008 Wintrac Inc.
|
