Welcome to our ultimate video guide on how to migrate your Access database to the cloud without coding.

Part 1 will give you a demo of the app so you know exactly what we plan on developing.

Summarized Video Transcript

For today’s use case, we chose an application that’s not specific to any industry.

A bug tracking, or ticket management, system is an app that’s so versatile, companies of all sizes can greatly benefit from its implementation. What you’ll see in this video guide is how easily you can modify and manipulate field elements to make it your own, and use it internally for your needs.

Below is an overview of what you’ll see:

  • An employee login screen.
  • A form that allows you to open a new bug and assign it to anyone within the team.
  • A report that allows you to see all the bugs flagged as new.
    • Includes record level security for employees to only see data linked to their ID.
    • The ability to change the status of each bug.
  • A report that displays all the bugs currently in progress.
  • A report that allows users to search bugs based on different criteria.
  • A form to add comments to any selected bug.
  • A report that lists all the comments on a bug.
  • A pie chart that shows the distribution between all the bugs based on status.
  • A line chart that shows a breakdown of all the bugs per month.

To give you a quick comparison, below is the MS Access counterpart of one of the forms:

MS ACCESS FORM

It is similar to the form that allows you to add new bugs.

Here, users have the ability to input a title, add a description, set priority and assign bugs to someone else on the team. The only difference is that this form is stored locally in our Access database, versus the Caspio form that’s been published online.

The nice thing about having forms and reports on the web is that people can log in using their credentials. And upon logging in, they’ll have access to all their information. This is one of the main reasons why many Access users are looking to bring their data online — to streamline many of their workflows and create efficiency along the way.

MS ACCESS TABLE RELATIONSHIP

In Caspio, you can do one-to-one, one-to-many and many-to-many relationships. It is a database platform where you can create table relationships like in Access.

See You in the Next Video!

In the next video, we’re going to show you how quickly and easily you can import your Access tables into Caspio, including all your data and table relationships. Once your objects are imported, Caspio is going to maintain the application integrity.

Note that your entire Access database won’t be imported. All the forms, reports and queries must be recreated in Caspio using our intuitive point and click wizards.

Next Steps

COMPARE LOW-CODE VENDORS
NEW FORRESTER WAVE REPORT
See why Forrester ranks Caspio a 'Leader' in low-code platforms in this 2019 report.
GET HELP FROM A CONSULTANT
TALK TO AN EXPERT
Have a vision for an application? Talk to a Caspio product expert and we’ll help you achieve it.
SEE CASPIO IN ACTION
SEE CASPIO IN ACTION
Want to see if Caspio is a good fit for your needs? Choose a date and time for a personalized demo.