Microsoft® Office Access 2003 Inside Out (Bpg-Inside Out) [Paperback]

John L. Viescas (Author)

Book Description

ISBN-10: 0735615136 | ISBN-13: 978-0735615137 | Publication Date: November 26, 2003

Hey, you know your way around a database—so now dig into Access 2003 and really put your information to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds all in concise, fast-answer format. It’s all muscle and no fluff. Discover the best and fastest ways to perform everyday tasks, and challenge yourself to new levels of Access mastery!

• Build on what you already know about Access and quickly dive into what’s new
• Design your database the way the experts do—and sidestep common mistakes
• Import data from spreadsheets, text files, databases, and other sources
• Write simple to sophisticated queries to manipulate data
• Learn advanced techniques for building forms and reports
• Develop PivotTable and PivotChart dynamic views
• Tap the power of Microsoft SQL Server with Access projects and views, functions, and stored procedures
• Implement database security features
• Deliver dynamic data on the Web with data access pages and XML
• Use Microsoft Visual Basic for Applications (VBA) and script to automate your applications and Web pages

CD features:

• Complete eBook in PDF format
• Insider Extras—including fully functional sample databases, VBA code, and sample web pages
• Catalog of Access resources with links to third-party tools and demos
• Microsoft resources and demos, including Insider’s Guide to Microsoft Office OneNote 2003 eBook
• Microsoft Computer Dictionary, Fifth Edition, eBook—10,000+ entries

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [e-mail].

Editorial Reviews

About the Author

John L.He is the author of numerous books, including Running Microsoft Access 2000 and Running Microsoft Access 97, and the coauthor of SQL Queries for Mere Mortals. He has written numerous articles for technical publications and has lectured at conferences and user group meetings around the world. He has been recognized as a Most Valuable Professional every year since 1993 by Microsoft Product Support Services for his assistance on public support forums.

Product Details

• Paperback: 1324 pages
• Publisher: Microsoft Press (November 26, 2003)
• Language: English
• ISBN-10: 0735615136
• ISBN-13: 978-0735615137
• Product Dimensions: 9.5 x 7.4 x 2.3 inches
• Shipping Weight: 4.4 pounds (View shipping rates and policies)
• Average Customer Review: 3.9 out of 5 stars  See all reviews (36 customer reviews)
• Amazon Best Sellers Rank: #364,298 in Books (See Top 100 in Books)

More About the Author

John L. Viescas provides database consulting for a variety of small to large businesses and corporations worldwide. He is the author of numerous books, including Running Microsoft Access 97, Running Microsoft Access 2000, Microsoft Office Access 2003 Inside Out, and Building Microsoft Access Applications (Microsoft Press). He is also the co-author of SQL Queries for Mere Mortals (Addison-Wesley). He has written numerous articles for technical publications and has lectured at conferences and user group meetings around the world. He has been recognized as a "Most Valuable Professional" every year since 1993 by Microsoft Product Support Services for his assistance on public support forums.

Customer Reviews

Most Helpful Customer Reviews

110 of 112 people found the following review helpful:

5.0 out of 5 stars This book is at the intermediate level for developers, June 16, 2004

By 

book_review_grrl "book_review_grrl" (Raleigh, NC) - See all my reviews

This review is from: Microsoft® Office Access 2003 Inside Out (Bpg-Inside Out) (Paperback)

The intended audience for this book isn't someone who just needs to use a Microsoft Access Database. Instead, this book is for someone who knows Access basics and understands databases and wants to create their own database - or perhaps their own application - including possibly using Visual Basic programming or macros. If this is you, then this book is GREAT! Doesn't bother you with the tiny details, but gives you what you need to get moving on your project, including how to prevent users from tinkering with your form design, how to fine tune your database/application using the performance analyzer, and other ideas to put together a high-quality database or application. (The reason why some reviewers have rated the book lower, is that they were probably outside the targeted audience, and the material was therefore less appropriate for them.)

34 of 37 people found the following review helpful:

3.0 out of 5 stars Thorough but Dry, January 21, 2006

By 

John A Lee III "jal3" (San Antonio, TX) - See all my reviews
(REAL NAME)   

This review is from: Microsoft® Office Access 2003 Inside Out (Bpg-Inside Out) (Paperback)

There is no doubt that the Inside Out series from Microsoft is a much superior source for learning than the Step By Step Series. Topics are covered with more thoroughness which includes theory, reasons for doing things in a certain way and a better understanding of various possible parameters. That necessarily equates to a bulkier tome but the information is worth the weight. Unfortunately, others can produce the information in a more inspired and interesting manner.

This book is thorough. Anyone wishing to learn about Access 2003 would be well served by its use. It comes with examples on disk and a well thought out sequential development that builds on previous lessons. The only problem is staying awake. The illustrations are plentiful but tend to be small and difficult to read but the correspond well to what actually appeared on my screen. That is often not the case. This is a good choice but there are better ones. I like this one mostly as a reference. There are better references out there too.

17 of 17 people found the following review helpful:

5.0 out of 5 stars MS Access 2003 Inside Out, March 23, 2004

By 

Wayne "comprev" (Fort Worth, TX United States) - See all my reviews

This review is from: Microsoft® Office Access 2003 Inside Out (Bpg-Inside Out) (Paperback)

John has done a great job with this book. It is in plain language that a beginner in Access would be able to understand. It includes lots of screen shots and descriptions of why things need to be done the recommended way. It also has good technical detail for the more advanced user. Following the procedures in this book will definitely improve your database application.