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 This book is approved courseware for the Microsoft Office Specialist Program. Go to: http://www.microsoft.com/learning/mcp/officespecialist/default.mspx

Table of Contents:
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 Data Source 123 Importing a Table 127 One Step Further: Making Data Available to Other Sources 129 Lesson 6 Quick Reference 131 Part 2 Review and Practice 133 PART 3 Turning Data into Meaningful Information 137 Lesson 7 Using Queries 139 Understanding Queries 140 Creating a Query with the Query Wizard 141 Modifying a Query in Design View 144 Refining a Query with Criteria 147 Presenting a Query More Effectively 150 Joining Related Tables in the Query Window 152 One Step Further: Fine-tuning Queries 155 Lesson 7 Quick Reference 158 Lesson 8 Analyzing Your Data 159 Turning Raw Data into Meaningful Information 161 Creating Descriptive Column Names 166 Using Queries with Calculated Fields to Analyze Data 167 Summarizing and Calculating with a Crosstab Query 171 One Step Further: Presenting Data in a Chart 175 Lesson 8 Quick Reference 180 Lesson 9 Merging Data onto One Form 181 Creating Custom Forms with the Form Wizard 182 Adding a Calculated Control to a Form 185 Lesson 9 Quick Reference 193 Part 3 Review and Practice 195 PART 4 Turning Data into Meaningful Information 201 Lesson 10 Presenting a Form More Effectively 203 Enhancing Form Wizard and AutoForm Forms 204 Adding a Headline to a Form Header 205 Maintaining the Consistency of Form Formatting 208 Refining the Appearance of a Form 209 Adding a Picture to a Form 212 One Step Further: Using AutoFormat 216 Lesson 10 Quick Reference 218 Lesson 11 Presenting an Effective Report 221 Summarizing Data by Using a Detail Report 222 Understanding the Design of the Report 224 Customizing the Design of a Report 226 Hiding Duplicated or Unnecessary Information 231 One Step Further: Creating and Refining a Custom AutoReport 233 Lesson 11 Quick Reference 236 Lesson 12 Presenting Grouped Data in a Report 237 Summarizing Data by Grouping Records 238 Summarizing Data with a Grouped Report 239 Customizing a Group Header and Footer 243 Rearranging the Order of a Grouped Report 247 Keeping Related Groups Together 249 Customizing Page Numbers 250 One Step Further: Refining the Group Header 251 Lesson 12 Quick Reference 254 Part 4 Review and Practice 255 PART 5 Taking Your Database to the World 259 Lesson 13 Making Connections 261 Understanding Hyperlinks, Hypertext, and HTML 262 Connecting Through Cyberspace 263 Adding Hyperlinks to Your Database 264 Publishing a Database Object as a Web Page 269 Understanding Data Access Pages 274 One Step Further: Adding a Microsoft Office Web Component 277 Lesson 13 Quick Reference 281 Part 5 Review and Practice 283 Appendix A Matching the Exercises CD-ROM Installing Windows, Windows NT, or Product Components A-1 Using the Default Windows Settings A-2 Appendix B Designing a Database CD-ROM Database Design Process B-1 Expanding an Existing Database B-2 Appendix C Using Expressions CD-ROM What Are Expressions? C-1 Rules for Entering Expressions C-2 Creating Expressions with the Expression Builder C-3 Using Expressions in Forms and Reports C-5 Using Expressions as Validation Rules C-7 Using Expressions in Queries and Filters C-7 Index 285