I love hearing your comments and suggestions! if you do not find the help you seek in the links I have given you, my business is personal training and programming.

For those of you who wish to go beyond these pages. I am more interested in exposing you to the power of Access than I am in selling a book. only 100 pages compared to great references boasting 1500 pages - but the only good books are the ones you read. Others of you will weigh my book against the rest and mine is small!. Some of you can't afford it - and I want to help you I have been there. If I were to write a book, many of you would not buy it. Why am I giving you this document instead of publishing a book and making you pay money to get it? How is text information distinguished from numbers or dates? How do you indicate a field in a table or a control on a form?Īre there places on the Internet where you can ask questions and folks will help? YesĪre there good books for learning Access? YesĪre there web pages you can go to for valuable information? YesĪre there sites devoted to Access 2007? YesĪll these questions and more will be answered and explained. Now that the basic structure is in place, how do you make it easy for the users to enter data? How do you create reports? How does all the various information relate? What can you do to while you are designing your database to get an overall view?

Relationships, Referential Integrity, Indexes (PDF 140kb).

but the simple way is not often easy to see! Tips to get you looking at your data from a different angle. Learn about the basic Access objects: Tables, Queries, Forms, Reports, Macros, and ModulesĪlso explains Properties and Methods, VBA, and Reference Libraries What are the principal applications for computers? Put Access into perspective with other applications. Every figure is numbered and is in the List of Figures

Table of Contents and List of Figures (PDF 60KB)Įach chapter and section title is summarized in the Table of Contents, along with its page number.

These 100 pages are packed with information and, since 'a picture is worth 1,000 words', there are also lots of screen shots. No time is wasted, and no extra words are used. If you have taken classes in Access, you will find that this document probably goes well beyond what you have been taught.

you will get thereĮach time you read this document, you will learn something new. Nothing with the power of Access is easy, so just take one step at a time. Check back every now and then to see if a new version has been posted.įor those of you who are new to this information, don't be discouraged if there are things that don't make sense. In the 15 or so years that I have been using and teaching Access, this document is the result of what I feel is most important to know. I also wish to give a special thanks to Allen Browne for hosting this document on his fantastic website that has brightened many a dark corner. Tom, your never-ending patience, great technical knowledge, and true friendship are blessings in my life. In addition to those listed in the introductory comments, I wish to give a BIG thank you to my fellow Microsoft MVP, Tom Wickerath. The accuracy and thoroughness of this document would not have been possible without lots of help. If you have a logical mind and a desire to learn, all you need is a good foundation. If you are not a programmer, you will become one - because that is where the deepest power of Access gets unleashed. Learn Access -1- Perspective - Types Of ApplicationsĪccess Basics is designed for those of you with a thirst to understand the fundamentals of Access with programming in mind.Crystal's Access Basics Access Basics (Feb 20, 2008)

Crystal programming language pdf