The five-step design method shown in Figure 1-2 helps you to create the system that you need, at
an affordable price (measured in time or dollars). The Access Auto Auctions database, for example,
allows the client to sell items (vehicles and parts) to customers. The Access Auto Auctions database
automates the following tasks:
n
Entering and maintaining contact information for customers and sellers (name, address,
and financial history)
n
Entering and maintaining sales information (sales date; payment method; total amount,
including tax; buyer ID; and other fields)
n
Entering and maintaining sales line item information (details of items actually purchased)
n
Viewing information from all the tables (sales, contacts, sales line items purchased, and
payment information)
n
Asking all types of questions about the information in the database
n
Producing a current contacts directory
n
Producing a monthly invoice report
n
Producing a customer sales history
n
Producing mailing labels and mail-merge reports
These nine tasks that the Access Auto Auctions automates have been expressed by the client. You
may need to consider other tasks as you start the design process.
Most of the information that is necessary to build the system comes from the eventual users. This
means that you need to sit down with them and learn how the existing process works. To accom-
plish this you need to do a thorough
needs analysis
of the existing system and how you might
automate it.
One way to accomplish this is to prepare a series of questions that give insight to the client’s busi-
ness and how the client uses his data. For example, when considering automating an auto auction
business, you may consider asking these questions:
n
What reports and forms are currently used.
n
How are sales, customer, contacts, and other records currently stored.
n
How are billings processed.
As you ask these questions and others, the client will probably remember other things about his
business that you should know.
A walkthrough of the existing process is also necessary to get a “feel" for the business. Most likely,
you’ll have to go back several times to observe the existing process and how the employees work.
When you prepare to follow the remaining steps, keep the client involved — let him know what
you’re doing and ask for his input as to what you want to accomplish, making sure it is within the
scope of his needs.
12
Access Building Blocks
Part I
05_046732 ch01.qxp 11/21/06 8:44 AM Page 12
|
|