Grover Park George on Access: Unleash the Power of Access [NOOK Book]


Someone finally figured out that Access is used by tens of thousands of ordinary people in thousands of businesses, social and civic organizations -- not just computer geeks and IT Professionals. The author assumes his readers are intelligent human beings who have to solve real business problems every day. He assumes that they're more interested in solving those problems than in becoming Access gurus. He also assumes that they have selected Access to solve those problems because, above all, it's a tool that ...
See more details below
Grover Park George on Access: Unleash the Power of Access

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac

Want a NOOK? Explore Now

NOOK Book (eBook)
$8.49 price
(Save 14%)$9.95 List Price


Someone finally figured out that Access is used by tens of thousands of ordinary people in thousands of businesses, social and civic organizations -- not just computer geeks and IT Professionals. The author assumes his readers are intelligent human beings who have to solve real business problems every day. He assumes that they're more interested in solving those problems than in becoming Access gurus. He also assumes that they have selected Access to solve those problems because, above all, it's a tool that works. He wrote this book for them.
Read More Show Less

Editorial Reviews

From the Publisher
“You’ve taken the first step in becoming a database expert by selecting this book. Bottom-line, if I can understand how to develop databases from reading this book, anyone can.” —Bruce Garrett, CEO, Archive-CD, LLC
Read More Show Less

Product Details

  • ISBN-13: 9781615473182
  • Publisher: Holy Macro! Books
  • Publication date: 7/1/2008
  • Series: On Office series
  • Sold by: Barnes & Noble
  • Format: eBook
  • Pages: 512
  • Sales rank: 1,077,017
  • File size: 8 MB

Meet the Author

George Hepworth is a writer and instructional designer who has designed, researched, and written more than a dozen self-study courses. He is the founder of Grover Park Consulting, a database development company.
Read More Show Less

Table of Contents

