• 01934 710666
  • info@springboardit.co.uk
  • Our Technologies
  • How We Work
  • Our Products
  • Blogs
  • Meet the Team
  • Contact Us
  • Our Technologies
  • How We Work
  • Our Products
  • Blogs
  • Meet the Team
  • Contact Us
Home / Replacing Access Database with SharePoint & PowerApp Front End

Replacing Access Database with SharePoint & PowerApp Front End

Challenge

To modernise an old Access database to enable better automation/integration and reporting etc

Solution

Move an existing Access database into SharePoint & build a new PowerApps front end.

Results

Customer has a modern, fast solution for Customer Complaints which is ready for modern integration and can be reported on

Background

At Springboard IT we are often approached by organisations that are using older technologies that lack some of the benefits of modern software. Older software products can struggle to keep up with modern concepts such as:
• Integration options
• Automation options
• Reporting
• Multiuser access
• Remote Access
We are constantly looking at ways to improve business processes for our customers, increase efficient and maximise data insights.
Recently an existing customer expressed an interest in modernising their Complaints Access Database. In this case the main driving factor for the interest was the licensing costs for Microsoft Access and the fact that users required a connection to the network to access the system. Certain features of the system were no longer required. Integration with and the reporting of were key areas of interest in the new system.

Solution

In this case the solution wasn’t to throw away the existing system and start again. The data was structured very well and it made sense to keep it. Instead, we migrated the database from Microsoft Access to SharePoint and we built new front end user screens in PowerApps for 365.
The result meant that the client was left with:
• A cloud-based database that can be accessed by any member of staff with sufficient permissions.
• Automated PowerBI reporting.
• Automated email notifications when tasks are created.
• A large saving on the previously required Access licenses.

Technologies Used
PowerApps, SharePoint
PrevPreviousOn Premise Sage Information Accessible From The Cloud
NextPower Apps – Holiday Booking FormNext

Customer Benefits

PowerApps is a rapid application development framework that enables us to get very far very quickly. It often works out cheaper than bespoke development.

Often legacy systems work very well but lack some modern concepts. A complete rebuild is often not necessary and sometimes a facelift is sufficient.

Have questions or like to discuss options for your business

  • SIT Remote Support
Youtube Linkedin
Contact Us

Springboard IT (UK) Ltd – Registered in England and Wales No 07428233
Ground Floor The Mill House, The Stables Business Park, Bristol Road, Rooksbridge BS26 2TT

  • All rights reserved
  • Privacy Policy
  • Cookie Policy