Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 8th, 2004, 08:20 AM
Registered User
 
Join Date: Mar 2004
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access Reference Books

I am teaching myself Access and am a VERY basic user. I don't know VB and can't write my own code. But I [u]have</u> been able to do things like putting nested iif statements in a query. Can anyone recommend a good book that discusses queries, functions, expressions, that sort of thing? I also would like to learn more about normalization and switchboards.

Thank you

Reply With Quote
  #2 (permalink)  
Old April 8th, 2004, 06:40 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

For queries funtions and expressions just type "expressions" on Access help and this will give you a lot of samples. On normalization, you could do a search on the web on the xubject and find some good sources. Try the MSDN library. It covers the subject well.

I remember buying the Access 2000 Bible a long time ago, I am not sure on your version of Access, but that book was an excellent source for this type of information.

If you are a bit more interested into Hard Core Access, I recommend Alison Balter's books. (just mentioned that on another tread). Try amazon's ratings on books. Anyway, the best thing to do is to go to a large book store and glance all the access books and you will see the subject that you are interested in and you could probably find the best book to suit your needs.

Hope that helps.



Sal
Reply With Quote
  #3 (permalink)  
Old April 9th, 2004, 10:13 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Alison Balter has a good series on Access from beginning to Enterprise development. She has a good teaching style.

You may also want to go to a class. Just get into the right level cause the more advanced students try to intimidate you.

mmcdonal
Reply With Quote
  #4 (permalink)  
Old April 9th, 2004, 10:48 AM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

True. Another thing I do is, I take classes at universities or community colleges to ensure that the amount of time that I have between classes islonger. This allows me to absor more information and do more testing on my own. This one week crash courses are not always the best and only route.




Sal
Reply With Quote
  #5 (permalink)  
Old April 9th, 2004, 10:03 PM
Registered User
 
Join Date: Mar 2004
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks, Sal and mmcdonal. I'll definitely check out the Alison Balter book.

Reply With Quote
  #6 (permalink)  
Old April 10th, 2004, 05:17 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Norwich, Norfolk, United Kingdom.
Posts: 129
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Two books that I've had several years use out of, and still keep going back to them:

Access 97 VBA by Smith & Sussman (Wrox)
Microsoft Access 97 Developers Handbook

So both are highly recommended by me.

Clive Astley
Reply With Quote
  #7 (permalink)  
Old April 10th, 2004, 11:12 AM
Authorized User
 
Join Date: Feb 2004
Location: Edmonton, Alberta, Canada.
Posts: 98
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I settled on the Beginning Access 97 VBA (Smith & Sussman - Wrox) and The Microsoft Access 97 Access Developers Handbook (Getz etal - Sybex) and the VBA companion book to the Sybex book as my early and ultimate references. I also bought the 2000 version of the Sybex developer's set (the pair of Access 2000 Developer's Handbook & VBA book) because I got an acknowledgment for having read and reread the 97 versions so many times that I pointed out a number of errors and suggested solutions and needed a copy to see my name in print. More than any other, these books got me started with programming in Access and are a starting point for any questions I now have.

That said, I don't think either of them is really a beginner's book for learning to use Accesss. I personally started with the Dummies book for Access 2 and later 97 and an Access 97 VBA for Dummies book as these were quite easy to digest. Microsoft Press has a number of good books for general use as well and I would suggest their book by John Viescas as a good overall introduction that doesn't get too deep into VBA programming. This book is quite detailed and covers the ground of normalization, form design, relationships, expresssions and all the basic stuff that you really should know before you start doing programming. If you search the MSDN library, they have excerpts of books and complete books available for reading online. A favorite of mine has been their Jet Programmers Reference (I didn't find it today but I'm pretty sure it's still there, I've read it at least twice and printed out everything I thought I might not remember). Another example that is pretty darn good is the 'Buuilding Applications With Access 2000' book at:

http://msdn.microsoft.com/library/de.../acbatitle.asp

If you are using a newer (or older) version of Access, it is easy to browse and search the MSDN library for pertinent references.

I spent a great deal of time in the public library and at book stores like Chapters looking at and reading books. You can frequently get excerpts from books for download and if you use a p2p file sharing application like Kazaa, you'll find tons of books for download, frequently in Word or pdf format. Many of these books are specialized and not for the beginner but I'd imagine you could find many that are. Although I prefer paper format books, I love the option of searching content online and the portability I get with the copy on CD that some books provide.

It is difficult for a beginner to distinguish between fact and fiction and there is a great deal of opinion on user support forums. While reputable books by large publishing houses are generally quite reliable, it is always wise to test alternate approaches whenever you can.

Ciao
Jürgen Welz
Edmonton AB Canada
jwelz@hotmail.com
Reply With Quote
  #8 (permalink)  
Old August 25th, 2004, 12:55 PM
Registered User
 
Join Date: Aug 2004
Location: Bethesda, MD, USA.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Normalization and basic database design: Best book for beginners and non-programmers I've read is "Database Design for Mere Mortals" by Michael J. Hernandez.
Reply With Quote
  #9 (permalink)  
Old August 26th, 2004, 08:47 AM
Registered User
 
Join Date: Aug 2004
Location: Detroit, MI, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am looking Professional Access 2000 Programming (Wrox). Does anyone knows where I might find a copy. I have someone else book. This book is very helpful for me.

Melanie Weaver
Reply With Quote
  #10 (permalink)  
Old August 28th, 2004, 07:22 AM
Authorized User
 
Join Date: Aug 2004
Location: Melbourne, Victoria, Australia.
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

franzwil's suggested is A1. Good book for general database design, methods and theory. Another book excellent for this but targeted at more of an advanced beginner/intermediate level is 'Designing Relational Database Systems' by Rebecca M. Riordan MSPRESS. Good book to progress to.

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create a reference to a .net dll from MS Access waltkrueger Pro VB.NET 2002/2003 1 November 20th, 2006 05:46 PM
Database Access (copied from books forum) Mistoffeles C# 0 November 21st, 2005 04:57 PM
Where are the books?? twister Forum and Wrox.com Feedback 6 October 7th, 2003 10:22 AM
ASP/ASP.NET Reference books shri ASP.NET 1.0 and 1.1 Basics 1 July 7th, 2003 03:20 AM



All times are GMT -4. The time now is 07:20 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.