Dummies 101. Access 97 for Windows (with CD-ROM)

Overview

The word database can strike fear even in the hearts of long-time word processor and spreadsheet users. Fortunately, Dummies 101: Access 97 For Windows is here to take you step by step through creating your own Access database, entering and modifying the information it contains, generating custom, professional-looking reports, and sharing data between Access and other applications, such as Word and Excel.

With Margaret Levine Young and Rodney ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (8) from $1.99   
  • New (1) from $50.00   
  • Used (7) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$50.00
Seller since 2014

Feedback rating:

(164)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

The word database can strike fear even in the hearts of long-time word processor and spreadsheet users. Fortunately, Dummies 101: Access 97 For Windows is here to take you step by step through creating your own Access database, entering and modifying the information it contains, generating custom, professional-looking reports, and sharing data between Access and other applications, such as Word and Excel.

With Margaret Levine Young and Rodney Lowe as your own personal instructors, you'll quickly become adept at how to . . .

  • Design a database that works for you and others in your organization
  • Ensure the integrity and quality of the information in your database, even when there's more than one person using it
  • Transform your Access database into Web pages for publication on the Internet or your organization's intranet
  • Crank out mailing labels in a flash
  • Take advantage of the Access 97 program's built-in wizards that make creating databases, queries, and reports fast and easy
  • Relate information contained in multiple tables

Plus, Dummies 101: Access 97 For Windows comes complete with a companion CD containing ready-to-use sample databases keyed to the book's lessons, tests, and lab assignments.

Read More Show Less

Product Details

  • ISBN-13: 9780764500954
  • Publisher: Wiley, John & Sons, Incorporated
  • Publication date: 1/10/1997
  • Series: Dummies 101 Series
  • Edition description: BK&CD-ROM
  • Edition number: 1
  • Pages: 272
  • Product dimensions: 8.44 (w) x 9.92 (h) x 0.81 (d)

Table of Contents

Introduction

Who Are You?
How the Book Works
How the Book Is Organized
Part I: Database Basics
Part II: Getting Data into Your Database
Part III: Printing Reports and Creating Web Pages
Part IV: Creating and Using Multitable Databases
Icons Used in This Book
Using the Dummies 101 CD-ROM
Send Us E-Mail

Part I: Database Basics

Unit 1: Starting Out in Access
Lesson 1-1: Running Access
Starting Access
Recess
Lesson 1-2: Seeing What's in the Database
Lesson 1-3: Looking at the Records in a Table
Lesson 1-4: Using Menu Commands and Toolbar Buttons
Lesson 1-5: Exiting Access
Unit 1 Quiz
Unit 1 Exercise
Unit 2: Creating Your Own Database
Lesson 2-1: Creating an Address Book
Recess
Lesson 2-2: Entering Records Using a Form
Typing records
Typing more records
Cruising with the navigation bar
Lesson 2-3: Another Way into Your Database
Recess
What forms are in this database?
What tables are in this database?
What else is in this database?
Lesson 2-4: Printing Reports
Unit 2 Quiz
Unit 2 Exercise
Part I Review
Unit 1 Summary
Unit 2 Summary
Part I Test
Part I Lab Assignment

Part II: Getting Data into Your Database

Unit 3: Editing, Finding, and Deleting Records
Lesson 3-1: Editing and Copying Entries
Lesson 3-2: Stupid Data-Entry Tricks
Copying values from one field to another
Using combo boxes and radio buttons
Lesson 3-3: Fixing Mistakes
Oops! Fixing a mistake in a field
Using a form in Datasheet view
Recess
Lesson 3-4: Deleting Stuff
Lesson 3-5: Finding Records
Searching for codes
Tips for searching
Searching for a word or phrase
Recess
Unit 3 Quiz
Unit 3 Exercise
Unit 4: Slicing and Dicing Your Data
Lesson 4-1: Getting Answers with Queries
Looking at selected fields
Looking at the results of a query
Recess
Lesson 4-2: Looking at Selected Records
Copying a query
Changing a query's design
Lesson 4-3: Designing a Query from Scratch
Starting fresh
Selecting a range of names
Looking for missing information
Lesson 4-4: Sorting the Results of a Query
Omitting fields from a query
Alphabetizing names
Recess
Unit 4 Quiz
Unit 4 Exercise
Unit 5: Importing Information into Access
Lesson 5-1: Importing Data from Another Access Database
Lesson 5-2: Importing Data from Web Pages
Lesson 5-3: Importing Text Files into Access
Lesson 5-4: Combining Data from Two Tables
Recess
Unit 5 Quiz
Unit 5 Exercise
Part II Review
Unit 3 Summary
Unit 4 Summary
Unit 5 Summary
Part II Test
Part II Lab Assignment

Part III: Printing Reports and Creating Web Pages

Unit 6: Formatting and Printing Datasheets
Lesson 6-1: Adjusting Datasheet Columns
Changing column widths
Swapping columns around
Changing the datasheet font
Recess
Lesson 6-2: Sorting Datasheets
Lesson 6-3: Looking Before You Print
Previewing a datasheet
Hiding columns in a datasheet
Lesson 6-4: Printing the Datasheet
Printing one copy
Printing multiple copies
Printing the results of a query
Recess
Unit 6 Quiz
Unit 6 Exercise
Unit 7: Making Reports and Web Pages
Lesson 7-1: Printing a Report
Looking at the Database Wizard's reports
Looking at any report
Printing a report
Lesson 7-2: Making Your Own Reports
Making a columnar report with the Report Wizard
Recess
Lesson 7-3: Making Fancier Reports
Selecting records to include
Using a query as the record source for a report
Lesson 7-4: Making a Mailing Label Report
Lesson 7-5: Creating a Web Page from Your Database
Unit 7 Quiz
Unit 7 Exercise
Part III Review
Unit 6 Summary
Unit 7 Summary
Part III Test
Part III Lab Assignment

Part IV: Creating and Using Multitable Databases

Unit 8: Making Databases with Related Tables
Lesson 8-1: Database Design 101
Why use related databases at all?
Linking tables with key fields
Many-to-many relationships
Eight steps for database design
Lesson 8-2: Opening a Multitable Database
Looking at the tables
Looking at other database elements
Lesson 8-3: Mapping Out Relationships
Peeking in the Relationships window
Looking at join lines
Recess
Unit 8 Quiz
Unit 8 Exercise
Unit 9: Making Multitable Queries
Lesson 9-1: Starting a Multitable Query
Adding field lists
Recess
Lesson 9-2: Adding Fields from Multiple Tables to the Design Grid
Creating calculated fields
Adding fields from both tables
Sorting records and omitting fields
Lesson 9-3: Setting Relationship Options
Unit 9 Quiz
Unit 9 Exercise
Unit 10: Changing the Design of Your Database
Lesson 10-1: Adding, Deleting, or Changing Fields in a Table
Adding fields to a table
Looking at your revised table
Recess
Lesson 10-2: Adding a Related Table to Your Database
Making a lookup table
Making the lookup field
Lesson 10-3: Adding New Fields to Queries
Lesson 10-4: Adding New Fields to a Form
Copying a form
Adding fields to a form
Controlling how the cursor moves
Recess
Lesson 10-5: Adding New Fields to a Report
Unit 10 Quiz
Unit 10 Exercise
Part IV Review
Unit 8 Summary
Unit 9 Summary
Unit 10 Summary
Part IV Test
Part IV Lab Assignment

Appendix A: Answers
Part I Test Answers
Part II Test Answers
Part III Test Answers
Part IV Test Answers

Appendix B: About the CD
System Requirements
What's on the CD
Putting the Exercise Files on Your Hard Drive
Using the exercise files . . .
Removing the exercise files

Index

IDG BOOKS WORLDWIDE, INC. END-USER LICENSE AGREEMENT

Dummies 101 CD-ROM Installation Instructions

Reader Response Card

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)