Cover image for Teach yourself Microsoft Access 2000
Teach yourself Microsoft Access 2000
Siegel, Charles.
Personal Author:
Publication Information:
Foster City, CA : IDG Books Worldwide, [1999]

Physical Description:
376 pages : illustrations ; 23 cm
Title Subject:
Subject Term:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.D3 S56355 1999 Adult Non-Fiction Central Closed Stacks

On Order



Teach Yourself Microsoft Access 2000 is the no-nonsense way to learn the basics of this popular database program. The short, clear steps, easy-reference format, and detailed visuals make it easier to hone those important Access skills in less time. Topics covered include: using wizards to create tables, queries, forms and reports, building relational databases to access and retrieve information, generating, analyzing and creating custom forms and reports, linking a database to a Word document or Excel spreadsheet, publishing Access documents on the Web, and more.

Author Notes

Charles Siegel is a computer consultant and writer who specializes in training business users and in writing custom database applications. In addition to authoring books on FoxPro and Paradox, Charles has authored Access for Windows 95 and teach yourself...Access 97 for Windows.

Table of Contents

Welcome to Teach Yourselfp. viii
Acknowledgmentsp. xv
Part I Access the Easy Wayp. 2
Chapter 1 Getting Startedp. 5
Using a Databasep. 6
Viewing Database Objectsp. 8
Creating New Objectsp. 12
Using Multitable Databasesp. 14
Chapter 2 Creating Databases and Tablesp. 19
Creating a Databasep. 20
Creating a Table Using the Wizardp. 24
Creating a Table Using Design Viewp. 26
Using Essential Field Propertiesp. 30
Creating the Primary Key Fieldp. 32
Modifying the Design of a Tablep. 34
Chapter 3 Working with Datap. 39
Navigating in Datasheet Viewp. 40
Entering and Editing Datap. 42
Working with Recordsp. 44
Working with Special Data Typesp. 46
Using Data-Entry Shortcutsp. 48
Finding Recordsp. 50
Working with Columnsp. 54
Changing the Data Displayp. 58
Printing and Previewing the Datasheetp. 60
Chapter 4 Using Queriesp. 67
Creating a Query Using the Wizardp. 68
Creating a Query in Design Viewp. 70
Including Fields in the Resultp. 72
Controlling Sort Order and Field Displayp. 74
Entering Criteriap. 76
Using the Queryp. 80
Personal Workbookp. 82
Chapter 5 Using Filtersp. 85
Using Simple Filtersp. 86
Using Advanced Filtersp. 88
Working with Filtersp. 90
Chapter 6 Fast Forms, Reports, and Labelsp. 95
Creating Formsp. 96
Using the Form Wizardp. 98
Working with Formsp. 100
Creating Reportsp. 102
Using the Report Wizardp. 104
Creating Mailing Labelsp. 108
Part II Adding Powerp. 114
Chapter 7 Using Relational Databasesp. 117
Working with Many-to-One Relationshipsp. 118
Working with Many-to-Many Relationshipsp. 122
Working with More Complex Relationshipsp. 124
Creating a Default Relationship in Accessp. 126
Using Queries with Relational Databasesp. 130
Using Reports with Relational Databasesp. 134
Using Forms with Relational Databasesp. 136
Chapter 8 Designing Custom Formsp. 141
Getting Oriented with Form Designp. 142
Working with the Formp. 144
Working with Bandsp. 146
Working with Controlsp. 148
Using the Layout Toolsp. 152
Working with Textp. 154
Adding Colors and Effectsp. 156
Personal Workbookp. 158
Chapter 9 Designing Custom Forms -- Advanced Techniquesp. 161
Using the Field List and Toolboxp. 162
Adding Labels and Text Boxesp. 164
Adding an Option Groupp. 166
Adding Toggle Buttons, Option Buttons, and Checkboxesp. 168
Adding List Boxes and Combo Boxesp. 170
Adding Command Buttonsp. 174
Adding Other Controlsp. 176
Adding Page Breaks and Tabsp. 178
Adding Hyperlinksp. 180
Looking at Property Sheetsp. 182
Chapter 10 Designing Custom Reportsp. 189
Understanding the Basics of Report Designp. 190
Sorting and Groupingp. 194
Grouping by Rangep. 196
Creating Complex Sorts and Subgroupsp. 198
Using Page Setupp. 200
Chapter 11 Using Advanced Queriesp. 205
Working with Parameter Queriesp. 206
Using Make-Table Queriesp. 208
Using Update Queriesp. 210
Using Append Queriesp. 212
Using Delete Queries and Correcting Errorsp. 214
Creating Queries with Totals and Groupsp. 216
Creating Crosstab Queriesp. 218
Using Properties in Queriesp. 222
Chapter 12 Saving Time with Macrosp. 227
Creating Macrosp. 228
Running Macrosp. 232
Creating Macro Groupsp. 234
Using Conditional Actions in Macrosp. 236
Debugging Macrosp. 238
Creating Applicationsp. 240
Part III Utilities and Advanced Topicsp. 245
Chapter 13 Defining a Table -- Advanced Techniquesp. 247
Understanding Text Field Propertiesp. 248
Understanding Number and Currency Field Propertiesp. 250
Understanding Properties of Other Data Typesp. 252
Understanding Common Propertiesp. 254
Understanding Input Masksp. 256
Creating Lookup Fieldsp. 260
Chapter 14 Working with Expressionsp. 267
Using the Expression Builderp. 268
Understanding Identifiersp. 270
Understanding Operatorsp. 272
Understanding Functionsp. 276
Literals, Constants, and Common Expressionsp. 278
Using Expressions in Table Designp. 280
Using Expressions in Queriesp. 282
Using Expressions in Forms and Reportsp. 284
Chapter 15 Working with Web Pagesp. 291
Working with Data Access Pagesp. 292
Creating and Using Data Access Pagesp. 294
Creating a Data Access Page in Design Viewp. 296
Using Hyperlink Fieldsp. 298
Adding Hyperlinks to a Form or Reportp. 302
Chapter 16 Working with OLE Objectsp. 307
Using OLE Objects in Tables and Queriesp. 308
Adding OLE Objects to Forms and Reportsp. 312
Formatting OLE Objects in Forms and Reportsp. 314
Chapter 17 Using Access Utilitiesp. 319
Using Utilities to Manage Access Objectsp. 320
Creating Indexesp. 322
Using Access Optionsp. 324
Customizing Toolbars and Menusp. 328
Chapter 18 Using the Help Systemp. 333
Using Quick Help and the Assistantp. 334
Using the Help Systemp. 336
Customizing the Assistantp. 338
Personal Workbook Answersp. 342
Glossaryp. 361
Indexp. 368