Microsoft Office Access 2003 Training Classes near Nashville
MS Access 2003, 2002, 2000 Level 2
1 Day Training Class
Performance Objectives of this MS Access 2003 to 2000 training class:
- Normalize sample tables by
identifying design problems.
- Establish relationships between
tables by analyzing table relationships and enforcing referential integrity.
- Customize table designs by setting
field properties to maintain data integrity, by creating a lookup list, and
by creating indexes.
- Design select queries by using
multiple tables to calculate, group, average, and concatenate values and to
show top values.
- Customize form designs by creating
calculated fields, combo boxes, and unbound controls.
- Interact with data through a browser
by creating and using data access pages.
- Customize report designs by
grouping, sorting, and summarizing data, and by adding subreports.
Course content:
Lesson 1: Principles of table design
- Normalizing data
- Normalizing data for fourth and
fifth normal forms
Lesson 2: Principles of table
relationships
- Analyzing table relationships
- Establishing and testing referential
integrity
Lesson 3: Table design techniques
- Data validation techniques
- Indexing techniques
Lesson 4: Designing select queries
- Using calculated fields in queries
- Creating multiple-table queries
Lesson 5: Customizing form designs
- Customizing the form design
- Performing calculations on a form
- Adding combo boxes to a form
- Adding unbound controls
Lesson 6: Working with data access
pages
Creating data access pages
Lesson 7: Customizing reports
- Customizing a report created by the
Report Wizard
- Working with subreports
MS Access 2003 classes. Training the Nashville and Murfreesboro Tennessee area.
|
Please Consider our Schedule for Microsoft Office Access 2003 Training Classes near Nashville
Training Schedule
(DSOC0252)