|
Writing a blog,
GPG On Access, has been a lot of fun.
This is one of my New Favorite
Cartoons:
xkcd.com
Here's another:
Raw Materials You'll have to register, but it's really worth
it, if you are a computer geek, or are in love with one.
George Hepworth, aka Grover Park George, founded Grover Park Consulting, to design and build
custom MS Access© database tools more than
9 years ago.
George spent two years on the staff of
Advisicon, a
project management a development organization in Portland, Oregon.
Send me your Access Questions
Find Grover Park
Business Partners and Links
Tell your friends about us
As I wander about the wide world of the inter-webs looking for good
ideas for my own Access work,
I have found a number of Access sites with downloads, articles, and other
useful resources. In the process, I began to venture outside the relatively familiar
realm of English-Language sites and add some sites in German and Spanish.
Although there are many Asian language sites, my inability to read
or understand them means I can't properly evaluate them, and
therefore should not try to include links to them. But the wealth of
material is simply astounding, if you take the time to look.
I have also added some sites maintained by local Access User Groups. They are all listed here: the
Resources and Partners page here at GPC Data. Roger Carlson's recent
efforts to refresh resources for his famous
Library
motivated me to fix up my own.
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.
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.
|
 Download the Dynamic Menu Demo Database This one was published with George's article in the June, 2004 issue of
Smart Access Magazine.
|
Although my most recent template submission, "Simple Work Tracking for Project Managers",
did not get published, I am thrilled by what I'm seeing on the MS
Template Site. You can see what Microsoft is (ahem) missing by not
publishing my work by
downloading the
full, working version here at GPCData.
I'd REALLY love to hear
What You Think.
I also
updated "Simple Work Tracking for Project Managers" to an Access 2007 version and added new features in the mdb.
You can download the full,
working version here. I anticipate being able to resubmit it to the MS
Template site again in the near future.
A little over two years ago, I submitted my original template for Access
2007 to the Microsoft Access Templates
site. Absolutely simple, it has nothing more than a table schema and a
couple of forms with comments on the tables. Microsoft is now working out a
procedure by which they can accept databases with VBA in them. However, for
the moment, they are still limited to macros.
Last time I checked, Microsoft reports that my contribution has been downloaded over
19,331 times. Wow,
more than 19,000 people have looked at my work. Not in the same league as the
Microsoft templates, to be sure, but still I'm thrilled to see it and to consider what
it might mean for independent developers trying to gain attention for their
products. I really can't wait for Microsoft to open up the community site
even more. Nonetheless, 19,331 downloads
(to date) of this simple little database is amazing to me. I
did the math, that comes out to at least 20 downloads EVERY DAY.
It makes me
think there is a way to make use of this important tool offered by Microsoft
, if I can just figure out a viable way to do it within the
parameters required.
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.
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 Access
George's book has drawn
rave reviews from readers. It's featured on
Amazon.com and at most major bookstores.
FREE Downloads from GPG on Access and
the "Old" Smart Access
Download the
Sample Personal Contacts
or Dynamic Menu Database from the book.
 Read a Sample Chapter from Grover Park George On Access:
Data Modeling 101
Requires Acrobat Reader. |
