28 May 2006

Real World Access (7)

One of a series of articles about where Microsoft Office Access applications have found a real-world niche.

Jeff Conrad's restaurant network

I created a small Access application for each of our remote restaurant locations to enter their daily numbers. Each evening the restaurants had to fax their daily numbers to the main office where someone would spend a few hours each morning transferring this information to a spreadsheet. If any stores forgot to fax their numbers, we would have to call them as a reminder. Once all the information was complete, this person then had to print out a copy for all the big wigs in the office to see. Another copy was faxed to each Regional Manager.

We already had hardware available so I set up a VPN and placed a BE Access file on that server. I remotely placed a FE file on each restaurant PC and linked them to the VPN BE. I even remotely placed a FE copy on each of the Regional Managers’ home PCs. In the office I placed a FE copy on each of the big wigs' PCs. With this setup (no additional costs here) all of the stores could enter their daily numbers into the Access database. All of the Regional Managers and the big wigs could pull up a report on their own PCs now to see the numbers. I created several other types of comparison reports as well.

We saved probably 20 hours per week for that one person who used to manually compile this information as well as all the long distance fax charges. We only have two stores now, but I still use it and have 5+ years of data for our current locations.

What really surprises me is that I had only been using Access for a very brief time before setting this up.


Powered by Qumana


At 27 September 2006 2:44 PM, Blogger Fred Boer said...

Enjoyed reading about the application Jeff... "Bigwigs".. isn't that a rabbit in "Watership Down"? ;)


Post a Comment

Links to this post:

Create a Link

<< Home