Just starting in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can program fairly well in excel but want to learn Access. I am the type
that needs examples and needs it explained simple. What are some books and
programs for dummies like me. Thanks in Advance. Total Noob for Access.
 
Hi Khanjohn,

Here is a link with lots of book recommendations:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html#Books

A good book to get started with would be Building Microsoft Access
Applications and/or Microsoft Office Access 2003, both written by John
Viescas:
http://www.viescas.com/Info/books.htm#Access

The books resource pages at the MVPS site are also good:
http://www.mvps.org/access/resources/books.htm

Spend lots of time pouring over all the links at MVP Jeff Conrad's site.
You'll discover lots of other web sites worth bookmarking by starting at
Jeff's Table of Contents:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

Take the time to learn database design, naming conventions and reserved
words as starters:

Naming Conventions
Special characters that you must avoid when you work with Access databases
http://support.microsoft.com/?id=826763

Commonly used naming conventions
http://www.mvps.org/access/general/gen0012.htm
http://www.xoc.net/standards/default.asp

Using a Naming Convention
http://msdn2.microsoft.com/en-us/library/aa164529(office.10).aspx

Reserved Words
Problem names and reserved words in Access
http://allenbrowne.com/AppIssueBadWord.html

Make sure that your PC is properly updated with service packs for the
operating system, Office, and the JET database engine:

How to keep a Jet 4.0 database in top working condition
http://support.microsoft.com/?id=303528

Read the 10 Commandments at the MVPS site, and bookmark this site as well
(link provided on Jeff's site). Read everything you can on the following
MVP's web sites, and bookmark these as well:

Allen Browne
Arvin Meyer
Tony Toews
Doug Steele
QBuilt

You should be able to find links to each of these sites at Jeff's site.
Doing these things will serve you well, because you'll avoid many problems
that other's routinely run into. My advice is to divide your learning
sequence into three general phases:

Database Design
Access Interface
SQL & VBA Programming

Leave the SQL & VBA programming until you have learned some database design
and are fairly comfortable using the Access interface.


Good Luck!

Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
I have found the 'for Dunmmies' books to be very good. There may be one for
Access.

-Dorian
 
Back
Top