Microsoft SQL Server™
Upgrade to SQL Server or Revise an Existing System:
Often client's outgrow Microsoft Access and require a database that can handle more data and concurrent users. For performance, scalability, and reliability, Microsoft SQL server is hard to beat. More >>
Data Creative can help in the migration from Access or other databases to SQL Server.
We can also revise existing installations to add new functionality.
Web Based Solutions:
We can design dynamic in-house interactive web sites on your LAN. These can link to SQL Server corporate databases. These are particularly cost effective as license requirements for users are minimised, e.g. Microsoft Office™ is not required on each PC, just a browser.
Using secure replication, sections of the database can be published to your web site. This gives clients and consumers fast dynamic access to up-to-date information about you and your products.
Combined Office™ and SQL Server™ Solutions:
Familiar Microsoft Office™ applications like Access™, Excel™ and Word™ can be linked to large stable SQL Server databases.
Examples:
- Staff use Excel™ or Access™ to enter data to a shared SQL Server database.
- VBA can link Excel™ or Access™ to the shared SQL Server database.
- Sophisticated security settings on SQL Server allow users to only see appropriate data.
- Marketing and other staff can use Word Documents set up to link to Client and Prospect data on SQL Server for analysis and mail shots.
- Data can be exported from the SQL Server database to Access™, Word or Excel™ files for further analysis or use away from the LAN e.g. on Laptops.
- Mission-Critical system for an Electrical Testing company. Based on Access and SQL Server. This system handle job planning, job documentation, test result entry, certificate and other report production, marketing, invoicing, Sage Accounts update and job costing.
- Full desktop and web solution for an auditing company designed around SQL Server and Access. It creates audit questionnaires, handles a 15 concurrent data-capture stations, processes results and produces reports.