|
MICROSOFT ACCESS XP – Data Analysis and Reporting
Course Aims:
This course is designed to provide the skills necessary to analyse data and enhance reports by utilising the information contained in an existing database.
Contents:
Introduction to Relational Database
Relational vs. Flat File Database
Creating Relationships
Enforced Referential Integrity
Join Types
Join Properties
Select Queries
Select Query v Select Filters
Creating a Select Query
Multi-Table Queries
Entering Search Criteria
Query Expressions
Sort and Sort Within
Hiding a column
Calculated Fields
Summary Total Queries
Find Unmatched Records Wizard
Parameter Queries
Creating Parameter Queries
Pattern Matching
Action Queries
Make Table Queries
Delete Queries
Append Queries
Update Queries
Crosstab Queries
What are Crosstab Queries
Creating Crosstab Queries
Rows, Columns and Values
Office Links
Collect and Paste among Programs
Collect multiple items with Office Clipboard
Analyse with Excel
Publish with Word
Merge with Word
Enhanced Report Design
Understanding Report Bands
Adding Titles, Labels and Fields
Calculated Fields in a Report
Sorting and Grouping
Pivot Tables
Using the Pivot Table Wizard
Page, Row, Column and Value Fields
Filtering Data
Grouping Dates
Graphs
Selecting the Graph Data
Free-Standing v Embedded Graphs
Changing the Properties of a Graph
Target Audience:
Individuals that create or use existing databases that wish to learn the skills necessary to analyse the data and produce enhanced reports.
Assumed Knowledge:
Access XP Essentials or equivalent experience is required.
Duration: 1 Day
Suggested Follow Up:
Access XP Specifics
printer friendly version
|
