Continued from page 1
Your list for database uses will likely be much longer--just brainstorm a list of all
places where consolidated information would make your life easier!
The secret's in
planning You want to get
most out of your database, right? Then make sure to plan it right from
start.
Before you go running off to set up your database you need to ask yourself these important questions:
::What do you want to use your database for? ::What data do you want to keep track of? ::Who will be collecting
data? ::How much data is there to collect--50 records or 500 records? ::Who will be doing
updates? ::What reports do you want your database to generate?
You may find it easiest to map this out on a piece of paper first. Work out how your database is going to fit together. How will each category relate to
others?
Get
maximum use out of your database: By now, you've invested a lot of time in your database plans, design, and setup. Don't miss this important step: getting
most out of your creation.
First, you'll want to make
database as easy to use as possible. Create one-click touches to produce
information you need. Set up shortcuts so you can create
most important reports quickly. And make sure you really consider
easiest way to enter new data.
By applying this advice in your own database, yours will be easy to use AND have
maximum use value to you!

Tracey Lawton, Virtual Office Manager, supports small businesses and independent consultants with their office administration and audio transcription projects. She has over 18 years office management and administration experience for both public and private sector organisations, as well as independent consultants and professionals. http://www.traceylawton.com Subscribe: http://www.traceylawton.com/tips.htm