Access 2003: Level 3
Course Description
Overview: Students will create complex Access databases
using forms, reports, and macros.
Prerequisites: Windows 2000 or Windows XP; Access 2003: Level 1; Access 2003: Level 2; or equivalent
knowledge.
Performance-Based Objectives
Upon successful completion
of this course, students will be able to:
- restructure an existing set of data to improve
the design of a database.
- use a variety of techniques to summarize
and present data with queries.
- create and revise basic Access macros.
- create macros that improve data entry
efficiency and integrity.
- improve the effectiveness of data entry
in forms.
- improve the effectiveness of data displayed
in reports.
- maintain an Access database by using
various utility tools.
Course Content
Lesson 1: Structuring Existing Data
Import Data
Analyze Tables
Create a Junction
Table
Improve Table Structure
Lesson 2: Writing Advanced Queries
Create Unmatched
and Duplicates Queries
Group and Summarize
Records Using the Criteria Field
Summarize Data with
a Crosstab Query
Create a PivotTable
and a PivotChart
Display a Graphical
Summary on a Form
Lesson 3: Simplifying Tasks with Macros
Create a Macro
Attach a Macro to
a Command Button
Restrict Records
Using a Where Condition
Lesson 4: Adding Interaction and Automation with Macros
Require Data Entry
with a Macro
Display a Message
Box with a Macro
Automate Data Entry
Lesson 5: Making Forms More Effective
Change the Display
of Data Conditionally
Display a Calendar
on a Form
Organize Information
with Tab Pages
Lesson 6: Making Reports More Effective
Cancel Printing of
a Blank Report
Include a Chart in
a Report
Arrange Data in Columns
Create a Report Snapshot
Lesson 7: Maintaining an Access Database
Link Tables to External
Data Sources
Back Up a Database
Compact and Repair
a Database
Protect a Database
with a Password
Determine Object
Dependency
Document a Database
Analyze the Performance
of a Database