Database Info

What is a database?

A database is a collection of data. Filing cabinets and Card Files are good examples of manual databases. Which have served us well for generations, but have significant shortcomings:

  • They are very slow to use.
  • Data is duplicated and often misfiled

Electronic spreadsheets (flat file databases) are another type of database. They are faster than manual databases, but for a large number of entries are very slow. They also contain much redundant information, since duplicate data must be reentered many times.

Relational databases store information in a more efficient manner than a spreadsheet. They use a series of related tables each containing only specific information on a topic. The database structure results in information being entered only once. They operate very fast and can handle thousands of entries.

Clyde Data designs relational databases using Microsoft Access and Visual Basic as development tools

 

Why would I want a relational database application for my organisation? 

  • Free up time from repetitive tasks of running the organisation
  • Get immediate access to vast quantities of information about the organisation
  • A database could greatly enhance campaign efforts. Providing reminders for follow ups.
  • A database can be designed to match your normal practices, and replace many repetitive administrative tasks.
  • Reduce the quantity of paperwork in your office.
  • No more lost contacts or data. All your work will be available at your fingertips on the database

 

How can I get a database?

There are really two ways to purchase a database, buy an off-the-shelf product or have a custom database developed.

Off-the-Shelf Database Products

Various database products to help with your work are available off-the-shelf. These typically have a low initial cost, and may be what you need if your long term needs can be met by a single package.

One common problem with off-the-shelf database products is the need to buy various packages to meet all your needs. The organisation can end up with a number of software systems that don't communicate with each other. Reentry of the same data becomes necessary which can be time consuming.

Custom Database Products
Since one size doesn't fit all, you may benefit from a database designed to fit your Organisation we can design a custom system to match your normal workflow

Can I construct my own database using the MS Access tools I already have? 

Simple databases can be constructed with only a basic understanding of Access and no Visual Basic background, or you may spend the time to learn MS Access and Visual Basic for Applications language to build a more advanced package

Our databases use Visual Basic code to provide data validation and automate processes. If you have not included appropriate data validation and error trapping in your database application, you may risk of loosing or corrupting valuable data.

Comments