Join OfficeTipsAndMethods

Have some suggestions to share with the world?

Join OfficeTipsAndMethods and share your insight in a Comment. You must be a member to comment and all comments are moderated before being published. Membership is free and we would never share your personal information with anyone.

Become an OTM Member

Log In

YouTube Video Channel
Article Categories

Archive for the ‘Access Community’ Category

How do I Learn Access?

The question came as a private message, actually phrased, “How can my employee learn Access?” It seems that as part of her duties, the employee was tasked with taking over an Access database created by another employee. Regardless of the cartooncircumstances this is an excellent question. Here are some thoughts on the subject.

learning curve

Access beginners often become discouraged when they start to realized that the learning curve is actually quite long and involved. “Learning Access” is quite unlike other learning they may have experienced. Frequently a question that seems to be quite simple leads to several other questions at a more fundamental level. Each of those questions can lead to yet additional even more fundamental questions.

background knowledge and skills

Frequently “learning Access” as in learning how to manipulate things within the Access environment, is only part of the issue. I can teach you the simple mechanics of designing and creating forms and reports from the perspective of how they will look, the size and relative position of their components in a few hours. Those skills, however, barely scratch the surface of “learning Access.”

Identifying the right tool for the job is an important skill that can save you hours of frustration and wasted effort. To identify the right tool you first need to understand the job, then you need to understand the possible tools. The Crabby Office Lady has an article with some guidelines about whether Access or Excel would be the better tool for particular jobs.

Think of it this way. I can teach you to use a calculator, how to press the keys to make numbers appear on the display and how to press the operator keys to add, subtract, multiply, and divide, reasonably quickly. But, unless you know what combination of addition, subtraction, multiplication, and division you will need to apply to solve your immediate problem, knowing how to use a calculator, how to punch numbers, won’t really help you much.

Access is like that on a grand scale. Unless you learn or already know, how to analyze data, and organize it according to relational data design principles, knowing how to create a table and add fields to it, won’t get you very far. Unless you learn, or already understand, the math behind the business problems you want a database to help with, knowing how to create calculated controls on forms and reports also won’t get you very far.

Not every database involves arithmetic calculations, of course, but there are many skills that go into developing a database application that go far beyond merely having “learned Access”.”

learning by doing

There is nothing quite like experiential learning to build and enhance a permanent knowledge base. Identify a problem and then work at devising a solution. Unfortunately, if you are doing your experiential learning all on your own, what you learn and what may become a permanent part of your skill set, may not always be the best or even the ‘right’ way to solve your problem.

Experiential learning can also be a frustrating process. You may run into roadblocks that, once you have overcome them, seem to be quite inconsequential but, until they are overcome, stop you dead in your tracks. Sometimes the solution is a simple as missed dot or a missing space.


There are a number of on-line or DVD based courses available. However, as good as their content may be, such courses, are unable to rephrase or modify how they explain topics in response to questions you may have. If you run into a concept that you have difficulty understanding, you may find yourself beating your head against the proverbial stone wall if an on-line or DVD course is your only learning resource.

I have to confess that I have a somewhat biased opinion when it comes to computer training courses. I facilitate instructor led training sessions for Office applications. I believe that such courses have a distinct advantage over on-line or DVD courses precisely because learners can ask questions, can say, “I don’t understand that point,” and the trainer or instructor can rephrase the explanation, suggest alternative analogies, or otherwise help the learner overcome hurdles in a timely fashion.

