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