Microsoft Access 2000 Advanced 

CACC2KA                Microsoft Access 2000 Advanced 

Class Type                Programming 

System                   PC Operating Systems 

Duration                2.5 days 

Class Audience                Office Assistants, Managers at all levels, Technicians, Service

                                    Representatives, Engineers, Desk and Non-Desk Workers at all levels,

                                    Salespersons at all levels and PUBLIC AT LARGE               

Offered At                 Customer site or St Paul 

# of Students                Minimum 5 Maximum 12  

Cost                        $1172 per person at site, $1015 per person St Paul 

Pre-requisites                None 

Brief                      Microsoft Access 2000 is a Database Management and Programming

                                package. 

        Part one of Access is about databases, their creation and management.  The

        second part is about programming the created databases to create

        complete customized user applications.  This second part is comprised of

        the following elements:

1.                    Programming in Access

2.                    Advanced Programming

3.                    Building Access Applications

4.                    Multi-user and Client –Server issues

5.                    Performance and security

6.                    Internet/Intranet

This class is about this second part.  The 6 Topics above are discussed and explained extensively in class.  In addition there are detailed Lab Exercises to actually practice these concepts for thorough understanding and maturity with the package.  A certain level of maturity with the package is the goal of the class.  This  advanced class is concerned with the programming in Access.

Throughout the class the instructor presents a motivation, discussion and online demonstration for each topic/function available in Access 2000. 

The students then practice the topic/function on the provided systems using provided detailed lab exercises. 

Objectives                Upon completion of the course the student will be able to:

·         Use Visual Basic in Access

·         Work with SQL in Access 2000

·         Build Complete Custom Access Applications

·         Use Access in Network Environment

·         Optimize and secure an application

·         Publish Access objects to the Internet

Topics                   

·         Visual Basic in Access

·         Programming in Access and SQL

·         Programming Applications in Access

·         Testing Applications

·         Multi-user and Client-Server Issues

·         Performance and Security

·         Internet and intranet publishing

Training Service