|
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 |
