If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Book recommendations, please
I have been fooling around with Access on and off for a couple of
years -- mostly simple applications with only a few tables and simple relationships. I know the basics for the most part and I have a general awareness of relational concepts, but I don't feel that I really fully understand database design. So, I'd like to get a couple of books to study so I can get a better comprehension of the design concepts. I am about to tackle some slightly more complex applications and I would like to do them based on sound principles. Here are several books I have heard about. Database Design for Mere Mortals by Michael Hernandez, John Viescas, Addison Wesley (2003). Designing Effective Database Systems by Rebecca Riordan, Microsoft Press, (2005) Inside Relational Databases by Mark Whitehorn, Bill Marklyn, Springer-Verlag (2001) Any comments on these or other recommendations? Then I think I would like a book or two on using Access in particular including UI and form design and other Access-specific tips and tricks. The books I have heard about in this area a Access 2002 Developer's Handbook Set by Paul Litwin, Ken Getz, Mike Gunderoy, Sybex (2001) Alison Balter's Mastering Access 2002 Desktop Development by Alison Balter, Sams (2001) Access 2003 Bible by Cary Prague, Michael Irwin, Jennifer Readron, Wiley (2003) Access Cookbook, 2nd Edition by Ken Getz, Paul Litwin, Andy Baron, O'Reilly (2004) Building Microsoft Access Applications by John Viescas, Microsoft Press (2005) Microsoft Office Access 2003 Inside Out by John Viescas, Microsoft Press (2003) Using Microsoft Access 2003 by Roger Jennings, Que (2003) Microsoft Access 2003 Step-by-Step by Microsoft Press (2003) Thanks -- Running MS Office 2K Pro PC: HP Omnibook 6000 OS: Win 2K SP-4 (5.00.2195) Email: Usenet-20031220 at spamex.com (11/03/04) |
#2
|
|||
|
|||
"Top Spin" wrote in message ... I have been fooling around with Access on and off for a couple of years -- mostly simple applications with only a few tables and simple relationships. I know the basics for the most part and I have a general awareness of relational concepts, but I don't feel that I really fully understand database design. So, I'd like to get a couple of books to study so I can get a better comprehension of the design concepts. I am about to tackle some slightly more complex applications and I would like to do them based on sound principles. Here are several books I have heard about. Database Design for Mere Mortals by Michael Hernandez, John Viescas, Addison Wesley (2003). Designing Effective Database Systems by Rebecca Riordan, Microsoft Press, (2005) Inside Relational Databases by Mark Whitehorn, Bill Marklyn, Springer-Verlag (2001) Any comments on these or other recommendations? Some handy sites: http://www.utexas.edu/its/windows/da...ing/index.html http://www.datamodel.org/ Access 2002 Developer's Handbook Set by Paul Litwin, Ken Getz, Mike Gunderoy, Sybex (2001) Yes, very good. Access Cookbook, 2nd Edition by Ken Getz, Paul Litwin, Andy Baron, O'Reilly (2004) Quite handy, but not universally applicable. Contains solutions to common problems by category. |
#3
|
|||
|
|||
Here is some books and links that have helped me. There
are more I am sure Beginning Access {YourVersion} VBA" by Smith & Sussman Access Developer's Handbook. http://mspress.microsoft.com/office/office2000/dev.htm Designing Relational Database Systems", by Rebecca Riordan, from Microsoft Press. Currently out of print, if you see a used copy anywhere, grab it, quick. Beginning Access version VBA Programming", from Wrox Press (where version might be 97, 2000, or 2002) Programming Microsoft Access Version version" by Rick Dobson, from Microsoft Press Access version Developer's Handbook", from Sybex. (The Access 97 edition was one volume, later editions are in two volumes, both equally indispensable) Access DevelopersHandbook", Volume 1 and 2, authored by Getz and company, published by SYBEX. Using Microsoft Access 2000", Roger Jennings, Que Corp, 0-7897-1606-2 ACCESS 2002 Bible 'Microsoft Access Database Protection and Security" http://www.apress.com/book/bookDisplay.html?bID=3D189 or http://www.fmsinc.com/toplevel/books.htm or FMS Professional Solutions Group http://www.fmsinc.com/consulting or Software Tools for .NET, SQL Server, Visual Basic & Access http://www.fmsinc.com or=20 "Running Microsoft Access 2000" by John Viescas is a great overview type book, with an accompaanying CD with samples and examples that are referred to in the book. Microsoft=AE Office Access 2003 Step by Step http://www.microsoft.com/products/in...2&pcid=3D643a= bc7f-ec43-95dc-3193-01899113eab5&type=3Dovr Microsoft=AE Office Access 2003 Inside Out http://www.microsoft.com/products/in...2&pcid=3D47cd= 483c-3662-0d9b-472d-60d3c217acef&type=3Dovr Ken Getz, et. al - Access Developer's Handbook http://tinyurl.com/392ke and F. Scott Barker's Access Power Programming http://tinyurl.com/2u7er http://www.viescas.com/Info/books.htm#Database%20Design. Books (alphabetical order by author) : Mastering Access (insert version #) Alison Balter Beginning Access 2000 VBA by Sussman and Smith Running Access (insert version #) by Viescas The Access Developer Handbook (by Litwin, Getz, et. al.)=20 is an essential book for Access developers. However, a beginner might find it a bit intimidating; I know I do! If I had to pick just one... it would be Running Access by Viescas.. Others might have different (and equally valid!) recommendations.. See the recommended lists by John Viescas: http://www.viescas.com/Info/books.htm or the one by FMS Inc: http://www.fmsinc.com/toplevel/books.htm For SQL Server, I use Kalen Delaney's Inside Microsoft SQL Server 2000 but I have not used other books so I can't say which one is best but Kalen Delaney's suit my purpose at the moment. There are plenty of SQL Server books so you can browse at a well-stocked bookshop. Web Sites: www.mvps.org/access/ The motherlode! users.bigpond.net.au/abrowne1/tips.html www.lebans.com www.granite.ab.ca/accsmstr.htm members.rogers.com/douglas.j.steele/AccessIndex.html www.rogersaccesslibrary.com/ This is a short list of sites that come quickly to mind; there are many more! In addition, I would also strongly suggest the rest of the Microsoft Access newsgroups at: microsoft.public.access... etc.. More than anything else, I have found the free answers offered by kind experts in relevant newsgroups to be invaluable. I have had hundreds of questions answered over the last year or two, and continue to be grateful! Finally you might find the following useful (and possibly humorous!)... http://www.mvps.org/access/tencommandments.htm Chris -----Original Message----- I have been fooling around with Access on and off for a couple of years -- mostly simple applications with only a few tables and simple relationships. I know the basics for the most part and I have a general awareness of relational concepts, but I don't feel that I really fully understand database design. So, I'd like to get a couple of books to study so I can get a better comprehension of the design concepts. I am about to tackle some slightly more complex applications and I would like to do them based on sound principles. Here are several books I have heard about.=20 Database Design for Mere Mortals by Michael Hernandez, John Viescas, Addison Wesley (2003).=20 Designing Effective Database Systems by Rebecca Riordan, Microsoft Press, (2005) Inside Relational Databases by Mark Whitehorn, Bill Marklyn, Springer-Verlag (2001) Any comments on these or other recommendations? Then I think I would like a book or two on using Access in particular including UI and form design and other Access-specific tips and tricks. The books I have heard about in this area a Access 2002 Developer's Handbook Set by Paul Litwin, Ken Getz, Mike Gunderoy, Sybex (2001) Alison Balter's Mastering Access 2002 Desktop Development by Alison Balter, Sams (2001) Access 2003 Bible by Cary Prague, Michael Irwin, Jennifer Readron, Wiley (2003) Access Cookbook, 2nd Edition by Ken Getz, Paul Litwin, Andy Baron, O'Reilly (2004) Building Microsoft Access Applications by John Viescas, Microsoft Press (2005) Microsoft Office Access 2003 Inside Out by John Viescas, Microsoft Press (2003) Using Microsoft Access 2003 by Roger Jennings, Que (2003) Microsoft Access 2003 Step-by-Step by Microsoft Press (2003) Thanks --=20 Running MS Office 2K Pro PC: HP Omnibook 6000 OS: Win 2K SP-4 (5.00.2195) Email: Usenet-20031220 at spamex.com (11/03/04) . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
2 contacts folders | Larry Tackett | Contacts | 21 | October 21st, 2005 12:45 PM |
Excel Address Book | Paul | General Discussion | 0 | November 16th, 2004 08:07 PM |
address book | Ken | Outlook Express | 3 | September 7th, 2004 05:16 AM |
recover my Windows Address Book | mike | Outlook Express | 1 | June 6th, 2004 05:22 AM |
Book recommendations | ExcelMan | New Users | 1 | May 23rd, 2004 05:50 AM |