Special Edition Using Microsoft Office Access 2003 [Paperback]

Roger Jennings (Author)

Book Description

ISBN-10: 0789729520 | ISBN-13: 978-0789729521 | Publication Date: September 21, 2003 | Edition: Special

Special Edition Using Microsoft Office Access 2003 is a comprehensive reference for all the features of Access 2003. This edition adds new chapters on collaboration with Microsoft SharePoint Team Server, and creating or consuming XML Web Services, both of which are hot topics. The XML chapter includes Access 2003¿s new XML export/import features.

The book¿s organization follows the development process for typical Access database applications. Detailed, step-by-step instructions with icons guide those who are new to Access through table design, data addition, importing data from external sources, query design and execution, and designing data entry forms and printed reports. Chapters on advanced form and report design emphasize data-entry efficiency and presentation clarity.

Editorial Reviews

Amazon.com Review

Billed as "The only Access 2003 book you need," Special Edition Using Microsoft Office Access 2003 is a comprehensive reference book that may well live up to its slogan. It covers all aspects of Microsoft's small but powerful database environment, from user-level features to Transact-SQL, Active Data Objects (ADO), and InfoPath. While you probably will want a separate reference for Visual Basic for Applications (VBA), or whatever programming environment you're using, this book indeed comprehensive in terms of Access 2003 itself. Coverage of T-SQL is particularly helpful, thanks to the author's extensive use of illustrative examples in those sections. Further, he takes care to help readers prepare for the imminent retirement of the Jet database engine and the required migration for Microsoft SQL Server.

Roger Jennings' coverage of the user-level part of Access (the editing, formatting, and design functions, and the wizards that make them easier to use) is standard Que fare, full of carefully indexed procedures and lots of hints and tips that call attention to potential problems and obscure capabilities. Later chapters--the ones that will be of greater interest to people doing application-development work--rely more heavily (and appropriately so) on code snippets and explanations of what they do. Even in the more programmer-oriented sections, though, there are numbered steps to follow in order to achieve desired effects, such as exporting data to XML and setting up an InfoPath form. --David Wall

Topics covered: User- and developer-level traits and capabilities of Microsoft Access 2003. Emphasis falls on relational database design, data entry and validation techniques, form design, sorting and reporting, CrossTabs and PivotTables, and Transact-SQL. There's coverage of the differences between the Jet database engine and the Microsoft SQL Server database environment, and notes on developing applications for both.

From the Back Cover

Special Edition Using Microsoft Office Access 2003 is a comprehensive reference for all the features of Access 2003. This edition adds new chapters on collaboration with Microsoft SharePoint Team Server, and creating or consuming XML Web Services, both of which are hot topics. The XML chapter includes Access 2003's new XML export/import features.

The book's organization follows the development process for typical Access database applications. Detailed, step-by-step instructions with icons guide those who are new to Access through table design, data addition, importing data from external sources, query design and execution, and designing data entry forms and printed reports. Chapters on advanced form and report design emphasize data-entry efficiency and presentation clarity.

See all Editorial Reviews

Product Details

• Paperback: 1502 pages
• Publisher: Que; Special edition (September 21, 2003)
• Language: English
• ISBN-10: 0789729520
• ISBN-13: 978-0789729521
• Product Dimensions: 9.1 x 7.4 x 2.1 inches
• Shipping Weight: 4.8 pounds (View shipping rates and policies)
• Average Customer Review: 3.6 out of 5 stars  See all reviews (8 customer reviews)
• Amazon Best Sellers Rank: #931,273 in Books (See Top 100 in Books)

More About the Author

I'm the principal consultant of OakLeaf Systems, a Windows Azure MVP and the author of 30+ books on Microsoft operating systems (Windows NT and Windows 2000 Server), Windows Azure, databases (SQL Server, SQL Azure and Access), .NET data access, Web services and InfoPath 2003. The books have more than 1.25 million English copies in print and have been translated into 20+ languages.

My latest books are "Microsoft Access 2010 In Depth" (12th edition) for Que Publishing and "Cloud Computing with the Microsoft Azure Services Platform" for Wiley/Wrox.

I'm also the curator of the OakLeaf Systems (http://oakleafblog.blogspot.com) and Access In Depth (http://acccessindepth.blogspot.com) blogs, a contributing editor of 1105 Media's "Visual Studio Magazine" and a frequent contributor to their "Redmond Developer News" newsletter.

OakLeaf's Code of Federal Regulations (CFR) Web service won the charter Microsoft .NET Best award for horizontal XML Web service solutions.

Customer Reviews

Most Helpful Customer Reviews

22 of 24 people found the following review helpful:

4.0 out of 5 stars Unfinished Editing, May 11, 2004

By A Customer

Amazon Verified Purchase

This review is from: Special Edition Using Microsoft Office Access 2003 (Paperback)

Although this book is very good, as are most Que books, it appears that the book wasn't totally re-done for Access 2003.

There are numerous sections in the book that discuss the new features of Access 2002 (not 2003).

16 of 19 people found the following review helpful:

2.0 out of 5 stars A lot of how, not enough why, March 14, 2005

By 

Nora Brown "Nora Brown Design" (Boston, MA, USA) - See all my reviews
(REAL NAME)   

This review is from: Special Edition Using Microsoft Office Access 2003 (Paperback)

This book is not for beginners, and may not be for anybody. It is poorly indexed, making it very difficult to find a desired topic. It is also largely based on step-by-step examples, without enough explanation of why something works the way it does. In other words, plenty of detail on specific, pre-determined tasks, but scant exploration of broad topics and ideas.

19 of 24 people found the following review helpful:

5.0 out of 5 stars This book did not disappoint it's readers!, October 9, 2003

By 

amazingoffers (Aurora, IL United States) - See all my reviews

This review is from: Special Edition Using Microsoft Office Access 2003 (Paperback)

This amazing edition offers authoritative instruction from Roger Jennings, the author of this book, a recognized Access expert with years of Access and client/server database experience. The book's organization follows the development process for typical Access database applications. Detailed, step-by-step instructions with icons guide readers new to Access through table design, data addition, importing data from external sources, query design and execution, and designing data entry forms and printed reports. Chapters on advanced form and report design emphasize data-entry efficiency and presentation clarity...

***This book also has new chapters on collaboration with Microsoft SharePoint Team Server, and creating or consuming XML Web services, both of which are hot topics. Another great thing about this book is, the accompanying CD! .CD includes all the book's Access queries, forms, reports, VBA code, projects, data access pages, and XML Web services; SQL Server/MSDE and Jet 4.0 versions of the Beckwith and OakLeaf Consumer Electronics (OCE) sample databases; Online transaction performance test application for MSDE and SQL Server 2000; Demonstration versions of third-party Access utilities. Web-based elements include live, data-intensive XML Web services that readers can use to test Access Web service consumers. This book did not disappoint it's readers!