|
Training materials for::
Windows Vista
Windows 2000 / XP
Microsoft Word
Microsoft Excel
PowerPoint
Microsoft Access
Internet
Explorer
Outlook
Microsoft Project
Microsoft Publisher
Microsoft FrontPage
Microsoft Visio
 Expression
Web
Computer
Concepts
ECDL / ICDL
Downloads
PLUS MANY MORE ...
|
Microsoft Access XP 2002
Intermediate Level Courseware Training Materials
Training Course Outline
1. WORKING WITH THE NORTHWIND SAMPLE DATABASE
- About Northwind
- Checking for Northwind
- Installing Northwind
2. DESIGNING TABLES IN ACCESS 2002
- Setting a Primary Key
- Removing Non-related Data
- Removing Redundant Data
- Removing Repeating Data
- Setting Required Values in Columns
- Using the Relationship Tool
- Identifying a Related Table
- Creating Join Types
- Enforcing Referential Integrity
- Working with Cascading Updates and Deletes
- Creating a Single-Field Index
- Creating a Multiple-Field Index
- Setting the Index Sort Order
- Setting Index Properties
- Deleting Indexes
- Choosing Appropriate Data Types
- Setting Column Data Types
- Formatting Data Types
- Converting Between Data Types
3. DESIGNING QUERIES IN ACCESS 2002
- Creating Update Queries
- Creating Delete Queries
- Creating Append Queries
- Creating Make-Table Queries
- Creating a One-Parameter Query
- Creating a Two-Parameter Query
- Using Wildcards as Parameters
- Creating Calculated Fields
- Using Common Functions in Calculated Fields
- Creating a Two-Table Join
- Adding Fields from Different Tables to the Query Grid
- Removing Tables from the Query Builder
4. DESIGNING FORMS IN ACCESS 2002
- About Forms
- Choosing an Appropriate Control
- Placing Controls on a Form
- Moving a Control
- Resizing a Control
- Setting Control Properties
- Creating Page Headers and Footers
- Creating Form Headers and Footers
- Setting Form Properties
- Working with Identifiers
- Creating a Subform
- Creating a Form with Two Subforms
- Creating Nested Subforms
- Deleting a Subform
- Creating a Modal Pop-up Form
- Creating a Modeless Pop-up Form
- Creating a Switchboard
- Editing a Switchboard Item
- Deleting a Switchboard
5. DESIGNING REPORTS IN ACCESS 2002
- About Reports
- Placing Controls on a Report
- Moving a Control
- Resizing a Control
- Setting Control Properties
- Creating Page Headers and Footers
- Creating Report Headers and Footers
- Sorting Records on a Report
- Grouping Records on a Report
- Setting Report Properties
- Creating a Modal Pop-up Report
- Creating a Modeless Pop-up Report
- Creating a Subreport
- Creating a Report with Two Subreports
- Deleting a Subreport
- Creating Report Snapshots
- Distributing Report Snapshots
- Using the New Data Access Page Wizard
- Defining a Data Source for a Stand-Alone Data Access Page
- Creating Stand-Alone Data Access Pages
6. WORKING WITH PIVOTTABLES AND PIVOTCHARTS
- Creating PivotTables
- Creating PivotCharts
- Selecting Elements of a PivotTable
- Selecting Elements of a PivotChart
- Using the PivotTable AutoForm Wizard
- Deleting Items from a PivotTable
- Filtering Items in the PivotTable List
- Using the AutoCalc Feature
- Displaying Subtotals
- Using the PivotChart AutoForm Wizard
- Deleting Items from a PivotChart
- Filtering Items in the PivotChart List
- Changing PivotChart Types
7. IMPORTING AND EXPORTING
- Linking to Text Files
- Linking to Microsoft Excel Spreadsheets
- Linking to HTML Files
- Linking to Other Access Databases
- Linking to a SQL Server ODBC Data Source
- Importing from Excel Files
- Importing from Other Access Databases
- Importing from ODBC Data Sources
- Exporting to Files
- Exporting to Access Databases
- Exporting to ODBC Data Sources
8. BUILDING EXPRESSIONS
- Using the Expression Builder in Queries
- Using the Expression Builder in Forms
- Using the Expression Builder in Reports
- Using Date/Time Functions
- Using Financial Functions
- Using Math Functions
- Using Text Functions
Other Microsoft Office 2002 Courseware materials
|
