MS Access - Level 3, CMP083
Master the intricacies of MS Access 2007 by using the new ribbon and menu tab interface. Use the Table Analyzer Wizard to check the integrity of data to correct data redundancy problems using Junction tables. Write advanced Queries to analyze and summarize data through matched and unmatched queries, crosstab queries and a new streamlined version of MS’s PivotChart and PivotTable features. Simplify tasks by expanding mastery of the use of Macros in Access forms using Macro Builder to enter expressions and criteria conditions.
Prerequisites: Prerequisite: MS Access--Level I & II or equivalent experience.
Textbook: Purchase at the Rockville Campus Bookstore and bring to first class along with a USB Flash Drive/memory stick (at least 512 MB).
Classroom Hours: 10
-
Course Objectives:
- Restructure data into appropriate tables to ensure data dependency and minimize redundance
- Write advanced queries to analyze and summarize data
- Create and revise Microsoft Office Access 2007 macros
- Display data more effectively in a form
- Customize reports by using various Microsoft Office Access 2007 feature, making them more effective
- Maintain your database using tools provided by Microsoft Office Access 2007
Course Content
Lesson 1: Structuring Existing Data
- Analyze Tables
- Create a Junction Table
- Improve Table Structure
Lesson 2: Writing Advanced Queries
- Create subqueries
- Create Unmatched and Duplicate Queries
- Group and Summarize Records Using Criteria
- Summarize Data with a Crosstab Query
- Create a PivotTable and a PivotChart
Lesson 3: Simplifying Tasks with Macros
- Create a Macro
- Attach a Macro
- Restrict Records Using a Condition
- Validate Data Using a Macro
- Automate Data Entry Using a Macro
Lesson 4: Making Effective Use of Forms
- Display a Calendar on a Form
- Organize information with Tab Pages
- Display a Summary of Data in a Form
Lesson 5: Making Forms More Effective
- Include a Chart in a Report
- Print Data in Columns
- Cancel Printing of a Blank Report
- Create a Report Snapshot
Lesson 6: Maintaining an Access Database
- Link Tables to External Data Sources
- Manage a Database
- Determine Object Dependency
- Document a Database
- Analyze the Performances of a Database