MS Access - Level 2, CMP962
In this MS Access 2010 intermediate level course, you will learn how to control table data entry by changing field properties to match specific criteria, and format patterns and expedite entry through the use of lookuptables. Become more proficient in the use of Access queries that retrieve data from multiple tables by learning how to use query joins, parameter queries, and action queries. Improve the look and ability of forms, and reports to facilitate data navigation, entry, and data organization through the use of command buttons and control parameters. Create and modify charts. Use PivotTables and PivotCharts.
This course follows curriculum for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive certifications raining students should complete MS Access Level I, II, and III.
Prerequisites: MS Access--Level I or equivalent experience.
Classroom Hours:10
Textbook: Please bring your textbook to the first class session. See MC Bookstores for more information on your textbook, bring to first class along with a USB Flash Drive/memory stick (at least 512 MB).
- Table Of Contents:
Unit 1: Relational databases
Topic A: Database normalization
Topic B: Table relationships
Topic C: Referential integrity
Unit 2: Related tables
Topic A: Creating lookup fields
Topic B: Modifying lookup fields
Topic C: Subdatasheets
Unit 3: Complex queries
Topic A: Joining tables in queries
Topic B: Using calculated fields
Topic C: Summarizing and grouping values
Unit 4: Advanced form design
Topic A: Adding unbound controls
Topic B: Graphics
Topic C: Adding calculated values
Topic D: Adding combo boxes
Topic E: Advanced form types
Unit 5: Reports and printing
Topic A: Customized headers and footers
Topic B: Calculated values
Topic C: Printing
Topic D: Labels
Unit 6: Charts
Topic A: Charts in forms
Topic B: Charts in reports
Unit 7: PivotTables and PivotCharts
Topic A: PivotTables
Topic B: Modifying PivotTables
Topic C: PivotCharts
Topic D: PivotTable forms