Includes index.

Contents QuickLook Guide vii Finding Your Best Starting Point xi Finding the Best Starting Point xi New Features in Microsoft Access 2000 xiii Corrections, Comments, and Help xiv Using the Microsoft Access 2000 Step by Step CD-ROM xv Installing the Practice Files xvi Using the Practice Files xvi Using the Multimedia Files xvii Uninstalling the Practice Files xviii Need Help with the Practice Files? xviii Conventions and Features in This Book xix PART 1 Entering and Viewing Data in Microsoft Access 2000 1 Lesson 1 Using Forms 3 Opening a Database 5 Understanding Forms 8 Entering and Updating Data 9 Entering Data Efficiently and Correctly 13 Finding Records 16 Adding and Removing Record Text 18 One Step Further: Replacing Data 24 Lesson 1 Quick Reference 26 Lesson 2 Using Tables and Subforms 29 Viewing a Datasheet 31 Viewing Multiple Tables with a Subform 35 One Step Further: Refining Datasheet Views 38 Lesson 2 Quick Reference 40 Lesson 3 Using Filters and Reports 41 Viewing Only the Information You Need 42 Refining Your View of the Data 45 Preserving Your View in a Report 47 Creating Mailing Labels 52 One Step Further: Creating More Complex Filters 59 Lesson 3 Quick Reference 61 Part 1 Review and Practice 63 PART 2 Creating and Expanding Databases 69 Lesson 4 Managing Database Change 71 Modifying Database Tables 72 Changing a Table in Design View 78 Improving Data Entry and Display 81 Connecting a New Table to a Database 84 One Step Further: Combining Data from Related Tables Using a Query 90 Lesson 4 Quick Reference 93 Lesson 5 Keeping Database Information Reliable 95 Validating Data in a Form 96 Validating Records Across Related Tables 107 Resolving Many-to-Many Relationships 112 One Step Further: Using Subdatasheets 115 Lesson 5 Quick Reference 119 Lesson 6 Working with External Data 121 Gathering Data from External Sources 122 Creating a Link to an External

MICROSOFT ACCESS 2000 STEP BY STEP is the easiest and fastest way to teach yourself to use the latest version of Microsoft s powerful relational database program. Work through every lesson to complete the full course, or do individual lessons to learn just the skills you need. Either way, you learn at your optimum pace from the teacher who knows you best you. With this book and Microsoft Access 2000, you ll learn to: Enter and view data view, add, and edit data using forms and tables; sort and filter records; preview and print reports; create mailing labels Create and expand databases create new tables; relate tables and databases; work with external data Turn data into meaningful information design queries and analyze data; merge data from two tables into one form Refine your database customize forms and reports; present reports more effectively; present grouped data in a report Take your database to the world create a set of interactive data access pages with the data access page designer; use the Office Web components with your other Office programs

System requirements for accompanying computer disc: Windows 95; Windows 98; and Windows NT.