17 Years Growing His Business with an Access Database!

I 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 

Benefits

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

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: