Microsoft Office Access 2003: The Complete Reference

( 1 )

Overview

Store, retrieve, and present information accurately and effectively with help from this comprehensive resource. Get the most out of Access, a straightforward but extremely versatile information management tool, including an understanding of basic database concepts as well as intermediate to advanced database design and programming.

Read More Show Less
... See more details below
Other sellers (Paperback)
  • All (18) from $1.99   
  • New (2) from $28.58   
  • Used (16) from $1.99   
Sending request ...

Overview

Store, retrieve, and present information accurately and effectively with help from this comprehensive resource. Get the most out of Access, a straightforward but extremely versatile information management tool, including an understanding of basic database concepts as well as intermediate to advanced database design and programming.

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)

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 1 Customer Reviews
  • Anonymous

    Posted April 4, 2007

    Thank you. Mrs. Andersen

    It is the perfect book

    0 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

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