With Margaret Levine Young and Rodney Lowe as your own personal instructors, you'll quickly become adept at how to . . .
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.
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
Overview
With Margaret Levine Young and Rodney ...