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:
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?
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.