Level 1 Course Outline
Introduction to Microsoft Access 2003
What is Access?
Creating Files
Opening and Closing a Database File
Review Questions
Access 2003 Interface
Access 2003 Workspace
Review Questions
The Database Toolbar
Using the Database Toolbar
Review Questions
The Task Pane
Using the Open area of the Getting Started Task Pane
Using the New area of the New File Task Pane
Using the Template area of the New File Task Pane
Using the Clipboard Task Pane
Using the File Search Task Pane
Review Questions
The Database Window
The Database Menu Bar
The Database Window Toolbar
Review Questions
Tables
Create a Table
Working with Tables
Review Questions
Queries
Create a Query
Review Questions
Forms
Using and Creating Forms
Displaying and Linking Images
About inserting images
Review Questions
Reports
Creating and Using Reports
Saving, Maintaining, and Printing Reports
Review Questions
Level 2 Course Outline
Working with the Northwind Sample Database
Installing the Northwind Database
Review Questions
Designing Tables in Access 2003
Normalising Data
Establishing Relationships
Working with Indexes
Working with Data Types
Review Questions
Designing Queries in Access 2003
Creating Action Queries
Creating Parameter Queries
Creating Calculated Columns in Queries
Joining Tables
Review Questions
Designing Forms in Access 2003
Creating Data Entry Forms
Working with Subforms
Creating Pop-up Forms
Working with Switchboards
Review Questions
Designing Reports in Access 2003
Working with Standard Reports
Working with Pop-up Reports
Working with Subreports
Working with Report Snapshots
Developing Data Access Pages
Review Questions
Working with PivotTables and PivotCharts
Creating PivotTables and PivotCharts
Creating PivotTable Forms
Creating PivotChart Forms
Review Questions
Importing and Exporting
Linking to External Data Sources
Importing Data into Access
Exporting Data from Access
Review Questions
Building Expressions
Using the Expression Builder
Using Common Built-in Functions
Review Questions
Level 3 Course Outline
Working with the Northwind Sample Database
Installing the Northwind Database
Review Questions
Introducing Structured Query Language
Writing SQL Commands
Writing SQL Queries
Writing SQL Subqueries
Writing SQL Joins
Inserting Data
Updating Data
Deleting Data
Writing SQL Queries in Access 2003
Review Questions
Working with Macros
Automating Tasks
Introducing the Macro Design Toolbar
Creating Macros
Testing and Debugging Macros
Modifying Macros
Conditional Programming in Macros
Adding Macros to Forms
Adding Macros to Reports
Filtering Data
Documenting Macros
Review Questions
Programming Access Using Visual Basic
Using Macros versus Visual Basic
Understanding Visual Basic Concepts
Using the Visual Basic Editor Window
Getting Help with Visual Basic
Review Questions
Using Data Access Pages
Creating Data Access Pages
Modifying Data Access Pages
Sorting Data in Data Access Pages
Summarising Data in Data Access Pages
Editing Data in Data Access Pages
Protecting Data in Data Access Pages
Review Questions
Converting Access Databases
Converting Databases to Access 2003
Converting from Access 2003 to Access 97
Converting from Access 2003 to Access 2000
Review Questions
Customising Access 2003
Configuring Access 2003 Options
Configuring AutoCorrect Options
Customising Menus and Toolbars
Review Questions
Managing and Maintaining Access Databases
Optimising Databases with Table Analyzer
Optimising Databases with Performance Analyzer
Documenting Databases with Documenter Analyzer
Avoiding errors with the Object Dependencies task pane
Review Questions
Previous Software Versions: MS Office XP, 2002, 2000
