Using Microsoft Access 2010

Cover......Page 1
Table of Contents......Page 10
Introduction......Page 20
 A Preview of the Database Components......Page 25
 What Types of Things Can I Do with Microsoft Access?......Page 36
 Working with an Existing Database......Page 40
 Working with Table Data......Page 42
 Editing Table Data......Page 45
 Adding Records to a Table......Page 47
 Deleting Records......Page 48
 Filtering Table Data......Page 54
 Opening a Query......Page 56
 Adding and Removing Fields......Page 59
 Modifying the Sort Order of a Query......Page 61
 Working with Simple Criteria......Page 64
 Saving a Query......Page 76
 Printing Query Results......Page 77
 Closing a Query......Page 78
 Designing a Query Based on Multiple Tables......Page 79
 Working with Data in a Form......Page 81
 Filtering the Data Underlying a Form......Page 93
 Closing a Form......Page 96
 The AutoForm Feature......Page 97
 Using the Form Wizard to Build a Form......Page 99
 Using the Conditional Formatting Feature of a Form......Page 102
 Opening and Viewing a Report......Page 104
 Printing a Report......Page 107
 The AutoReport Feature and the Report Wizard......Page 109
 Viewing the Design of a Report......Page 113
 Creating a New Database......Page 116
 Building a New Table......Page 118
 Selecting the Appropriate Field Type for Data......Page 123
 Using Indexes to Improve Performance......Page 128
 The All-Important Primary Key......Page 130
 Working with Field Properties......Page 131
 Introduction to Relational Database Design......Page 142
 The Types of Relationships......Page 149
 Establishing Relationships in Access......Page 151
 Establishing Referential Integrity......Page 155
 Everything You Need to Know About Query Basics......Page 161
 Ordering Query Results......Page 167
 Refining a Query by Using Criteria......Page 168
 Updating Query Results......Page 171
 Building Queries Based on Multiple Tables......Page 172
 Creating Calculated Fields......Page 177
 Getting Help from the Expression Builder......Page 179
 Creating and Running Parameter Queries......Page 181
 Creating and Running Action Queries......Page 182
 Using Aggregate Functions to Summarize Numeric Data......Page 191
 Creating Totals Queries......Page 193
 Working with Outer Joins......Page 195
 Power Control Techniques......Page 198
 Conditional Formatting......Page 209
 Form Properties and Why Should You Use Them......Page 210
 Control Properties and Why to Use Them......Page 216
 Working with Combo Boxes......Page 225
 The Command Button Wizard: Programming Without Typing......Page 230
 Building Forms Based on More Than One Table......Page 232
 The Anatomy of a Report......Page 238
 Control Properties and Why to Use Them......Page 240
 Building Reports Based on More Than One Table......Page 247
 Working with Sorting and Grouping......Page 256
 Report Properties and Why to Use Them......Page 261
 Basing Reports on Stored Queries or Embedded SQL Statements......Page 266
 Learning the Basics of Creating and Running a Macro......Page 268
 Running an Access Macro......Page 278
 Modifying an Existing Macro......Page 281
 Creating an Embedded Macro......Page 283
 Creating Data Macros......Page 286
 Creating a Drillthrough Macro......Page 289
 Other New Features Available in Macros......Page 292
 Testing a Macro......Page 293
 Converting a Macro to VBA Code......Page 295
 Creating an AutoExec Macro......Page 297
 What Is External Data?......Page 299
 Importing, Linking, and Opening Files: When and Why......Page 300
 Exporting to Another Access Database......Page 302
 Exporting to an Excel Spreadsheet......Page 304
 Exporting to ASCII......Page 306
 Importing from Another Access Database......Page 309
 Importing Spreadsheet Data......Page 313
 Importing ASCII Data......Page 317
 Linking to Tables in Another Access Database......Page 320
 Linking to Another Type of Database......Page 322
 The Linked Table Manager......Page 331
 Working with Web Databases......Page 333
 Creating a Blank Web Database......Page 334
 Creating Publishable Objects......Page 336
 Publishing Your Database to Access Services......Page 342
 Viewing Your Application in a Browser......Page 345
 C......Page 347
 D......Page 348
 F......Page 349
 J-K-L......Page 350
 P......Page 351
 R......Page 352
 T......Page 353
 X-Y-Z......Page 354