| |
|
|
| Course: |
Access
2002 Working with database |
| Course No.: |
E502b |
Hours: |
18Hrs |
| Description: |
| Database is something operators
shall always deal with in operations. Handling data with data
is no wonder a critical part of office work. Microsoft Access
2002 is the data management tool within the Office XP Package
dealing with all data which might be used by Excel, Word and
other applications. On the other side, with ODBC tools, it can
also process data from FoxPro, SQL server ´etc outside of the
Office Package. We design this course for all office users to
help them to manage the database with the Office XP pack installed
in computer. No need to install other tools, as you have already
got Access 2002. |
| Objectives: |
1. Getting familiar with the new
layout of Access 2002
2. Brief Introduction of Access 2002 application structure and
objects
3. Inputting and editing data through tables and analysis of
data
4. Import, export and link data
5. Analyzing data relation through tables
6. Getting all kinds of results through various queries
7. Friendly interface with database through forms, reports and
pages |
|
|
|
|
| Course: |
Access
2002 Database developer |
| Course No.: |
E502a |
Hours: |
18Hrs |
| Description: |
| Database technique is always
hot in the overall IT career. To be a database developer
is by no means easy. We design this course for those who
have already formed a strong concept of database and an
experience with Access. We are going to help them to be
capable of managing a database and building application
with Visual Basic Application in this course. In a word,
this course is to make you professional in the database
technique field with Access 2002. |
| Objectives: |
1. Maintenance of Access
2002 database
2. Managing database easily with Macro designing
3. Working more professionally with VBA Module
4. Dealing with different tasks by Access functions
5. Designing Toolbars, menus and switchboard to finish
a perfect application
6. Protecting your application through Access 2002 security
system
7. Making Access 2002 a tool to communicate with outside
database
8. Building application practice |
|
|
|
|
