If you decide to start using a database there are some key considerations before
parting with any of your hard-earned cash:
- Stability. Use a well-established database developer who uses an industry-standard
database system. You don’t want your supplier or the database system to disappear.
EMA Technology have been around since 1992, Microsoft have been around a little longer
(but not much).
- Ease of use. A sophisticated database system is of little use if you don’t understand
how to fully exploit its capabilities. Our Access databases are all menu-driven.
You don’t need to delve into SQL or VBA to extract data. Any data that you need can
be extracted through a few keystrokes on the menu.
- Clear Reports. Access is renowned for the quality of the reports it produces. The
most complex data extraction will be represented in a clear and concise format.
- Performance. The more successfully your database is integrated into the business
the more people will use it. Our databases are designed for multiple users accessing
data at the same time. There are strict controls in any DBMS system to prevent multiple
users corrupting data. Our database design will ensure that optimum performance is
- Backups. This sounds an obvious one but we double-check all of our installations
to ensure that adequate backups are performed. The more you rely on your database
to run the business the more you will suffer it you lose it. Adequate off-site backup
protection is essential to guard against theft, fire, flood etc etc.
- Security. We assume that most of the data trusted to our databases is confidential
so we build in sophisticated security mechanisms to ensure your data remains yours.
- Data Migration.At some point you will need to input your company’s current data
into your new database. If your data is held on spreadsheets this is straightforward.
Migrating from Excel to Access presents no problems. If your data is held in paper
format then someone needs to ‘volunteer’ to input it into the database as a one-off
job. Regardless of where your data is now we can help to get it into your database.
An analysis of your data requirements is one of the first steps we take when analysing
your system. We won’t just say “Here’s your database, get on with it”