Total Time: 3 hour(s)

Summary: 
This course shows learners how to use Access 2003 to construct calculations and use Boolean operators (AND/OR) to build advanced queries. It also covers how to use the Total Row and Expression Builder, and to modify data.

Ojectives: 
After completing this course, students will be able to:
Use Boolean operators in queries
Create advanced queries and calculations
Replace, delete, and update data

Topics: 
Using the AND operator
Using the OR operator
Defining the total row
Using total row options
Developing simple calculations
Performing complex calculations
Using the expression builder
Replacing data
Deleting data
Updating data

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.