SAM II - Financial Data Warehouse using Access 2007
Duration: 1 day
Cost: $95.00 per student
Prerequisite
You must already have detail access to the Data Warehouse and experience with SAM II financial and Microsoft Access. You will be using your own user ID for this class. An understanding of Access 2007 is important before attending this class. Taking an Introduction to Access 2007 class is strongly recommended.
Course Outline:
Using Access 2007
Creating Table Relationships
- Understanding and Creating Table Relationships
- Editing and Deleting Table Relationships
Understanding Queries
- Creating Queries
- Creating a Query Using the Simple Query Wizard
- Creating a Query in Design View
- Customizing a Query
- Editing a Query Design
- Working with Query Expressions
- Using Expressions in a Query
- Specifying Multiple Criteria
- Creating Calculated Fields
DB2 Connection
- Attaching to the Data Warehouse
- Logging On to the Data Warehouse
- Linking Tables into Access
Data Warehouse
- Understanding the Data Model
- Understand the reporting elements of the SAM II Data Warehouse
- Data Model Ledger, Reference, Document, and Summary Tables
- Identify the appropriate reporting fields of the Data Model
- Select and organize tables for ad hoc reporting analysis
Ad hoc Reports
- Creating Ad hoc Reports
- Finding the Fields
- Developing the Query
- Pulling Reports off the Web
- How to download the available queries
- Stopping Runaway Transactions
