Special Edition Using Microsoft Office Access 2003

Overview

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 ...

See more details below
Paperback
$48.02
BN.com price
(Save 19%)$59.99 List Price
Other sellers (Paperback)
  • All (32) from $1.99   
  • New (9) from $1.99   
  • Used (23) from $1.99   
Sending request ...

Overview

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.

Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
Enterprise databases get most of the publicity, but you can do surprisingly powerful stuff with desktop databases, and they keep getting better all the time.

Take, for instance, Microsoft’s brand new-release of Access. In addition to many smaller improvements, Access 2003 adds powerful new support for XML and for collaboration via Microsoft’s SharePoint services and portals.

That’s built on top of a robust database platform that can be used either to build apps for Access’ traditional Jet engine or as a front end to SQL Server 2000, for serious scalability. Want web apps? No sweat.

If you want to really learn Access 2003 in depth, check out Roger Jennings’s Special Edition Using Microsoft Office Access 2003. The latest in a series that’s taught Access to nearly a million users and developers, this book is polished, sophisticated, and (at roughly 1,500 pages) extremely thorough.

After a quick overview of what’s new, Jennings follows the path a real developer might take. You’ll start by building an extremely simple desktop and web application using the Database Wizard before exploring that application, the Access interface, and Access’ approach to application design.

Then, it’s on to a far deeper look at database building. Jennings guides you step-by-step through designing tables, adding and importing data, designing and executing queries, designing data entry forms and printed reports, and much more.

Of course, this edition contains extensive new coverage of XML. There’s a full chapter on exporting and importing XML data: using XML as a data interchange format; moving to XML-based Web front-ends; using ReportML; exporting queries to XML; analyzing exported XML schema; returning XML documents from HTTP queries; applying style sheets and XSL transforms; and more.

An equally detailed chapter focuses on consuming and providing XML-based web services. Jennings starts with an overview of the concepts and vocabulary (great for power users and traditional database developers); then introduces handy new tools such as .NET WebService Studio and SQLXML.

Also new and especially worth noting: Jennings’s coverage of Access integration with InfoPath, Microsoft’s new tool for creating rich, dynamic XML–based forms; and, more briefly, with SharePoint.

Every chapter ends with an “In the Real World” section, in which Jennings gets to offer even deeper insights. That’s where you’ll get Jennings’s assessment of exactly where the traditional Access Jet engine is likely to run out of steam -- and when you should start from scratch, targeting MSDE or SQL Server. It’s also where you’ll get expert tips on the art and science of query design. As Jennings wryly observes, Microsoft’s practice Northwind database is unrealistically small, hence generating unrealistically good performance. “The nine-person Northwind Traders sales force produced only 830 orders over a span of almost two years, indicating a serious lack of sales productivity.” To really get some practice, set aside 15MB for the big database Jennings provides on CD-ROM.

There’s not much missing from Special Edition Using Microsoft Office Access 2003. It’ll keep you busy building databases for years. 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: 9780789729521
  • Publisher: Que
  • Publication date: 7/31/2003
  • Series: Special Edition Using Series
  • Pages: 1502
  • Product dimensions: 7.50 (w) x 9.00 (h) x 2.25 (d)

Meet the Author

Shelley O'Hara is the author of more than 100 books, including several best-sellers. She has also authored business plans, a novel, Web content, marketing publications, short stories, training materials, magazine columns, a newsletter, and software manuals. She has written on topics ranging from Microsoft Windows to the International Air Transport Authority ticketing system, from Microsoft Office to buying a home. In addition to writing, O'Hara teaches training and personal development classes in Indianapolis.

Read More Show Less

Table of Contents

Introduction.

1. Learning Access Basics.

Database Window. Starting Access. Opening a Sample Database. Using the Menu Bar. Using Toolbars. Using the Objects Bar. Getting Help. Closing a Database. Quitting Access.

2. Creating Databases and Tables.

Creating a Database from a Template. Creating a New Blank Database. Opening an Existing Database. Creating a Table Using a Wizard. Creating a Database Table from Scratch. Displaying a Table in Design View. Adding a New Field. Changing a Field Name. Setting a Field's Data Type. Setting the Field Size for a Text Field. Setting the Field Size for a Number Field. Adding a Field Description. Deleting a Field. Setting the Primary Key. Saving the Data Table.

3. Entering Data.

Opening and Closing a Table in Datasheet View. Entering Data in a Table. Displaying Records. Creating a New Record. Selecting an Entry. Selecting Records and Columns. Freezing and Unfreezing Columns. Hiding and Unhiding Columns. Resizing Columns. Rearranging Columns. Editing a Record. Deleting a Record. Copying an Entry. Copying an Entire Record. Sorting Records in Datasheet View. Finding Data. Replacing Data. Formatting the Datasheet. Changing the Font. Checking Spelling. Previewing and Printing a Table.

4. Editing a Database's Table Structure.

Viewing Field Properties. Using Display Formats. Using an Input Mask. Adding a Field Caption. Entering a Default Value. Requiring an Entry. Indexing a Field. Applying a Smart Tag. Creating a Yes/No Field. Creating a Hyperlink Field. Creating a Memo Field. Creating an Object Field. Adding an Entry to an Object Field.

5. Creating and Using Forms.

Creating a Form Using an AutoForm. Creating a Form Using a Wizard. Saving a Form. Opening a Form. Using a Form to Add a New Record. Using a Form to Display Records. Using a Form to Edit Data. Using a Form to Select Records. Using a Form to Delete a Record. Using a Form to Search for a Record. Filtering Data by Selection. Filtering Data by Form. Viewing a Form in Design View. Selecting a Form Control. Deleting a Field from a Form. Resizing a Form Control. Moving a Form Control. Adding a Field to a Form. Changing the Tab Order. Viewing and Formatting Form Controls. Formatting Forms.

6. Creating Queries.

Creating a Select Query with a Wizard. Building a Query from Scratch. Viewing the Query Design. Entering Criteria to Query for an Exact Match. Entering Criteria to Query for a Range of Matches. Entering Multiple Criteria with the OR Operator. Entering Criteria to Match More Than One Field. Sorting Query Results. Adding a Field to a Query. Removing a Field from a Query. Saving a Query. Running a Query. Creating a New Table with Query Results. Deleting Records with a Query.

7. Creating Reports.

Creating an AutoReport. Creating a Report Using a Wizard. Saving a Report. Opening a Report. Viewing a Report's Design. Selecting a Report Control. Deleting a Field from a Report. Resizing a Report Control. Moving a Report Control. Adding a Field to a Report. Adding Labels to a Report. Adding Headers or Footers to a Report. Drawing on a Report. Adding a Picture to a Report. Sorting and Grouping Data in a Report. Using a Report AutoFormat. Setting Up the Page. Previewing a Report. Printing a Report.

8. Managing Your Database.

Renaming an Object. Deleting an Object. Password-Protecting a Database. Backing Up the Database. Viewing Database Properties. Setting Up Relationships. Editing Relationships. Using Subdatasheets.

Glossary.

Index.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

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

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