| Quick Look Guide | vii
|
| Finding Your Best Starting Point | xi
|
| Using the Microsoft Access 2000 Step by Step CD-ROM | xv
|
| 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
|
| Appendix B Designing a Database | CD-ROM
|
| Appendix C Using Expressions CD-ROM
Index | 285
|
