Grover Park George :
The best in MS Access Database Development

Grover Park George On Access:
The Best in MS Access Books

Success at Grover Park Consulting: Training & Database Design -- Building Smart Tools for Smart Business©
MS Access Database Design Grover Park Consulting

Case Studies
Recent success story
and previous applications.

Installations

St Pius X School

 Dish Installations

Dish Network Installation Scheduler.  In a little over three years, a Dish Network installer's business had grown from a one-person operation to more than half a dozen installers and sales reps in four states! Growth like that is good, but with it came a lot of extra paperwork. The office manager—deciding to "work smarter, not harder"—turned to GPC for help with an inventory and installation tracking application.

You can download a simplified version of the installations database for a free trial. If you like what you see, contact me, at ghepworth@gpcdata.com, to arrange a customized version for your business.

Adaptable. This database can easily be adapted to work for many small retailers who hire independent contractors to install their products. As you review the existing functions, think of how you would have me adapt it to meet your needs.

 St Pius X School Attendance and Hot Lunch Reporting.  St X Pius X School, a small Catholic School in Mountlake Terrace, WA, had been keeping attendance and hot lunch records by hand for many years. In 2002, a computer network was installed in the school, creating the opportunity for an automated system of tracking and reporting attendance and hot lunch requests. Grover Park Consulting was given the task of creating the database to do this.

After studying the school’s requirements for input and reporting, I  recommended a blended solution using an MS Access® database for input and storage and MS Excel® for reporting. I  designed, created, tested and installed the Database and Excel-based Pivot Tables on the school network. The following screen shots show the opening screens.

MS Access Database Design Grover Park Consulting   MS Access Database Design Grover Park Consulting

Teachers' Version                                                                              Office Version

With the launch of the system, teachers enter daily attendance and hot lunch requests via the PC's in their own classrooms. Office staff has immediate access to the data. It is no longer necessary to send runners to or from each classroom to gather attendance and hot lunch requests, minimizing classroom disruption. In addition, automated reporting is expected to save the office staff an hour or more each week during the school year.

Return to Top

Call or Request your solution -- TODAY!


Grover Park George :
The best in MS Access Database Development

Grover Park George On Access:
The Best in MS Access Books

GPCData Info page ©2003-2010