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.
Create complex queries, efficient forms and reports and create and use macros.
Course Number:
ACC2K03
Price:
$220.00
Available Classes & More Information: Access 2000 Level 3
Call 916-649-4595 to learn more about this course.