Home » Course Catalog » Online Training Course Objectives and Outline
Access 2003 Series: Advanced Queries and Calculations
Product Code: macc05 Time: 3.0 hour(s) CEUs: Available

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.

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 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; Cookies enabled; Sound card with speakers or headphones strongly recommended.



Return To Top

Training Courses | e-Learning Edge | Training Course Certifications | Training Course Sign-up
Student Center | Learning Resources | Free Courses | Privacy Policy | Contact e-Learning Center

Hot Topics
IT Courses
MS Certs
Web Design
MS Office
Programming
Business
Networking
VS .NET
Personal
Full Catalog

Christian Website

Member of the Better Business Bureau Better Business Bureau
Member since 2002
Subscribe today as a member to our I.T. department and capitalize on free courses and 20% discount on our laptop computers.

Combo Packs... »

Save even more when you sign up for a combination package. Our BEST values EVER!

Read More

© 1599-2009 SK Max. All rights reserved.

General IT Web Design Microsoft Certs


Desktop Computing Business Skills Personal Skills


Combo Packages Business Videos

Articles

Features

Benefits

FAQs

e-Learning Links

e-Learning Forum

Certification Info

Other Resources

Home PageContact InformationSearch the Site
HomeOur Course Cataloge-Learning EdgeStudent Centere-ResourcesCorporate Information