Microsoft Access Database for Adaptive Mobility Systems

We received a review from Jordan Boston of Adaptive Mobility systems. In 2015 we built a custom MS Access database for him and he has upgraded it several times since.  It is a Manufacturing and Operations database designed to track vehicle inventory, customers, work orders, invoicing, sales, parts and warranties.  

Before they contacted us they were using spreadsheets and word documents to try to keep track of everything. Now they have a custom Access database to handle everything. 

Their vans are based on a Chrysler minivan then they convert them for different needs. They've built over 6,000 of these vans so far.

Maxvan by Adaptive Mobility Systems. MS Access programmer at Just Get Productive built a custom database to manage sales, warranties, parts and customers for AMS who builds vans for people with physical limitations and disabilities.

17 Years Growing His Business with an Access Database!

We recently got a call from Greg Norrell, a customer who I built an Access database for over 17 years ago!  Greg is founder of MoreHands Maid Service based in Austin Texas.  We had a nice chat about how we had worked together to build his Access database. Greg was just starting out - and so was I.  He wanted a Microsoft Access programmer to build a database to run his new home cleaning business on.  As we designed his database together, Greg was always coming up with new ideas so sometimes it was hard to keep up with him. Over the years he has expanded and now has branches all over Texas. If you hire the right Microsoft Access programmer then your database will be built around your business workflow and become a solid foundation to grow your business on for many many years.       

Using Microsoft Access to Scan Documents

With a click of a button you can use Microsoft Access to scan in documents to store on your server and retrieve easily again from within your database. 

You can now add a feature to your Microsoft Access database that scans a document and saves it for easy retrieval later.  By simply adding a button to one of your screens and adding some complex code behind the scenes, you can take anoher step towards a paperless office.  

How it works:

  1. You click the "Scan" button on one of your Access screens (forms). 
  2. A screen opens allowing you to choose where to save the document (usually on a central place on your server)
  3. Then your scanner screen will open (example below) allowing you to select your scanner options. 
  4. Then you click the button to start the scan
  5. The document is scanned and saved on your server as a PDF file.
  6. A link to that docuemnt is automaticlly stored in your Access database for easy retrieval of the document later. 
MS Access button to scan document 


Your staff will no longer need to scan a document, manually save it to your server and then manually set a link to it in your database.  Your documents will be stored on your server and linked in your database automatically saving lots of time. 


New Dashboard Designs

Introducing Better Dashboard Design

Better use of space

With the wide screens most of us use in today's offices it's better to utilize the space on the sides of the screen for tools as much as possible. We have come up with a very flexible design which can be used for all sorts of dashboards. 

Easier to navigate

Placing the navigation on the side is better for most users to more easily get around the database. 

Many Color Combinations

A huge range of color themes can be created by mixing the color themes which come built-in with Microsoft Access with variations of the header color, sidebar color and button colors.  

Here are some examples: