Grover Park George :
The best in MS Access Database Development

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

MS Access Database Design Grover Park ConsultingGPC Data
Home of Smart Tools©

MS MVP Awardees

George is a 2007-2009 MS Access MVP Awardee

GPG on Access Blog

Writing a blog GPG On Access @ blogspot.com has been a lot of fun. I'm currently working on a series of posts describing my attempts to use Dynamic SQL in saved queries.

Check it out.

George


Been There, Done That, Sent it to Production

Comments on recent happenings at GPC.

10,000 DOWNLOADS--and counting  

GPC: Builds Smart Tools for Smart Business ©

E-mail Us
Find Grover Park
Request Information
Grover Park Consulting's Business Partners and Links

Send Us Feedback on our Website

Tell your friends about us


Thanks for visiting us at GPC Data this morning.

George Hepworth, the man behind Grover Park Consulting, has been designing and building custom MS Access© database tools for more than 15 years. He specializes in salvaging poorly designed relational databases and "flat table" databases (primarily in MS Access or MS Excel) which cost you time and money you can't afford.

 

Let him revise an existing database, or design and build a custom database to meet your business needs.

Database Design Solutions Let us help you control your business by designing tools to capture, track and use the critical information it needs.

For more than 22 years, George has also been  creating "best in the industry" training materials. His self-study courses have been used by insurance professionals throughout the United States.

Training Solutions Let us provide you and your employees the training you need to make better use of your time and resources. We'll get you up and running on your MS Office suite of applications in no time. With more than 22 years experience, George Hepworth, owner of GPC can help you analyze your training needs, design materials and classes to address them, and provide either group or one-one-one training on demand.

Technical Communication George is a successful, experienced writer and author with more than a dozen self-study courses on a variety of insurance coverages to his credit.
His newest training book, Grover Park George on Access, is being well received by new Access users. Let him create readable, informative documentation for your organization.

View George Hepworth's profile on LinkedIn

If at first you do succeed, why not try again?

 Seeing 10,000 downloads for the first template I submitted has encouraged me to try again.

"Simple Work Tracking for Project Managers"

Recently, I uploaded a new template to the MS template site. For this upload, I selected "Simple Work Tracking for Project Managers", which was an mdb I had created several years. I recently updated it to an Access 2007 version and added new features in the mdb.  MS usually takes a couple of days to process new submissions, so it might not show up yet. Please keep checking back until it does get published.

UPDATE: Turns out MS doesn't like my newest template. Supposedly, it contains inappropriate language. You can judge for yourself by downloading the full, working version here.

10,000 DOWNLOADS and counting

A little over a year ago I submitted a template for Access 2007 to the Access Templates site. Absolutely simple, it has nothing more than a table schema and a couple of forms with comments on the tables. MS is still trying to figure out how to accept databases with VBA in them, and most of us are still trying to figure out how to create useful databases without VBA (embedded macros are okay, but, well, they are still macros.)

But 10,000 downloads is still amazing to me. It makes me think there is a way to make use of this important tool offered by MS, if I can just figure out a viable way to do it.

Today, June 27th, 2009, I checked the download site. MS reports that my contribution has been downloaded over 10,000 times. Wow, more than 10,000 people have looked at my work. And moreover, it's the number one community-submitted download. Not in the same league as the MS templates, to be sure, but still I'm thrilled to see it.

PAUG Presentation

On Wednesday, June 17th, I had the pleasure of presenting a small demo of my Previous Weekday Code at the monthly meeting of the Portland Access Users Group. It's available as a download here.

New Demo available.

I just uploaded a new demo database, available in both Access 2003 (mdb) and Access 2007 (accdb) formats.  The demo itself is fairly simple; it takes two arguments--a start date and a weekday--and returns the date in the prior 7 days on which that weekday falls. To me, the larger significance of the demo is that 1) it's my first using Access 2007, and 2) it has some simple language swapping in it to change captions on controls on the forms from one language to another (English and Español only so far). I think we're going to be doing far more of that in the future. This is my first, very small step in that direction. 


Access Stress Test Data

Has this ever happened to you? You deploy a new database and everything is fine for a few weeks, or months. Eventually, though, users start to complain about slow response times and other problems. And they want you to fix it, NOW.

Have you ever wished you could do some really heavy duty stress tests before you put your application out there and head off  that kind of result?

Here's a tool to help you do just that.

A colleague of mine has packaged up several million rows of  sample data that you can download and adapt for use in your pre-release testing.

