|
Microsoft Certified Application Specialist (MCAS)
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
Microsoft Office Access 2007 II is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The Level II course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. To ensure the successful completion of Microsoft Office Access 2007 II, the completion of Access 2007 I, or equivalent knowledge, is recommended.
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 more information on Acumen Classes
Please contact Joann Etling 314.333.3330
or
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
1750 South Brentwood Blvd.
Suite 200
Saint Louis, MO 63144
|
