MS Access - Level II, ITI-154
Summer 2014 Course Description: (Click here for Fall 2014 Description) 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 certification training students should complete MS Access Level I, II, and III.
Prerequisites: MS Access--Level I or equivalent experience.
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
MS- ACCESS –LEVEL II
Course Description Fall 2014: This course builds on the skills and concepts taught in Access 2013 Level I. Learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels. This course follows the curriculum for the Microsoft Office Specialist core-level for Access 2013 (exam 77-424). For comprehensive certification training, students should complete MS Access Levels I, II, III. Prerequisites: MS Access Level I or equivalent experience, Working with Windows or File Management Skills or equivalent experience.
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).
Course Objectives: After completing this course, students will know how to:
- Normalize tables, analyze tables, and view objective dependencies; set table relationships; implement referential integrity between related tables; and set cascading deletes and updates.
- Create lookup fields and multi-value fields; modify lookup field properties; and use a subdatasheet to add data to related tables.
- Create join queries; create calculated fields in a query; and use queries to view summarized and grouped data.
- Add unbounded controls, graphics, and calculated fields to a form; and create multiple-item forms, split forms, datasheet forms, and subforms.
- Add headers and footers in a report; use functions to add calculated values in a report; print database objects and database documents; and create labels.
- Create and modify charts in forms and reports.