Access 2003 Bible

( 6 )

Overview

  • The most comprehensive reference on this popular database management tool, fully updated with the new features of Access "X" including increased use of XML and Web services
  • Explores the new, tighter integration with SharePoint and BizTalk in Office "X" that enables greater flexibility for gathering and manipulating data
  • Written by an international bestselling author team with several books to their credit, ...
See more details below
Paperback (BK&CD-ROM)
$37.34
BN.com price
(Save 25%)$49.99 List Price
Other sellers (Paperback)
  • All (56) from $1.99   
  • New (7) from $22.95   
  • Used (49) from $1.99   
Sending request ...

Overview

  • The most comprehensive reference on this popular database management tool, fully updated with the new features of Access "X" including increased use of XML and Web services
  • Explores the new, tighter integration with SharePoint and BizTalk in Office "X" that enables greater flexibility for gathering and manipulating data
  • Written by an international bestselling author team with several books to their credit, including previous editions of Access Bible
  • Gets Access beginners started with hundreds of examples, tips, and techniques for getting the most from Access
  • Offers advanced programming information for serious professionals
  • CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach's Power Utility Pak
Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
Microsoft Access 2003 doesn’t have to be intimidating. The authors of Access 2003 Bible have come up with a masterful approach to teaching it. Invest some time with them, and you’ll be rewarded with deep enough mastery to accomplish virtually anything.

The authors have updated this book’s organization and content with great care. You’ll first learn the core database development techniques that apply regardless of your environment -- beginning with a top-down, seven-step design process covering everything from overall system design to menus.

In this context, the authors introduce a sample application, Access Auto Auctions, which serves as a framework for everything that follows.

Later, once you’ve systematically learned the key techniques of desktop database development, the authors show how to “upsize” your application for enterprise environments that require industrial-strength performance...and after that, how to extend your applications onto the Web.

That’s the high-level plan -- now for the details. The authors begin with essential definitions and questions: What’s a database? What are tables? Records? Fields? Values? Datasheets? Dynasets? Queries? What’s involved in designing a database? What happens if you don’t do it well? Why is it usually helpful to have multiple tables in your database?

Next, you’ll take a close look at each step you’ll need to follow to get from “idea” to efficient database. The authors offer examples of defining what your database must do (for example, maintain contact info, produce mailing labels); designing reports; organizing data; designing tables and relationships; providing for data entry and validation; and creating a Switchboard that helps users navigate your application.

Throughout the rest of Part I, you’ll walk through every aspect of data tables, from data entry through basic queries and using external data. Next, the authors truly systematic coverage of forms and reports, from the basics (building forms with Wizards) through subforms, calculations, summaries, special report types, ActiveX controls, graphs, and Pivot Objects.

There’s a nine-chapter section on automating your applications -- covering everything from VBA to ADO and SQL, even programmed error routines.

Once you’ve got a pretty solid application, the authors show how to upsize it. You’ll walk through creating an Access Data Project that leverages the front end you’ve already created, while using a more powerful, scalable back-end -- either the pricey SQL Server or the freebie Microsoft Data Engine (MSDE). There’s even a chapter on stored procedures and triggers.

When you’re ready to move your application to the Web, three chapters give you a strong grounding in Microsoft’s Data Access Pages (DAP), as well as Access 2003’s enhanced XML support. The book wraps up with wide-ranging advanced coverage -- everything from security to performance optimization, help systems to Access Developer’s Edition.

All the sample files you need are on the accompanying CD-ROM, along with a bundle of bonus content, including sample chapters from each of Wiley’s new Office 2003 Bibles, plus bonus third-party software. (A bonus for Excel users: John Walkenbach’s Power Utility Pak.) Bill Camarda

Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks for Dummies, Second Edition.

Read More Show Less

Product Details

  • ISBN-13: 9780764539862
  • Publisher: Wiley
  • Publication date: 9/5/2003
  • Series: Bible Series , #45
  • Edition description: BK&CD-ROM
  • Edition number: 1
  • Pages: 1464
  • Sales rank: 808,743
  • Product dimensions: 7.40 (w) x 9.20 (h) x 2.00 (d)

Meet the Author

Cary N. Prague is an internationally best-selling author and lecturer in the database industry. He owns Database Creations, Inc., the world’s largest Microsoft Access add-on company. Their products include a line of financial software; Business! For Microsoft Office, a mid-range accounting system, POSitively Business! Point of Sale software, the Inventory Barcode manager for mobile data collection, and the Check Writer and General Ledger. Database Creations also produces a line of developer tools including the appBuilder, an application generator for Microsoft Access, the EZ Access Developer Tools for building great user interfaces, appWatcher for maintaining code bases among several developers, and Surgical Strike, the only Patch Manager for Microsoft Access.
Cary also owns Database Creations Consulting, LLC., a successful consulting firm specializing in Microsoft Access and SQL Server applications. Local and national clients include many Fortune 100 companies including manufacturers, defense contractors, insurance, health-care, and software industry companies. His client list includes Microsoft, United Technologies, ABB, Smith & Wesson Firearms, Pratt and Whitney Aircraft, ProHealth, OfficeMax, Continental Airlines, and other Fortune 500 companies.

