Here is a Access
Tutorial that takes you through the the
steps to
create
a database application using Microsoft Access 2000. It uses
easy to following instructions along with screenshots to help you see
how the tasks are performed. The tutorial introduces the features of
Access and prepares you for learning and doing more with this database
application. The database concepts taught here can be
applied to any database managment system (DBMS) which you may
use to
create
your application. This tutorial can also be used with Access XP and
Access 2003. Click here
to download the database
created
in this exercise (zip format, use 7-zip
to uncompress it).
Requirements for this Access Tutorial:
Imagine you have been called in by the special
assistant to a
Fortune-500
company CEO. She feels overwhelmed by the volume of correspondence
coming
in that has to be handled, and wants a way to keep track of it. As
letters
and email arrive, it is usually assigned to an assistant for handling,
who may further assign the matter to a division or department. The
special
assistant wants an automated method to keep on top of this
correspondence, so that
none
of it gets misplaced, mishandled, or improperly ignored.
Access Tutorial Contents:
1. Introduction
- Table Design and Starting Access
2. Create
the Table
3. Create
a Data-entry Form
4. Create
a Query
5. Create
a Report