.
Microsoft Access™
Database Design:
Data Creative has year's of experience with the various versions of Access ™. We can set up a simple marketing database or a mission-critical system that helps you run the company.
Work your Corporate Data:
Access based systems can either be stand alone or they can be designed to link into corporate databases. This can reduce duplicated effort and ensure all staff are using the same up-to-date information.
Customised Access Databases with VBA:
Visual Basic for Applications (VBA) can be used to add features and integrate all Office™ applications including Access™, Excel™ and Word™.
Combined Excel™ and Access™ Solutions:
There are many advantages in increased productivity and efficiency by combining the functions of Excel™ with a shared Access™ database.
A typical example is time-sheet entry
- Staff use Excel™ to enter data to a shared Microsoft Access™ database.
- VBA links Excel™ to a shared database
- More users have experience with using Excel™ and so less user training is required.
- Access used as a shared database where only a few concurrent users
- Data can be exported from Access™ to Excel™ files for further analysis or use away from the LAN e.g. on Laptops.
Bespoke Systems:
Using a combination of Access™ , VBA and various sources of data, we have set up various systems.
Examples:
- Customer Service Analysis and Reporting System for a High Street Retailer
- Automated Reporting System for a blue-chip Oil Company
- Film Archive Database for a Television Company
- ISP Welcome Pack Distribution System for a Mailing House
- Warranty Documentation System for Insurers and Mailing House of a famous Scooter Manufacturer.
