SAYERS & ASSOCIATES

Computer Training

 

 

Course Description

ACCESS 2000 - LEVEL 3

Course Length 1 Day - 8 Hour Class Session

Overview Students will learn how to enhance their database designs by using the principles of normalization and table relationships. Students also learn how to query multiple tables for data that is used in customized forms and reports. Additionally, students learn how to create data access pages to share data over an intranet or the Internet

Prerequisite Introduction to Personal Computers
Window 2000 Introduction  or Windows XP Introduction
Word 2000 Level 1
Word 2000 Level 2
Word 2000 Level 3
Excel 2000 Level 1
Excel 2000 Level 2
Excel 2000 Level 3
Access 2000 Level 1
Access 2000 Level 2

Delivery Method Instructor-Led, Group Paced, Classroom-Delivery Learning Model with Structured Hands-On Activities

Benefits Students will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, students will gain experience with Internet-related features, including hyperlinks and the Web toolbar.

Target Student Students enrolling in this course should be able to work with Access at an intermediate level and understand Access terminology.

What's Next Access 2000: Level 4- Introduction to Application Design
Students learn to create custom applications
students to create custom applications.

Objectives 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; 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; 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; create mailing labels.

Use Internet-related Access tools by inserting hyperlinks and using the Web toolbar.


Please Contact Us For Class Outlines.

   

                

e-mail.gif (7997 bytes)To Contact Us:

training@sayers-associates.com
Office:    (479) 452-4439
                   (888) 933-3579
    Fax:    (479) 452-4418
       Post Office Box 10783  

             Fort Smith, Arkansas 72917