Microsoft Office Access 2003: The Complete Reference

( 1 )

Overview

The Definitive Resource on Access 2003

CD-ROM contains quick reference section on Access 2003—plus sample database files that support the book's material

Scale mountains of data with a single application with the help of this comprehensive resource. Through detailed, step-by-step instructions, you'll learn how to design and build custom Access databases, even with limited computer knowledge. Gather, organize, and analyze data more effectively ...

See more details below
Paperback
$30.21
BN.com price
(Save 24%)$39.99 List Price
Other sellers (Paperback)
  • All (20) from $1.99   
  • New (4) from $29.35   
  • Used (16) from $1.99   
Sending request ...

More About This Book

Overview

The Definitive Resource on Access 2003

CD-ROM contains quick reference section on Access 2003—plus sample database files that support the book's material

Scale mountains of data with a single application with the help of this comprehensive resource. Through detailed, step-by-step instructions, you'll learn how to design and build custom Access databases, even with limited computer knowledge. Gather, organize, and analyze data more effectively than ever, and build a highly responsive database that will put your information to work for you. Streamline your work with wizards, queries, and sorting and filtering methods. Secure remote functioning, online use, and multiple party access. Microsoft Office Access 2003: The Complete Reference will help you build comprehensive information management solutions.

  • Understand all the Access functions—including all the featurs of the 2003 upgrade
  • Retrieve information quickly from existing databases
  • Construct a database to serve your needs efficiently
  • Integrate Access with the rest of the Microsoft Office 2003 suite
  • Raise productivity and decision efficiency based on analysis of data trends and relationships
  • Create advanced queries to extract and manipulate specific information
  • Improve database performance with macros, customization, and faster information distribution
Read More Show Less

Editorial Reviews

Library Journal
Expect demand for guides on components of the newest version of Microsoft Office, as workplaces begin upgrading and PC manufacturers begin bundling. For medium and larger public libraries, the three entries in the "Top 100" series will make useful supplements for patrons who are comfortable with the basics of earlier Office versions; most of the content is not unique to v.2003. Each book contains illustrated, step-by-step tips to make tasks easier, shows advanced ideas, and demonstrates new features. Difficulty levels of each are noted, and "Did You Know?" sections add extra information. Word includes tips ranging from creating custom images for bullets to using an Outlook address on a Word-printed envelope, while Excel furnishes basic keyboard shortcuts and information on converting work sheets into lists, among other things. Office clues readers into areas like customizing menus and toolbars and converting Access forms or reports to web pages; appendixes cover keyboard shortcuts and a brief introduction to Picture Manager. For all libraries, the two updated Visual QuickStart titles are typically screenshot and step-by-step-instruction heavy; tips offer extra guidance. Outlook's introduction lists new features in each Outlook version from 1998 to 2003, an appendix explains program configuration, and the rest of the book covers common functions and tasks. Its index leaves something to be desired, e.g., there is no entry under "Viruses," although a section does discuss viruses and blocked email attachments; the text's coverage of some new 2003 features is also lacking. Not an essential purchase. Word's introduction highlights new and improved features, the text covers everything from text formatting basics to customizing Word's features, and its appendix covers menus and keyboard shortcuts; clear and recommended for beginners to intermediate users. More thorough than the QuickStart Outlook guide, How To Do provides clear explanations of why and how features work, tips and sidebars for further information, and step-by-step instructions on completing common tasks. It also discusses new features, e.g., the Research Pane; recommended for all libraries. Show Me takes a whirlwind tour of Office programs, employing common tools and features and using programs together. Task-based chapters provide a nice overview of the basics of each program; appendixes outline Office Specialist exams and contain a troubleshooting, question-based index to answers in the text. Step-by-step instructions, extensively labeled screen shots, added information tips, and See Also notes make this a useful introduction. For adventuresome beginners to advanced users, Complete Reference begins with a summary of new features, moves on to the typical explanation of the interface and of relational databases in general, and then goes through various applications. The CD holds sample files and a "quick reference" in PDF format; exercises assist in self-study. For larger libraries. Copyright 2004 Reed Business Information.
Read More Show Less

Product Details

  • ISBN-13: 9780072229172
  • Publisher: McGraw-Hill Professional Publishing
  • Publication date: 9/4/2003
  • Series: Osborne Complete Reference Series
  • Edition number: 2
  • Pages: 1024
  • Product dimensions: 7.30 (w) x 9.00 (h) x 1.99 (d)

Meet the Author

Virginia Andersen (Coronado, CA) is a freelance author and writer who has written or contributed to nearly 25 books about PC-based applications, including many student tutorials and accompanying instructor manuals with exercise disks. Virginia is certified as a Microsoft Access MOUS Expert.

She has over 25 years experience in computer science applications, analysis, and engineering - including extensive technical writing and editing. Her government and defense projects include lunar mapping, reliability engineering, undersea surveillance, weapon system interface simulation, and naval communications. Her civilian projects include computerized project management and horse race handicapping.

Read More Show Less

Table of Contents

Acknowledgments
Introduction
Pt. I Getting Started
1 Quick Tour of Microsoft Office Access 2003 3
2 The World of Relational Databases 27
3 Creating a Database 41
4 Creating and Modifying Tables 57
5 Relating Tables 95
6 Entering and Editing Data 113
Pt. II Retrieving and Presenting Information
7 Sorting, Filtering, and Printing Records 159
8 Extracting Information with Queries 179
9 Creating Advanced Queries 221
10 Creating Form and Report Designs 245
11 Using the Form Wizard 283
12 Customizing Forms 307
13 Using the Report Wizard 345
14 Customizing Reports 375
15 Creating Charts and Graphs 409
Pt. III Improving the Workplace
16 Customizing the Workplace 437
17 Improving Database Performance 461
18 Understanding Events and the Event Model 481
19 Automating with Macros 497
20 Customizing Menus and Toolbars 525
21 Creating Custom Switchboards and Dialog Boxes 553
Pt. IV Sharing Data with Others
22 Exchanging Database Objects and Text 585
23 Exchanging Data with Outside Sources 609
24 Sharing with Multiple Users 629
25 Securing a Database 643
A Converting to Access 2003 667
B: What's on the CD 675
Index 679
Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
Sort by: Showing 1 Customer Reviews

  • Anonymous

    Posted Wed Apr 04 00:00:00 EDT 2007

    Thank you. Mrs. Andersen

    It is the perfect book

    0 out of 1 people found this review helpful.

    Was this review helpful? Yes  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.
Sort by: Showing 1 Customer Reviews
If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)