MP9002: Desktop Computing - Advanced Queries and Calculations > Access 2003

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. 

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

Objectives:
Use Boolean operators in queries
Create advanced queries and calculations
Replace, delete, and update data

Duration:
3 Hours