Free Downloads and Links

Proposed Application Profile
Links to Database and Access Resources

You'll need the free Abode Reader^® to open and read some of the documents on this page.

You may want to acquire a program like WinZip ^© to open compressed files  WinZip is free to try and inexpensive to register if you decide to continue using it.

Create Dual Demo

July, 2010 Create a DUAL Table Demo
A Hidden "System-Like" table to support UNION queries in Searching Combo Boxes

Dual tables have characteristics similar to the ORACLE DUAL table:

a) Hidden, so users are not tempted to use it for other purposes.
b) Consist of a single column and contain a single record.
c) Not editable.

You can read about the reasons for creating this demo , which you can use to create your own DUAL tables, in my blog. Most of the code in this demo was created by my friend, BananaRepublic.

Random Values, Variable Number Demo

Create scratch accdb on-the-fly  
Random Values, Variable Number Demo

 Random Selection of "N" members in each Category

This little demo grew out of a question regarding a recordset from which the user needed to RANDOMLY select three records from each category. Normally that's possible with a subquery to select the Top 3 records to match. However, in this table, there was no primary key, and therefore, no way to order the subquery records so as to get the correct results. My solution was to generate a temp table with a randomly generated unique key for each record, from which the Top 3 subquery could select the right records. For the demo, I added support for selecting ANY number "N" of records per category.

However, in order to support the constant addition and deletion of records in a temp table without bloating the main accdb, I added support for creating an on-the-fly scratch accdb into which the temp table could be placed. If you've ever wondered how to avoid database bloat in Access databases, you need to check this one out.

Artists & Recordings Demo 

September, 2009 Artists and Recordings Demo

Many-to-Many data entry in a Main Form/Subform design.

This little demo is shows ONE way to enter records in all three tables in a many-to-many relationship. It was created in response to a thread at Utter Access. The content is recordings and artists. One artist can record many songs, one song can be recorded by many artists. The use of two Main Form/Subform pairs allows the user to enter either songs or artists or both and slip back and forth easily between them.

Travel "Pack" Demo 

Tenant Billing Demo

Multi-Field Filter by Form Demo, Access 2003

August, 2009. Multi-Field Filter. This demo incorporates some ideas that came to me while answering questions at Utter Access. The basic requirement was to apply one or more filters to the records in a form, by selecting values for one or more fields. I ended up expanding the original concept to include:

• a text field which accepts multiple terms, e.g. "first, second, third" separated by commas. Fields in the form are designated as "Filter Fields" by the use of the control's Tag property

• a multi-select list box one or more choices for values in a single field. Code dynamically identifies the relevant filter field from the bound column of the list box, so it can be applied to one or more list boxes (not tested with multiple list boxes in my demo).

• a combo box, which allows a single value choice for the field. Code dynamically identifies the relevant filter field from the bound column of the list box, so it can be applied to one or more combo boxes (not tested with multiple list boxes in my demo).

 Work Tracking Demo, Access 2007 Version

Work Tracking Demo, Access 2003 Version

 Work Tracking Demo, Access 2003 and Access 2007 Version in a single ZIP FIle

June 2009.  What's Up with Templates?

The template version of this Work Effort Tracking database was designed by Grover Park Consulting for distribution through the MS Office Template site.

For several years, MS has offered templates for many common database applications on their website, starting with versions in Access 2000.

With the launch of Access 2007, MS took this concept a step further, offering developers the opportunity to participate by submitting their own work as templates.

Unfortunately, the requirements for submitting templates are so stringent it has proven to be quite difficult to get a community-submitted template approved. The most onerous restriction has been that the database can contain NO VBA at all.

The template version of Work Effort Tracking is GPC's attempt to take advantage of the wonderful opportunity MS has opened up to the developer community. To get past the Template filters, I submitted this application to MS as a template file, emptied of all VBA and macros. That version is a shell consisting of tables, forms, queries and reports only.

Here you can download the full, working version of it, WITH the VBA that makes it work. These versions are working accdb/mdbs.

Originally I built this tool for my own use in tracking time and efforts on projects for my clients--a sort of "super time sheet", if you will. Over time I expanded the concept to include some rudimentary Project Management features, such as defining the deliverables for a project, scheduling major milestones, and prioritizing tasks. A the moment, it's a little more than a timesheet and a little less than a full-blown project management tool.

