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
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