Foreword a
1. What This Book Will Do for You 1
Why You Need this Book 1
A Professional Approach 1
What's in this Book 2
Get Normal 2
How to Use this Book 3
2. Why Do You Want to Use Access Anyway? 1
Do I Really Need a Database? 1
Understanding the Problem 1
What Do My Answers Mean? 2
The Right Tool for the Job 5
Why do you want to use Access? 5
Who Will Use the Database 7
How Much Data Will the Database Hold 7
What Hardware and Software is Available 8
Networked Environments 9
Access It Is, Then! 10
3. Data Modeling 101 1
The Cardboard Box Metaphor 1
It's All About the Data Model 2
Okay, Cardboard Box Guy, Model This 2
What Do I Want to Keep Track of--the Entities 3
Tech Talk--Formal Entity Definition 3
Hierarchies and Entity Groups 4
Choosing a Model--Workflow and Business Rules 7
Entities Have Attributes 9
Enough Attributes 10
Tech Talk--Entities, Attributes and Relationships 10
Entity 11
Attributes 11
Domain 12
Attribute/Data Value Pairs 12
Relationships 13
Relationship Set 15
Relationship Types 15
One-to-One Relationships 15
One-to-Many Relationships 16
Many-to-Many Relationships 17
Key Attributes 19
Further Study 20
Creating an Informal Data Model 20
Your Data Model 20
My Data Model 24
Entities, Definitions, and Attributes 24
Managing Data--Delete vs. Inactive 26
Status 27
Who's Related to Whom 28
Gray Areas, Trade-Offs, and Lessons Learned 28
Lessons Learned 29
Trade-Offs 30
Summary 30
4. Let's Get Physical 1
Naming Conventions 1
It's Finally Time to Open Access 1
Create a New Database 4
Setting Options 6
Create a New Table 9
Your First Table 13
Naming Conventions 14
Data Type 16
Primary and Foreign Keys 19
Key Attributes and Natural Keys 20
Primary Keys 20
Summary--What are Primary Keys 22
AutoNumbers for Primary Keys 23
Primary Key Notation 24
Indexes, With and Without Duplicates 26
Ignore or Allow Nulls 27
Foreign Keys 28
Views 29
Add a Related Table 31
Can You Relate to This? 42
Creating Relationships in the Relationship Window 42
Taking Stock 51
5. Try it Yourself--Create Tables 1
Data and Look Up Tables 2
Additional Look Up Tables 2
Additional Data Tables 5
Person Table 8
Many-to-Many Relationships and Junction Tables 10
Household Head 13
Relationships 15
Wrapping Up The Table Design 17
6. Normalize Your Data 1
Why Normalization Matters 1
The Goals of Normalization 2
Eliminating Redundant Data 2
Selecting the Smallest Meaningful Values 3
Storing Only Related Data 3
The Rules of Normalization 4
Cutting You Some Slack 4
First Normal Form 5
First Normal Form Defined 10
Second Normal Form 11
Third Normal Form 14
Summary--The Normalization Process 17
7. Try It Yourself--Normalization 1
Steps to Normalization 4
Calculated Fields 14
Taking Stock 17
Creating the Relationships 23
Address Table Relationships 25
We're All Normal Here 25
Backup, Backup, Backup 26
8. Getting Data Into Your Database--Simple Forms 1
Forms, the Primary Data Input Tool 1
Bound and Unbound Forms 2
Main Forms and Sub Forms 2
Unbound Forms 2
Learning Strategy for Forms 4
Controls 11
Moving and Aligning Controls 17
Create a Form from Scratch 19
Other Form Properties 36
Add a Command Button 36
How the Button Works 40
The Builder Button 40
Shortcut to Creating New Forms 45
Change the Record Source and Control Source 46
Navigation on Forms 47
Triggering Events on a Form 48
From Simple to Intermediate 48
Backup, Backup, Backup 49
9. Getting Data Into Your Database--Intermediate Forms 1
Drag and Drop Fields 1
Navigating with a Searching Combo Box 3
Combo Boxes and Visual Basic for Applications Code 7
Conditional Instructions in VBA 13
What this Conditional Statement Does 15
Why I Prefer Combo Boxes to Scroll Bars and Navigation Buttons 18
VBA Behind the Combo Box--Further Study 18
Creating SQL Statements 19
Housekeeping Chores--Control Names 27
Try it Yourself 29
My Design for frmParent 30
Command Buttons 36
Further VBA Study 40
Tab Order and Tab Stop 40
Intermediate Form Complete 45
Backup, Backup, Backup 45
10. Getting Data Into Your Database--Complex Forms 1
Add Sample Data 1
Main Form--Sub Form Strategy 2
Unrelated Sub Forms 2
Add a Subform 2
Pre-defined Relationships 5
M 6
Subform Control versus Subform 7
Bound Column, Column Count, and Column Width 14
Assigning New Persons to a Household 20
Handling Errors in a Combo Box Not In List Event 26
Help with Visual Basic for Applications 28
What the Custom Message Box Does 30
Try It Out 31
Adding New Records through the Form 32
Timing Issues with Record Sets 33
Modify the VBA for the Add Button 33
Designating Heads of Households 35
User Interaction Strategy 39
Independent Data Entry Forms 39
Interrelated Data Entry Forms 40
Designing Forms to Support Workflow 40
Generalizing the Lesson 41
Where Were We Just Now? 41
Move a Command Button from One Form to Another 42
Remaining Issues 48
Try it Yourself 49
Additional Data Entry Forms 49
My Suggested Subforms 51
Phone Number Subform 53
Forms Wrap Up 57
Additional Enhancements and a Self Study Opportunity 58
Backup, Backup, Backup 58
11. Getting Data out of Your Database--Reports 1
Useful Reports and Forms 1
Mailing Labels Report Wizard 2
String Concatenation in Reports 11
Data Display Versus Data Input 12
Hey, What Was that "Trim" Thing You Skipped Over? 12
Adding a Second Table to the Report's Record Source 12
The Expression Builder 18
Creating Expressions 19
Click to Paste Expressions 19
Functions in the Expression Builder 21
Using the Expression Builder in our Labels 22
Adding Text to an Expression 22
Using The Expression Builder 24
Field Names 24
Sorting Records 25
Page Set Up 27
Wrap up the Label Report 30
Birth dates by Household Report 30
Create a Query 30
Report Requirement--Query Contents 31
Inner Joins 37
Report Wizard--Birthday List 42
Report Wizard, Field Layout on the Report 46
Report Wizard, Report Style 46
Headers and Footers 48
Creating a Calculated Field on a Report 58
Debugging Existing Report 65
The Root of the Problem 65
Fixing the Bug 67
Report Filters 70
Wrap Up Report 71
Backup, Backup, Backup 71
12. Getting Data out of Your Database--Display-only Forms 1
Display-only Form 1
Creating an Event to Requery the Birthday List 11
Other Filtered List Forms 13
Filtering Records for a Report 13
Design View 14
Backup, Backup, Backup 17
13. Create a User Interface 1
Hands Off the DB Objects, Please 1
Ah, It All Makes Sense Now 2
A User Interface for Our Contacts Database 2
Keep it Simple, Stupid 2
Navigation by Menus 3
A Menu-Based Switchboard 5
The Grover Park Menu Switchboard 6
Try it Yourself 18
Using the Menu to Close Forms 19
Coding Efficiency 22
Assign the Function to the On_Click Event 22
Forms Consistency 24
Maintenance Forms 25
Control Form for Printing Reports 31
Filtering List box for the Printed Report 41
Let's Get Outta Here 45
Consistency and Workflow 47
Background and Foreground Colors 47
Background Images and Icons 48
Screen Resolution 48
Form Height and Width 49
Form Open Event Procedures 50
Menu and Tool Bars 50
A Custom Menu Bar 52
Open the Toolbar Customization Dialog 53
Create a New Toolbar 54
Assign the Custom Menu Bar as the Default Menu 59
Hide and Lock the Menu Bar 60
Bypassing Startup 61
An Application Ready to Test 62
Identify Entities and Attributes 62
Normalization 62
Identify Relationships, Primary and Foreign Keys 63
Get Data in, Creating Input Forms 63
Get Data Out, Creating Reports and Display Forms 63
Manage Records and Forms 63
Control the Application 64
Where Do You Go From Here 64
Download Personal Contacts 65
Appendix A 1
Index 1
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted July 21, 2004

    Absolute Must for New Access Users

    There are lots of good Access books out there and I've read a lot of them, but this one is different in one important way. It is written from the point of view of the NEW User who is just trying to figure out to get the darned application to do simple things like save contact information and print out mailing lists. If you need help with advanced VBA, you won't find it here, but if you want to understand the why's as well as the how's of setting up a decent database, this is the book for you. Another thing I liked about the author's approach is that he assumes you're not a dummy at all and that you can grasp some fairly sophisticated--and important--concepts if he just takes the time and trouble to explain them. Not for the advanced developer, to be sure, but if you know someone who needs to get started using the Access the Right Way, tell them about Grover Park George on Access.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)