Check out courses that may be available through your local community college or other adult training facilities. If you live in or near my part of the world (north-eastern Ontario, Canada, pay a visit to The Enterprise Centre Computer Software Training & Development web page to see details on the training sessions we offer there.

Quote of the Day
Recommend to your children virtue; that alone can make them happy, not gold.
–Ludwig van Beethoven

print resources

Even in today’s electronic age, hardcopy books and articles can be excellent learning resources. I have found that no one book is the best for me. Where one book or author may do an excellent job on many topics, there may be other topics that one particular author or book does not touch or explains in a way that isn’t clear to me. Reading a different author’s treatment of the same subject frequently gets me on track.

In the recommended reading section below, I have listed two books that I have found helpful in understanding Access and what it can do.

on-line resources

In the past, newsgroups, and more recently on-line forums are excellent learning resources where you can ask questions about specific problems you are having and get helpful answers and suggestions. Although you may have to register in order to post questions, many on-line forums are free. In fact, I suggest you try the free forums first. Again, my bias may be showing, but one of the best Access forums is, where I am an administrator. George Hepworth, author of one of the books recommended below and several of the co-authors of the other book are UtterAccess members, moderators, or administrators, and frequent posters at UtterAccess.

recommended reading

George Hepworth’s Grover Park George on Access is a good introduction to relational database concepts in simple layperson’s language. If you are already comfortable with relational concepts and want to see more of Access in Action, you might find Microsoft Access Small Business Solutions a worthwhile read.

Access Wiki – 2 Weeks and Counting


Quote of the Day

Real, constructive mental power lies in the creative thought that shapes your destiny, and your hour-by-hour mental conduct produces power for change in your life. Develop a train of thought on which to ride. The nobility of your life as well as your happiness depends upon the direction in which that train of thought is going.

-Laurence J. Peter

TacoBy the end of the day, the Access Wiki  will have been ‘open for business’ for two weeks. The body of Access knowledge that the site  promises to be is slowly building. As of this moment, there are 26 articles published in the wiki with articles including such topics as Normalization, Sharing (Access Databases through splitting), and Error Handling. Access Wiki content is expected to grow as UtterAccess members continue to write and publish articles. The wiki features a table of contents and an index if you want to look over a list of topics.

Meanwhile, on the forums side of UtterAccess, there is a whole new ‘look and feel.’ The new appearance is similar to what you will see one the Wiki side.

If you haven’t yet visited Forums or the Access Wiki, why not check them out now and see if you don’t agree that UtterAccess is the only source for all of your  Microsoft help needs. The wiki and forums are freely available to anyone on the World Wide Web but only registered members can download code samples from the forums or write and edit wiki articles. Membership is free and confidential. Signing up will give you access to thousands of downloads and the opportunity to contribute your own articles to the Access Wiki

UtterAccess Launches Access Wiki

Quote of the Day

The most important thing in the Olympic Games is not winning but taking part; the essential thing in life is not conquering but fighting well.

-Pierre de Coubertin


The best forum in the Access community, UtterAccess, is about to get even better.  Tomorrow, The Access Wiki will take its place alongside UtterAccess Discussion forums. This is the most significant enhancement to UtterAccess since its inception some eight years ago. In the coming months and years, the wiki is expected be become a treasure house of in-depth information for Access database developers as members contribute and update original articles discussing all aspects of developing and enhancing Access applications.

Sometime overnight tonight, will go off-line and will be unavailable for a brief period. Then, with little more fanfare than the flipping of a switch, the wiki will be ‘live to air’ and the forums will be back on-line. If you have ever visited the UtterAccess site, you will immediately notice the forum’s new look and feel, even a brand new logo, thanks to UtterAccess member and moderator Mark Davis. The wiki will share the new ‘look and feel’ of the forum. UtterAccess members will be able to log in to the wiki using the same user id and password as they use for the discussion forums.

What is a wiki? A wiki (pronounced /ˈwɪki/ WIK-ee) is a website that allows the easy creation and editing of any number of interlinked web pages via a web browser using a simplified markup language or a WYSIWYG text editor. Wikis are typically powered by wiki software and are often used to create collaborative websites, to power community websites, for personal note taking, in corporate intranets, and in knowledge management systems. (Wikipedia, the free encyclopedia)

The UtterAccess Access Wiki and Discussion Forums will naturally complement each other. Discussion Forums provides a question and answer peer support environment where members can raise and respond to specific problem oriented questions. The wiki will provide in depth discussions of Access related topics to which a user may point when responding to questions. Access Wiki readers will turn to the Discussion Forums from time to time when they need help in understanding topics discussed in the wiki. Together Access Wiki and Discussion Forums will be a win-win partnership in Access education, re-affirming that is the only source for all of your Microsoft Access help needs…and more!

I’d like to thank Owner/Administrator Gordon Hubbell for keeping UtterAccess in the forefront of the Access community over the years and for his tireless efforts along with help from Microsoft’s Clint Covington and Kerry Westphal over the past couple of months to bring the Access Wiki to fruition.

As soon as the relevant links are available, I will be publishing a follow up article.

Congratulations Gord and UtterAccess!!

Keep an eye on







Gord over at UtterAccess is putting the finishing touches on an enhancement to the UtterAccess forum that will be as significant for the Access community as was the introduction to the web of UtterAccess itself almost eight years ago. I’m afraid you will have to wait for the public launch to learn more details but I can guarantee that you won’t be disappointed. At UtterAccess, we pride ourselves as the only source for all of your Microsoft Access help needs. If every you had any doubt about that claim, this new feature will convince you that UtterAccess is what we clam and much, much more.