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 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 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 also install their products. As you review the existing functions, think of how you would 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, GPC  recommended a blended solution using an MS Access® database for input and storage and MS Excel® for reporting.GPC  designed, created, tested and installed the Database and Pivot Tables on the school network. GPC  created on-line documentation for the application. George Hepworth, GPC's principal owner, then met with teachers to provide initial training. 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-2007