Microsoft Access 2000 Basic

Access1001                Microsoft Access 2000 Basic

Class Type                 Basic Operation

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. The package 

                                    can be considered as 2 parts.  The first part itself is composed of several parts:

      1.                    Over view of Access 2000

      2.                    Data, Databases and tables

      3.                    Queries and SQL

      4.                    Access Forms

      5                      Access Reports

      6.                    Controlling Access and Using Other Applications

      This class is about this first 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. The 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:

            ·         Install and configure Access 2000 for daily usage

            ·         Work  and customize the basic Access 2000 user interface

            ·         Create, administer and manipulate databases

            ·         Exhibit knowledge of database fundamentals

            ·         Create, use and modify queries in SQL

            ·         Create, use, design and modify Access forms

            ·         Create, use, Design and modify Access reports

            ·         Create, use, design and modify Access macros

            ·         Work with graphs and graphics

            ·         Use ActiveX and OLE automation

            ·         Interact with other Microsoft Office products

Topics                   

            ·         Getting Started with Access 2000

            ·         Data, Databases and Tables

            ·         Queries and SQL

            ·         Access Forms

            ·         Access Reports

            ·         Controlling Access and Using Other Applications

Classes available