|
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.
Objectives:
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
|
