Access 2003 : Level 3
Prerequisites
To ensure your success, we recommend you first take the following courses
or have equivalent knowledge:
- Access 2003: Level 1
- Access 2003: Level 2
Performance-Based Objectives
-
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
Topic 1A: Import Data
Topic 1B: Analyze Tables
Topic 1C: Create a Junction Table
Topic 1D: Improve Table Structure
Lesson 2: Writing Advanced Queries
Topic 2A: Create Unmatched and
Duplicates Queries
Topic 2B: Group and Summarize Records Using the Criteria Field
Topic 2C: Summarize Data with a Crosstab Query
Topic 2D: Create a PivotTable and a PivotChart
Topic 2E: Display a Graphical Summary on a Form
Lesson 3: Simplifying Tasks with Macros
Topic 3A: Create a Macro
Topic 3B: Attach a Macro to a Command Button
Topic 3C: Restrict Records Using a Where Condition
Lesson 4: Adding Interaction and Automation with Macros
Topic 4A: Require Data Entry with
a Macro
Topic 4B: Display a Message Box with a Macro
Topic 4C: Automate Data Entry
Lesson 5: Making Forms More Effective
Topic 5A: Change the Display of
Data Conditionally
Topic 5B: Display a Calendar on a Form
Topic 5C: Organize Information with Tab Pages
Lesson 6: Making Reports More Effective
Topic 6A: Cancel Printing of a
Blank Report
Topic 6B: Include a Chart in a Report
Topic 6C: Arrange Data in Columns
Topic 6D: Create a Report Snapshot
Lesson 7: Maintaining an Access Database
Topic 7A: Link Tables to External
Data Sources
Topic 7B: Back Up a Database
Topic 7C: Compact and Repair a Database
Topic 7D: Protect a Database with a Password
Topic 7E: Determine Object Dependency
Topic 7F: Document a Database
Topic 7G: Analyze the Performance of a Database
|
