This course shows users how to establish table relationships, perform join operations, and define and execute queries in Access 2000.
Objectives:
Define table relationships
Display related records
Specify query criteria
Create calculated fields
Create and modify multi-table queries
Topics:
Establishing Table Relationships
Managing Table Relationships
Displaying Related Records
Specifying Query Criteria
Creating Calculated Fields
Using Multi-Table Queries
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.