|
Access 2002 Plain & Simple
Get the fast facts that make learning Access 2002 plain and simple! Here's WHAT you'll learn: * Find the simplest ways to get stuff done in Microsoft Access * Design and build your own database now * Import/export data from other programs * Share your data over the Web * Manage database access and security * Use PivotTable and PivotChart dynamic views
Here's HOW you'll learn it: * NUMBERED STEPS show exactly what to do * Color SCREEN SHOTS keep you on track * Handy TIPS teach easy techniques and shortcuts * Quick TRY THIS! exercises put your learning to work * CAUTION notes help keep you out of trouble
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
|
