Microsoft Access 2000 - 2003 Level 2 - Advanced Database Design (D1N2)
Classroom Learning
Classroom Learning
Also available via
Who Needs to Attend
Those who are familiar with Access 2000 - 2003 and want to expand their capabilities
Prerequisites
There are no prerequisites for this course.
Follow-On Courses
There are no follow-ons for this course.
In this instructor-led course, you will advance your knowledge of Microsoft Access 2000-2003. You will learn how to insert and delete text to edit a document, then select different views, and print the document. You will create advanced reports using controls, grouping, subforms, calculations, graphic images, and charts. Finally, you will work with and create web-based objects.
What You'll Learn
- 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
Course Outline
1. Database Overview
- Database Overview
2. Enhancing Tables
- Copying a Database Object
- Lookup Fields
- Creating a Lookup
3. Advanced Queries
- Query Overview
- The Query Wizard
- Nested Queries
- Query Joins
- Make Table Queries
- Append Queries
- Summary Queries
- Crosstab Queries
4. Advanced Forms
- Form Design
- Controls
- Form Properties
- Subforms
- Advanced Calculations
- Customizing Forms
5. Advanced Reports
- Designing Reports
- Sorting and Grouping
- Layout Properties
- Calculations
- Subreports
- Graphic Reports
- Chart Wizard
6. Supplemental Topics: Working with Web Tools
- Working with Web Pages
- Data Access Pages
- Hyperlinks
Classroom Dates and Locations
Don’t see the location or date you need? No problem – just use our By Request service.
Course Code: 8660
Registration Information
$295 CAD
1 Day Course
Microsoft Course: D1N2
Practice Files
RSS