1 Day Course
Performance-based objectives
- 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.
- Publish data to the Web by creating data access pages.
- Customize report designs by grouping, sorting, and summarizing data, and by adding subreports.
Prerequisites
This course is designed for the student who wishes to learn intermediate-level operations of the Microsoft Access program. The Level 2 course is for the individual whose job responsibilities include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the student to integrating Access data with other applications such as Microsoft Word or Excel. To ensure the successful completion of Microsoft Access 2003: Level 2, we recommend completion of the following courses, or equivalent knowledge (basic familiarity with Access tables, relationships, queries, forms, and reports) from another source: Microsoft Access 2003: Level 1.
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
Appendix A: Using the Chart Wizard
- Creating a chart in a form or report
Appendix B: New features of Access
- View information on object dependencies
For Information Contact
Rhuann Heimann 618-523-4893
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
www.trainatacumen.com
|