If you decided to use this data, we'd love to hear about your experiences with it.

ghepworth@gpcdata.com


Grover Park George on Creating Dynamic, Highly Formatted Reports

The July, 2008 meeting of the Pacific NW Access Developers Group (Pacific NW Access Developers Group) featured George's Presentation on partnering Access and Excel to create highly formatted, dynamic Excel reports from an Access database.

Download the Access to Excel Report Partners file to see the techniques discussed in George's presentation.

Grover Park George on Designing Functional Tables
Only the Names are Changed...
Did you know every database ever built uses the same ten tables*?

The May, 2006 Meeting of the Seattle Access Users Group (www.seattleaccess.org) featured George's presentation entitled Normalization for Normal People. George presented his taxonomy of the ten basic types of relational tables. Everyone needs to know how to create and use them properly.

Download the PowerPoint Presentation and Sample database to see what the buzz is all about.

*Attribute fields in these tables do vary slightly.

Grover Park George on Access Buy the book at my Amazon.com Store

George's book has drawn rave reviews from readers. It's featured on Amazon.com and at most major bookstores.

You can also order your copy of Grover Park George on Access, a book for new Access users written by George Hepworth, owner of GPC Data direct from the author, (check or credit card). I'll pay your shipping costs within the continental US.

Search Amazon for other great books on Access.  Or Ask George  what books he has read and liked.

 


 GPC Solutions

Share your success with your friends and earn money for yourself. 
Ask About our $100 Referral Bonus

MS Access Database Design Grover Park Consulting

GPC  Free Stuff

adobe Archive-CD's "Scanimator"  Interested in converting your paper files to CD's or DVD's? The "Scanimator" will help you estimate how many pages you have and how much time it will take to scan them (This 4.7MB download will take up to 2 hours over a 56K modem).

adobe Free 30-Day Trial. Dish Network Installation Database. Check it out along with our other FREE DOWNLOADS!

adobe Work Tracking Tool A free database created by GPC

adobe Attendance and Hot Lunch Download the Trial version

adobe Proposed Application Profile Tell us what you need

adobe Select References Learn how a relational database can help your business

adobe Get Free Help With your VBA or Access Applications

FREE Downloads from GPG on Access and the "Old"  Smart Access

Download the Sample Personal Contacts or Dynamic Menu Database from the book.

MS Access Database Design Grover Park ConsultingRead a Sample Chapter from Grover Park George On Access: Data Modeling 101

Requires Acrobat Reader.

MS Access Database Design Grover Park ConsultingDownload the Dynamic Menu Demo Database This one was published with George's article in the June, 2004 issue of Smart Access Magazine.


Also on the GPC Site

  About Us
 Ask the Experts
  Frequently Asked Questions
  How much will it cost?
  Privacy
  Customer Service
  Case Studies
  Customer Service


Recent Comments From Happy Readers

What happy readers are saying about Grover Park George on Access:


I'm pounding my way through your "On Access" and it is by far the best book about Access for my purposes. I've been working on and off as a programmer for many years (wrote my first Fortran code in 1970) with a lot of different database languages in all that time. Now that I'm working in a Window environment, the time finally came to get a good grip on Access, and of several books I've accumulated, yours turns out to be *the* choice.
       Received 8/31/2007


This is a quick note of thanks for your book “Grover Park George On Access” and your wonderful presence on UtterAccess. You have helped more than I can say...
       Received 3/19/2007


GPG, I just wanted to thank you for an awesome book. I refer to it all the time.
       Received 5/9/2006


I've finished your book. Again, it was most entertaining and educational. I look forward to seeing future books.
       Received 3/16/2006


Thanks for taking time out of your work to write a book. I really like the sense of your "voice' that jumps off the page. I just picked up your book at B&N here in Bend, OR tonight and I feel like I know you already.
       Received 10/16/2005


I had the good fortune to find your book yesterday. Yours is approximately the 5th Access book I have read ... and it is by far the most readable. The approach you have taken is outstanding. I have found your book excellent in helping me to understand what features of Access to use and which to avoid.
       Received 7/14/2005



"There is some good in the world, and it's worth fighting for. "


Sam Gamgee to Frodo Baggins
Lord of the Rings, The Two Towers

Home Ever been to Grover Park?

This is my family's website. It runs against a SQL Server database, for you geeky types.

Grover Park Consulting excels at creating Smart Tools for Smart Business©. Call for 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-2008

Hit Counter