|
|
|
Microsoft Access 2003 Courseware
Intermediate Level |
1. WORKING WITH THE NORTHWIND SAMPLE
DATABASE
INSTALLING THE
NORTHWIND DATABASE
- About Northwind
- Checking for Northwind
- Installing Northwind
2. DESIGNING TABLES IN ACCESS 2003
NORMALIZING DATA
- Setting a Primary Key
- Removing Non-related Data
- Removing Redundant Data
- Removing Repeating Data
- Setting Required Values in Columns
ESTABLISHING
RELATIONSHIPS
- Using the Relationship Tool
- Identifying a Related Table
- Creating Join Types
- Enforcing Referential Integrity
- Working with Cascading Updates and Deletes
WORKING WITH INDEXES
- Creating a Single-Field Index
- Creating a Multiple-Field Index
- Setting the Index Sort Order
- Setting Index Properties
- Deleting Indexes
WORKING WITH DATA TYPES
- Choosing Appropriate Data Types
- Setting Column Data Types
- Formatting Data Types
- Converting Between Data Types
3. DESIGNING QUERIES IN ACCESS 2003
CREATING ACTION QUERIES
- Creating Update Queries
- Creating Delete Queries
- Creating Append Queries
- Creating Make-Table Queries
CREATING PARAMETER
QUERIES
- Creating a One-Parameter Query
- Creating a Two-Parameter Query
- Using Wildcards as Parameters
CREATING CALCULATED
COLUMNS IN QUERIES
- Creating Calculated Fields
- Using Common Functions in Calculated Fields
JOINING TABLES
- 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 2003
CREATING DATA ENTRY
FORMS
- 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
WORKING WITH SUBFORMS
- Creating a Subform
- Creating a Form with Two Subforms
- Creating Nested Subforms
- Deleting a Subform
CREATING POP-UP FORMS
- Creating a Modal Pop-up Form
- Creating a Modeless Pop-up Form
WORKING WITH
SWITCHBOARDS
- Creating a Switchboard
- Editing a Switchboard Item
- Deleting a Switchboard
5. DESIGNING REPORTS IN ACCESS 2003
WORKING WITH STANDARD
REPORTS
- 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
WORKING WITH POP-UP
REPORTS
- Creating a Modal Pop-up Report
- Creating a Modeless Pop-up Report
WORKING WITH SUBREPORTS
- Creating a Subreport
- Creating a Report with Two Subreports
- Deleting a Subreport
WORKING WITH REPORT
SNAPSHOTS
- Creating Report Snapshots
- Distributing Report Snapshots
DEVELOPING DATA ACCESS
PAGES
- 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 PIVOT TABLES AND PIVOT
CHARTS
CREATING PIVOT TABLES
AND PIVOT CHARTS
- Creating Pivot Tables
- Creating Pivot Charts
- Selecting Elements of a PivotT able
- Selecting Elements of a Pivot Chart
CREATING PIVOTTABLE
FORMS
- Using the PivotTable AutoForm Wizard
- Deleting Items from a PivotTable
- Filtering Items in the Pivot Table List
- Using the AutoCalc Feature
- Displaying Subtotals
CREATING PIVOTCHART
FORMS
- Using the Pivot Chart AutoForm Wizard
- Deleting Items from a PivotChart
- Filtering Items in the PivotChart List
- Changing PivotChart Types
7. IMPORTING AND EXPORTING
LINKING TO EXTERNAL
DATA SOURCES
- 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 DATA INTO
ACCESS
- Importing from Excel Files
- Importing from Other Access Databases
- Importing from ODBC Data Sources
EXPORTING DATA FROM
ACCESS
- Exporting to Files
- Exporting to Access Databases
- Exporting to ODBC Data Sources
8. BUILDING EXPRESSIONS
USING THE EXPRESSION
BUILDER
- Using the Expression Builder in Queries
- Using the Expression Builder in Forms
- Using the Expression Builder in Reports
USING COMMON BUILT-IN
FUNCTIONS
- Using Date/Time Functions
- Using Financial Functions
- Using Math Functions
- Using Text Functions
|
|
|