| Acknowledgments | xix |
| Introduction | xxi |
| Part I | Get Started | |
| Chapter 1 | Get Acquainted with Access 2003 | 3 |
| Start Access and Open a Database | 4 |
| Open a Table | 14 |
| Get Help When You Need It | 18 |
| Chapter 2 | Create a Database | 25 |
| Design an Efficient Database | 26 |
| Create a Database with the Database Wizard | 33 |
| Run the New Application | 38 |
| Start with a Blank Database | 39 |
| Chapter 3 | Create and Modify Tables | 41 |
| Create a Table with the Table Wizard | 42 |
| Create a Table from Scratch in Design View | 47 |
| Modify the Table Design | 62 |
| Ensure Data Validity | 65 |
| Copy an Existing Table Structure | 70 |
| Chapter 4 | Relate Tables | 73 |
| Define a Relationship | 74 |
| View and Edit Relationships | 85 |
| Print the Relationships | 86 |
| Chapter 5 | Enter and Edit Data | 89 |
| Enter New Data | 90 |
| Customize Data Entry | 99 |
| Change the Datasheet Appearance | 106 |
| Change Table Definition in Datasheet View | 112 |
| Edit Record Data | 113 |
| Part II | Retrieve and Present Information | |
| Chapter 6 | Sort, Filter, and Print Records | 123 |
| Sort Records | 124 |
| Filter Records | 125 |
| Preview and Print Sorted or Filtered Table Data | 136 |
| Chapter 7 | Extract Information with Queries | 139 |
| Create a Select Query | 141 |
| Add Selection Criteria | 153 |
| Set Query Properties | 158 |
| Modify a Query | 159 |
| Perform Calculations in a Query | 161 |
| Create Special Queries with the Query Wizard | 166 |
| Chapter 8 | Create Advanced Queries | 173 |
| Create Special Purpose Queries | 174 |
| Look at Structured Query Language (SQL) | 185 |
| Create a Subquery | 187 |
| Chapter 9 | Understand Form and Report Design Basics | 189 |
| Use AutoForm and AutoReport Features | 190 |
| Common Form and Report Design Elements | 191 |
| Work in the Design Window | 193 |
| Modify Controls | 202 |
| Modify Form or Report Properties | 213 |
| Chapter 10 | Create Custom Forms and Subforms | 217 |
| Create a New Form Design | 218 |
| Modify the Form Design | 222 |
| Use the Form for Data Entry | 237 |
| Create a Multiple-Page Form | 241 |
| Add Special Controls | 245 |
| Create a Hierarchical Form | 246 |
| Add Custom User Guidance | 252 |
| Add Data Validation | 252 |
| Chapter 11 | Create and Customize Reports and Subreports | 255 |
| Start a New Report | 256 |
| Preview and Print the Report | 262 |
| Modify the Report Design | 266 |
| Save the Report Design | 270 |
| Sort and Group Records in a Report | 270 |
| Add a Subreport | 281 |
| Design a Multiple-Column Report | 289 |
| Print Mailing Labels | 290 |
| Chapter 12 | Create Charts and Graphs | 295 |
| Choose a Chart Type | 296 |
| Create a New Chart with the Chart Wizard | 296 |
| Add an Existing Chart to a Form or Report | 303 |
| Modify the Chart | 304 |
| Part III | Improve the Access 2003 Workplace | |
| Chapter 13 | Customize the Workplace | 319 |
| Personalize the Workplace | 320 |
| Create Custom Groups | 333 |
| Change the Way Access Starts | 334 |
| Modify the Office Assistant | 337 |
| Chapter 14 | Speed Up Your Database | 341 |
| Optimize a Database | 342 |
| Back Up and Restore a Database | 352 |
| Compact and Repair a Database | 353 |
| Chapter 15 | Automate with Macros | 357 |
| Create a Simple Macro | 358 |
| Test and Debug a Macro | 361 |
| Assign a Macro to an Event Property | 363 |
| Add Conditions to a Macro | 365 |
| Create Other Commonly Used Macros | 368 |
| Create a Macro Group | 373 |
| Chapter 16 | Customize Menus and Toolbars | 377 |
| Use Access Command Bars | 378 |
| Customize Command Bars | 383 |
| Modify Command Bars | 393 |
| Chapter 17 | Create Custom Switchboards and Dialog Boxes | 399 |
| Create Switchboards | 400 |
| Create a Custom Dialog Box | 412 |
| Create a Dialog Box for User Input | 419 |
| Part IV | Exchange Data with Others | |
| Chapter 18 | Exchange Database Objects and Text | 425 |
| Copy Objects among Access Databases | 426 |
| Import or Link Access Data | 428 |
| Import from or Link to Other Data Sources | 432 |
| Work with Linked or Imported Tables | 434 |
| Import and Link Text Files | 436 |
| Export to an Existing Access Database | 442 |
| Export to Another Database Format | 444 |
| Export to Text Files | 444 |
| Chapter 19 | Exchange Data with Outside Sources | 447 |
| Copy or Move Records | 448 |
| Save Access Output as an External File | 451 |
| Work with Word | 452 |
| Work with Excel | 457 |
| Chapter 20 | Share with Multiple Users | 465 |
| Share a Database on a Network | 466 |
| Replicate a Database | 471 |
| Manage the Database in a Multiuser Environment | 472 |
| Chapter 21 | Secure a Database | 477 |
| Secure a Database with a Password | 478 |
| Secure a Multiple-User Database | 479 |
| Other Security Measures | 498 |
| Appendix | Convert to Access 2003 | 501 |
| Decide on a Conversion Strategy | 502 |
| Convert a Database | 502 |
| Convert a Workgroup Information File | 504 |
| Convert a Secured Database | 504 |
| Convert a Replicated Database | 504 |
| Enable a Database | 505 |
| Share a Database Across Several Access Versions | 506 |
| Convert from Access 2002-2003 to Access 97 | 507 |
| Convert from Access 2002-2003 to Access 2000 | 507 |
| Index | 509 |
