Systems that bring data together

  • CASE STUDY

    Device Tracking

    • Tracking and data-collecting for medical measuring devices
    • Barcode reader integrated with custom Microsoft Access database
    • Reporting - 100% accuracy, time saved
    • Accountability and regulatory compliance achieved
    • Quick ROI - helped deliver profit for first time

    Read more

  • CASE STUDY

    Reducing Missed Appointments

    • Hair and beauty service company
    • Losses from missed appointments calculated
    • Custom-built Access database linked to SMS reminders
    • 30% reduction in missed appointments achieved
    • ROI in under eight months.

    Read more

  • CASE STUDY

    Working without Internet

    • Existing offline Microsoft Access system
    • Staff at trade shows unable to access information
    • Manual updates introduced errors, lowered sales staff confidence
    • Existing system modified to easily accept updates of offline data
    • Accuracy guaranteed, confidence increased, sales increased

    Read more

  • CASE STUDY

    Commission Payments

    • Commission system paying over 600 salespeople
    • Flaws in process, staff overburdened
    • Process analysis and custom-built Access system provided
    • Overpayments worth hundreds of thousands of pounds stopped
    • Three members of staff released from duties

    Read more

  • Analysing Excel

    • Sales commission sharing system
    • Analysed over 5,000 Excel spreadsheets
    • Replaced with custom-built Access database
    • Payment errors eradicated, accountability delivered
    • Halved commission admin headcount

    Read more

  • Device Tracking
  • Reducing Missed Appointments
  • Working without Internet
  • Commission Payments
  • Analysing Excel

  • CASE STUDY

    Device Tracking

    With the help and expertise of SME Data Solutions this company, which deploys medical measuring devices to their clients, lowered costs, saved time and increased accuracy. A tracking and data-collecting system was built using barcodes to identify individual devices and a Microsoft Access database to connect movement history with measurements. Reports were easier and faster to produce and 100% accurate - improving service to clients and improving accountability for regulators. The new access database played a significant part in returning a profit for the UK arm for the first time ever.

    Read more

  • CASE STUDY

    Reducing Missed Appointments

    SME Data Solutions helped this hair and beauty services company to reduce missed appointment slots by 30%. They were using a manual appointment book, having previously tried a ‘home built’ Excel equivalent without success. The custom-built Microsoft Access database we provided was so successful that it recovered its costs within eight months. Time is money - the value of significantly reducing missed appointments paid back the cost of the Access system within eight months.

    Read more

  • CASE STUDY

    Working without Internet

    By modifying a Microsoft Access database so that offline data could easily be integrated with the core system at head office, SME Data Solutions helped this company increase sales staff confidence while at trade shows. Figures no longer had to be manually updated to the central Access database when staff returned from shows, saving time and effort and increasing accuracy. Staff at shows increased sales figures as a result of knowing that their information was accurate and up-to-date.

    Read more

  • CASE STUDY

    Commission Payments

    A company that relied heavily on the efforts of 600 sales people was able, with the help of SME Data Solutions, to dramatically increase the accuracy of its commision tiering payment system. A Microsoft Access system dropped the number of queries from salespeople from 6000 per year to less than 100. We replaced an overwhelmed Microsoft Excel system ran by five admin staff with an Access database system run by two staff. Putting a stop to overpayments totally hundreds of thousands of pounds each year repaid the cost of development a hundred-fold.

    Read more

Why Not Microsoft Excel?
Excel

Why Not Microsoft Excel?

Microsoft Excel is fantastic at presenting figures but at what point do you migrate to a SQL or Access database system?

Read more

Custom Build Databases
Support

Custom Build Databases

Microsoft SQL and Access systems can automate processes and work with other systems, eliminating errors, saving time and money.

Read more

Microsoft Access Support
Support

Microsoft Access Support

Been let down by your current developer? Staff who put systems together no longer with you? Call us now.

Read more