ADVANCED
Course
length: 2 half-day sessions
Who
should attend: Anyone responsible for the setup
of a database for others to use
Suggested
Background: Access Intro & Intermediate courses or
equivalent experience
This
course will show you how to structure existing data, write advanced queries,
work with macros, make effective use of forms and reports, and perform database
maintenance.
Upon completion of this course, you will be able to:
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 Using a Crosstab Query
Create a PivotTable and a
PivotChart
Lesson 3: Simplifying Tasks with Macros
Create
and 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 Reports 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
Document
a Database
Analyze
the Performance of a Database