Michael R. Irwin is considered one of the leading authorities on automated database and Internet management systems today. He is a noted worldwide lecturer, a winner of national and international awards, best-selling author, and developer of client/server, Internet, Intranet, and PC-based database management systems.
Michael has extensive database knowledge, gained by working with the Metropolitan Police Department in Washington, D.C. as a developer and analyst for the Information Systems Division for over 20 years and assorted Federal Agencies of the United States Government. Since retiring in June 1992, he runs his own consulting firm, named The Irwin Group, and is principal partner in the company - IT in Asia, LLC, specializing in Internet database integration and emphasizing Client/Server and net solutions. With consulting offices in Cincinnati, Ohio, Bangkok, Thailand, and Manila, Philippines, his companies offer training and development of Internet and database applications. His company has the distinction of being one of the first Microsoft Solution’s Providers (in 1992). His local, national, and international clients include many software companies, manufacturers, government agencies, and international companies.

Jennifer Reardon is considered a leading developer of custom database applications. She has over ten years’ experience developing client/server and PC-based applications. She has accumulated much of her application development experience working as lead developer for Database Creations. She has partnered with Cary Prague developing applications for many Fortune 500 companies.
Her most significant projects include a spare parts inventory control system for Pratt & Whitney’s F22 program, an engineering specifications system for ABBCombustion Engineering, and an emergency event tracking system for the State of Connecticut. She was also the lead developer of many of the Database Creations add-on software products including Business, Yes! I Can Run My Business, Check Writer, and the User Interface Construction Kit.

Read More Show Less

Table of Contents

Preface.

Acknowledgments.

Part I: Creating Desktop Applications.

Section I: Working with Data Tables and Queries.

Chapter 1: Understanding Data.

Chapter 2: Creating and Building Tables.

Chapter 3: Entering Data into Tables and Forms.

Chapter 4: Creating and Understanding Relationships.

Chapter 5: Displaying Selected Data with Queries.

Chapter 6: Using Operators and Expressions in Multi-table Select Queries.

Chapter 7: Working with External Data.

Section II: Building Forms and Reports.

Chapter 8: Understanding the Many Uses of Forms and Controls.

Chapter 9: Building and Manipulating Forms and Controls.

Chapter 10: Creating Bound Forms and Placing Controls.

Chapter 11: Adding Data-Validation Features to Forms.

Chapter 12: Creating Professional-Looking Forms and Reports.

Chapter 13: Understanding and Creating Reports.

Chapter 14: Working with Subforms.

Chapter 15: Creating Calculations and Summaries in Reports.

Chapter 16: Presenting Data with Special Report Types.

Chapter 17: Using OLE Objects, Graphs, Pivot Tables/Charts, and ActiveX Controls.

Section III: Automating Your Applications.

Chapter 18: Understanding Visual Basic and the VBA Editor.

Chapter 19: Introduction to Programming and Events.

Chapter 20: Working with Expressions and Functions.

Chapter 21: Working with SQL, Recordsets, and ADO.

Chapter 22: Automating, Searches, Filters, and Query Parameters.

Chapter 23: Calling Subprocedures and Functions.

Chapter 24: Effective Debugging and Error Handling in VBA.

Chapter 25: Creating Switchboards, Command Bars, Menus, Toolbars, and Dialog Boxes.

Chapter 26: Programming Continuous Forms, Tab Dialogs, and Command Buttons.

Part II: Creating Enterprise Applications.

Section IV: Upsizing to SQL Server and MSDE 2000.

Chapter 27: Upsizing Data to a SQL Server Database.

Chapter 28: Working with Access Projects.

Chapter 29: Working with Access Projects and SQL Server Tables and Queries.

Part III: Creating Web Applications.

Section V: Creating Data Access Pages and Using XML and InfoPath.

Chapter 30: Using and Creating Access Objects for Intranets and the Internet.

Chapter 31: Building and Working with Data Access Pages.

Chapter 32: XML, Access, and InfoPath.

Part IV: Advanced Access Database Topics.

Chapter 33: Exchanging Data with Office Applications.

Chapter 34: Adding Security to Applications.

Chapter 35: Creating Help Systems.

Chapter 36: Working with Advanced Select Queries and Other Query Topics.

Chapter 37: Working with Action and SQL Queries.

Chapter 38: Increasing the Speed of an Application.

Chapter 39: Preparing Your Application for Distribution.

Part V: Appendixes and Reference Material.

Appendix A: Access 2003 Specifications.

Appendix B: Access Auto Auction Tables.

Appendix C: Using the CD-ROM Included with the Book.

Appendix D: Using Standard Naming Conventions.

Index.

Read More Show Less

Customer Reviews

Average Rating 2.5
( 6 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(1)

2 Star

(3)

1 Star

(1)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 6 Customer Reviews
  • Anonymous

    Posted May 11, 2009

    No text was provided for this review.

  • Anonymous

    Posted February 8, 2009

    No text was provided for this review.

  • Anonymous

    Posted November 24, 2010

    No text was provided for this review.

  • Anonymous

    Posted April 10, 2010

    No text was provided for this review.

  • Anonymous

    Posted March 2, 2009

    No text was provided for this review.

  • Anonymous

    Posted June 5, 2009

    No text was provided for this review.

Sort by: Showing all of 6 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)