Access 2000 Level 3

Course Number: ACC2K03

Create complex queries, efficient forms and reports and create and use macros.

• Vendor: Microsoft
• Category: Desktop Applications Courses
• Outline: Access 2000 Level 3 PDF
• Prerequisites
• List Price

Description

Students will learn to do the following: make select queries more versatile and useful by using parameters; use action queries to update data values and add or delete records; generate different query types by creating various types of joins between tables; and use crosstab queries to summarize data; use advanced form features including properties, functions, and design tools to facilitate data entry and improve accuracy in forms; and display table information that has a one-to-many relationship by creating forms that contain subforms; automate tasks by creating macros to open forms and control form properties; make forms more functional by using macros to provide user interaction and automate data entry; make reports more concise and easier to understand by using properties and functions in report controls; use Internet-related Access tools by inserting hyperlinks and using the Web toolbar; and integrate Access data with other Office 2000 applications.

Prerequisites

Access 2000 Level 1 and Level 2 or equivalent knowledge.Students enrolling in this course should be able to work with Access at an intermediate level and understand Access terminology.

List Price

$220.00