Alpha Software Blog

Oxford Instruments Builds Microsoft Access Web App

Oxford Instruments builds web app for preventative action using legacy Microsoft Access database.Manufacturing company builds web app for preventative action using legacy Microsoft Access database.

About Oxford Instruments

Oxford Instruments plc is a leading provider of high technology tools and systems for industry and research.


Oxford Superconducting Technology, a company of Oxford Instruments plc, has a corrective and preventive action (CAPA) system to identify and fix any issues in its manufacturing process, and to institute safeguards to prevent these problems from occurring again. Oxford was managing the second part of this system — preventive action—with a legacy Microsoft Access desktop application.

The company was experiencing scalability and performance issues with the Access desktop database and needed to migrate the backend from the MS Access workgroup-class database to a robust enterprise SQL database. The migration, however, introduced a whole new set of problems, because the old Microsoft Access front end didn't map well to the SQL fields on the new back end.

Complicating this, company officials decided the time was right to modernize the application to take advantage of the web and, ultimately, mobile devices. They wanted a contemporary cloud-based system that would let shop floor workers reliably manage preventive action efforts directly from their tablets as well as desktops. Raising the stakes even higher, company officials set a two-month deadline to prototype and produce the new custom web app.


Leading the project was Oxford Superconducting Technology's Business Analyst Sagrika Mehta. While Mehta holds a computer science degree and has experience in database management, she focused her career on IT analysis rather than programming. She started to work on scoping the project, and estimated the app build would require a large team of skilled programmers and lots of late-night man hours. Hearing this, a colleague recommended Alpha Anywhere.

Mehta downloaded Alpha Anywhere from Alpha Software's site and started playing around with the RAD IDE. To her surprise, in just two days she had prototyped three mission-critical forms. She leaned back in her chair and realized Alpha Anywhere could get Oxford on the fast track to launching their new preventive action app, and at a substantial cost savings to boot. One month later, Mehta had completed the design, build, and test of the new application.

Using Alpha's myriad RAD components, wizards, and "coding optional" technology, she rapidly and visually designed the database, forms, and business logic; and then connected that design to cloud, mobile, and desktop user experiences — all with no past programming experience.

Sagrika Mehta built a Microsoft Access web app."I was never keen on programming until I found Alpha Anywhere. The platform has shown me how easy it can be to build enterprise-grade, mission-critical apps. My colleagues are telling me I deserve a 'Best Programmer Award,' but the real honor goes to Alpha."

- Sagrika Mehta, Business Analyst, Oxford Superconducting Technology


When Mehta unveiled the app, her colleagues told her she should get a "Best Programmer Award" for her amazing results. Alpha Anywhere let Mehta — a non-developer — created the enterprise-class B2B mobile business app Oxford needed with a single code base that meets 100% of the company's front- and back-end requirements, including support for tablets, smartphones, laptops, and desktops, as well as Microsoft SQL Server.

Replacing the old Microsoft Access database would have taken two to three months and multiple developers to build, yet it took one developer just 30 days with Alpha Anywhere, beating the project's deadline by half.

Thirty Oxford Superconducting Technology workers now use the app to easily and securely manage preventive action efforts from wherever they are on the shop floor, using tablets, continuing to ensure the company upholds its strict manufacturing policies and procedures. In fact, Mehta's success prompted Oxford to migrate several other applications to Alpha Anywhere, expanding the platform into a core piece of the company's IT infrastructure across multiple operational areas.

Build Microsoft Access Web Apps to take legacy Access desktop applications to mobile devices. Alpha Anywhere includes database templates and web app templates.

Prev Post Image
Creating a PhoneGap Application From the Demo Mobile App
Next Post Image
Why Everything You Think You Know About Mobile Development is Wrong

About Author

Default Author Image
Chris Conroy

Chris Conroy runs digital programs for Alpha Software.

Related Posts
New Webinar: How to Integrate ChatGPT with Alpha Anywhere
New Webinar: How to Integrate ChatGPT with Alpha Anywhere
Featured App: Tracking COVID-19 in Sports
Featured App: Tracking COVID-19 in Sports
Freight Handlers Inc. Uses Offline Apps to Improve Operations
Freight Handlers Inc. Uses Offline Apps to Improve Operations

The Alpha platform is the only unified mobile and web app development and deployment environment with distinct “no-code” and “low-code” components. Using the Alpha TransForm no-code product, business users and developers can take full advantage of all the capabilities of the smartphone to turn any form into a mobile app in minutes, and power users can add advanced app functionality with Alpha TransForm's built-in programming language. IT developers can use the Alpha Anywhere low-code environment to develop complex web or mobile business apps from scratch, integrate data with existing systems of record and workflows (including data collected via Alpha TransForm), and add additional security or authentication requirements to protect corporate data.