Microsoft Access Version 2002 Plain & Simple

Curtis Frye is the author of numerous books on Excel and other Office products, most recently the Excel 2007 Pocket Guide. He graduated from Syracuse in 1990 with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He moved to Portland, Oregon, in 1995 to launch his freelance writing career. When Curt's not writing, and often while he is writing, he is a keynote speaker, mentalist, and professional improvisational comedian.

Acknowledgments xi No Computerese! 1 A Quick Overview 2 A Few Assumptions 3 A Final Word (or Two) 3 Introducing Databases 6 Running Access 9 Surveying the Access Window 11 Opening a Database 12 Sizing and Arranging Windows 13 Closing a Database and Exiting Access 14 Getting Help 15 Printing Database Objects 16 Viewing Sample Databases 20 Working with Database Objects 21 Examining a Table 22 Examining a Form 23 Navigating Using a Switchboard 24 Examining a Query 25 Examining a Report 25 Creating a Database with the Database Wizard 26 Using the Database Wizards 27 Frequently Used Object Views 29 Designing a Database 32 Creating a New Database 34 Creating a Table with the Table Wizard 35 Creating a Table in Design View 36 Setting a Primary Key 37 Getting Data from Other Access Tables 38 Relationships Explained 39 Creating Relationships Between Tables 40 Enforcing Referential Integrity 41 Working with Tables 44 Assigning a Data Type 45 Viewing or Changing Field Properties 46 Introducing the Expression Builder 46 Formatting Field Contents 47 Creating Input Masks 48 Assigning Required Fields and Requiring Data Entry 49 Setting Default Values 50 Indexing Field Values 51 Validating Data Entry 52 Creating a Lookup Field 53 Finding and Replacing Text 56 Entering Data Using AutoCorrect 58 Adding and Editing Text 59 Manipulating Columns 61 Modifying Columns and Rows 62 Viewing a Subdatasheet 63 Filtering Table Records 65 Creating a Form with the Form Wizard 70 Creating a Form in Design View 72 Modifying an Existing Form 73 Adding and Deleting Form Controls 74 Creating a Subform 77 Changing Subform Views 78 Introducing Query Types 82 Creating a Query Using the Query Wizard 84 Editing a Query in Design View 85 Using Criteria to Focus Query Results 87 Introducing Operators 88 Using Queries to Calculate Values 89 Creating a Parameter Query 90 Finding Duplicate Records 91 Finding Unmatched Records 92 Writing Query Results to a New Table 94 Creating an Update Query 95 Creating a Crosstab Query 96 Creating a Report Using the Report Wizard 100 Creating a Summary Report 102 Understanding Report Types 104 Creating a Report in Design View 105 Modifying an Existing Report 106 Adding and Deleting Report Controls 107 Calculating Values in a Report 109 Introducing Report Sections 110 Grouping Report Records 111 Creating a Subreport 112 Creating Mailing Labels 114 Formatting Text 118 Applying AutoFormats 119 Setting Control Appearance 122 Adding Lines, Shapes, and Borders 127 Editing Lines and Borders 129 Adding a Picture 130 Applying Conditional Formatting 132 Changing the Source of an Image 133 Setting Image Alignment and Backing Color 134 Tiling a Picture 136 Controlling When an Image Appears 137 Setting Image Height and Width 138 Adding Clip Art to Forms and Reports 140 Introducing Linking and Embedding 144 Inserting a New Object 145 Manipulating Objects 147 Inserting Excel Charts and Worksheets 148 Creating a Chart 150 Bringing In Data from Other Programs 152 Sending Data to Other Programs 153 Integrating Access and the Internet 156 Working with Hyperlinks 157 Saving Database Objects as Web Pages 160 Creating a Data Access Page 160 Arranging Data on a Data Access Page 162 Viewing and Formatting a Data Access Page 164 Introducing XML 166 Using XML to Exchange Access Data 167 Introducing Database Security 170 Creating a Workgroup Information File 172 Requiring a Password to Open a Database 173 Creating User Accounts 174 Encrypting a Database 176 Locking Database Records 176 Compacting and Repairing a Database 178 Creating a Switchboard 180 Documenting a Database 182 Setting Startup Options 183 Modifying Toolbars 186 Modifying Menus 188 Building a Macro 190 Running a Macro 191 Defining Macro Groups 193 Building Conditional Macros 194 Adding and Deleting Macro Actions 195 Displaying a Message Box 196 Launching a Macro from a Button 198 Running a Macro When a Form Opens 200 Preventing Toolbar Modifications 201 Extending the Recently Used File List 202 Introducing PivotTables and PivotCharts 204 Creating a PivotTable 206 Adding and Removing PivotTable Fields 208 Pivoting a PivotTable 210 Filtering PivotTable Data 211 Formatting a PivotTable 213 Creating a PivotChart 214 INDEX 217