I hope you find it useful. I hope you find the interface intuitive and the functions discoverable. In any case. I'd love your feedback.

 You may either use Work Tracking as-is or modify it to suit your needs. Please let us know of any modifications you'd like to see or if you'd like an estimate on a customized version for your organization.

Previous Weekday Date Demo. Versions in Access 2000 and 2007 formats (107KB).

School Volunteers Access 2003  version only(612 KB) .

April, 2008.  School Volunteers was originally created when I was in charge of a major School Fund Raiser at my daughter's school. I used the previous version of this application for 4 years and my successor used it for 3 more years when she took over as chairperson. Recently, I decided to update it and make it available here as well. You may download and try it out for free. If you have an earlier version of Access, contact Grover Park Consulting. I'll try to arrange for you  to get the right version for your software.

To try it out, create a folder for it on your hard-drive and save the compressed file,  schoolfundraising.zip,  to that folder. Double-click on the "zip" file to open and extract the files into that folder. Double-click on "FundRaisingFE.mdb" to launch the application. You'll be asked to locate the data tables. They are in the file called "FundRaisingBE.mdb". Locate that file and follow the on-screen dialogues to link to the data tables.

There is no documentation for this application, but the functions should be discoverable. If you have questions about it, contact me at Grover Park Consulting.

To purchase a full version of the Application, customized to meet your organization's unique needs,  please contact Grover Park Consulting.

Return to Top

Download the Documentation first (192 KB) 

Work Tracking 2002
 Access 2002 version. (803KB)
Work Tracking
Access 2000 version (773 KB)
Work Tracking '97
Access 97 version  (114 KB)

LEGACY Versions of Work Tracking

March 2005. These versions are my original Work Tracking  MS Access© databases.  The original was created using MS Access 2000.

Even though they've been replaced by an updated version, (actually two versions, one in Access 2003 and one in Access 2007), I can't bring myself to retire the originals yet. Partly that is because it was my first experiment with using a list box control in a "Pull" menu that avoided opening and closing multiple forms by loading everything into a subform control in the main form.

These guys have been on my website, in one form or another, for  lonf. I like to look at them, from time to time, to remind myself how far I've come.

To try Work Tracking, save the compressed file (WorkTrack.zip) to a folder on your hard drive. Double-click on the "zip" file to extract the database. Launch MS Access and open the database (WorkEffortDemo.mdb). This version of Work Tracking is not secured so you can "look under the hood", if you like.

Return to Top

Contact Manager
Access 2003 version only (1.4MB)

Read or download the Instructions (PDF Format) first.

Download Installations 2003 (1,636K)

Created to ease the paperwork flood in an Dish Network Installers business, Installations is a fully functional MS Access database. You can try it out, "as is" on your own PC for free. Keep in mind, though, that because it was custom-built, it probably would not be of direct use to you without some modifications.

To try it out, create a folder for it on your hard-drive and save the compressed file (installations.zip) to that folder. Double-click on the "zip" file to open and extract the files into that folder. Double-click on "Installations.mdb" to launch the application. You'll be asked to locate the data tables. They are in the file called "InstallationsBE.mdb". Locate that file and follow the on-screen dialogues to link to the data tables. Installations was created in MS Access 2003. Other versions are not currently available.

 If you wish to purchase Installations, customized to your business needs, contact Grover Park Consulting for a quote on a custom update.

Return to Top

Return to Top

Grover Park Consulting exists to help you solve your business problems with Smart Business Tools. I believe one way to do that is to make sure you understand what those tools are and how they work. While there are many good references on the web to choose from, I've limited ourselves to these three.  Check our Partners of Grover Park Consulting and Access Resources page

What is a Relational Database? This reference article from Microsoft's own site explains it in relatively (pun intended) simple terms.
Jerry Dennison on Naming Conventions and Jerry Dennison on Normalization Two excellent overviews of the subject by a man I consider to be the best in the business. While it may be a bit on the technical side for some, it is as well-written and no-nonsense as any discussion we've seen on the subject.

Call or Request your solution -- TODAY!

Return to Top