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