Database Design For Executives & Professionals |
|
Information is an
essential tool for any business or professional person.
All the information in the world is worthless until we can
change it into knowledge. Creating
and using a database is an effective method to harness all our information
and turning it into powerful knowledge.
The most important
aspect of designing a custom database is planning.
With good planning our databases will aid our long-term efficiency
and effectiveness. Take the
time to design and plan. Too
often our databases are created while we're in the working process, which
leads to poor design and functionality.
Plan on using a relational database MS Access is a good choice. Planning and developing your table structures is equivalent
to building the foundation of a home. If you cut corners on the foundation
of your home or use cheap materials, your home will have structural
problems down the road. Likewise, if you have poorly structured tables in
your database, you'll be limiting the functionality of your database. Here are some
very basic
steps for insuring that your database foundation is solid:
After the planning is
complete, the creation process should be relatively easy if you know how
to use the basics of your database. Remember to design the layout for
your out-put and reports first -
then create your tables, forms, and then final creation of reports. Finally,
test, test, test
revise & fine-tune your database as needed. Be flexible - your database is a dynamic living entity. You will return to the planning and design phases as you find new uses for your custom database and your needs change.
|
To Contact us by E-Mail: JOANS followed by @
joansvoboda.com (formatted to foil Spam
Bots!)