Cover image for Access 2003 : your visual blueprint for creating and maintaining real-world databases
Access 2003 : your visual blueprint for creating and maintaining real-world databases
Barker, F. Scott.
Personal Author:
Publication Information:
Hoboken, NJ : Wiley, [2004]

Physical Description:
xv, 310 pages : illustrations ; 23 cm + 1 CD-ROM (4 3/4 in.).
General Note:
"Visual from maranGraphics."

Includes index.
Title Subject:
Subject Term:
Added Corporate Author:
Format :


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

On Order



Access is the world's most widely used database application. This book explains database concepts, then shows how databases are built to perform in real-old business situations.

Table of Contents

How to Use This Bookp. XIV
1) Architect Your Access Database
Understanding Relational Databasesp. 2
Overview of Accessp. 4
Using the Access Database Wizardp. 6
Download Additional Database Templatesp. 8
Create a Blank Databasep. 9
Create a New Table Using Datap. 10
Create a New Table with the Designerp. 12
Create an Input Maskp. 14
Add a Validation Rule and Validation Textp. 16
Add the Default Value and Required Propertiesp. 17
Specify Lookup Valuesp. 18
Establish Relationshipsp. 20
Link Access Tablesp. 22
Link SQL Server Tablesp. 24
2) Creating Queries to View Your Information
Understanding SQLp. 28
Types of Queries Found in Accessp. 29
Create a Basic Queryp. 30
Sort Columnsp. 32
View and Modify SQL Directlyp. 33
Add Simple Criteria to a Queryp. 34
Add Complex Criteria to a Queryp. 36
Create a Parameter Queryp. 38
Display a Calculated Columnp. 40
Using Multiple Tablesp. 42
Update Existing Recordsp. 44
Append New Recordsp. 46
Make a New Table Using a Queryp. 48
Delete Recordsp. 50
3) Advanced Queries
Understanding Join Typesp. 52
Create an Inner Joinp. 53
Create Left and Right Outer Joinsp. 54
Summarize Data Using a Totals Queryp. 56
Retrieve the Top Valuesp. 58
Create a Simple Crosstab Queryp. 60
Control Order of Headingsp. 62
Add Row Totals to Your Crosstab Queryp. 63
Total Up Crosstab Columnsp. 64
Create Data Definition Queriesp. 66
4) Working with Forms
Form Basicsp. 68
Create a Datasheet View Form Using an AutoFormp. 70
Move Through the Datasheetp. 71
Filter By Selectionp. 72
Filter By Formp. 74
Find and Replace Data in Your Datasheetp. 76
Using the Form Wizardp. 78
Tools of Form Design Viewp. 80
Introducing Form Propertiesp. 81
Create a Single Page Form Using the Design Viewp. 82
Set Form Propertiesp. 84
Work with Multiple Controlsp. 86
Create a Form in the Continuous Form Viewp. 88
5) Utilizing Controls on Forms
Match the Control with the Correct Purposep. 90
Display a Calculated Expression in a Text Boxp. 92
Correct Control Errorsp. 93
Create an Option Group Controlp. 94
Add a Combo Box Control to Limit Datap. 96
Utilize Hidden Columns in a Combo Boxp. 98
Add a List Box Controlp. 100
Add Smart Tags to Controlsp. 101
Add a Tab Control to a Formp. 102
Add Data to the Tab Control Pagesp. 104
Add Graphics to a Formp. 106
Using a Subform to Display Main/Detail Datap. 108
Limit Data in a Subform with a Combo Boxp. 110
Display a Summarized Subform Column in the Mainformp. 112
Using the ActiveX Calendar Controlp. 114
6) VBA for Automating Your Application
Understanding VBA Basicsp. 116
Why Use VBA and Not Macros?p. 118
Convert Your Macrosp. 119
Set Up the Integrated Development Environmentp. 120
Learn to Code from the Command Button Wizardp. 122
Using DoCmd to Open Forms and Queriesp. 124
Using Variables and Constantsp. 126
Using the MsgBox Statementp. 128
Control Branchingp. 130
Loop Using For...Nextp. 132
Loop Using Do While/Untilp. 133
Add Error Handlingp. 134
7) Using VBA Behind Your Forms
Using Code Behind Forms and Eventsp. 136
Work with Events for Forms and Controlsp. 138
Syntax for Using Forms and Controls in VBAp. 140
Modify Form and Control Properties at Runtimep. 141
Using Form and Control Variablesp. 142
Validate a Required Value Before Updatingp. 144
Work with Data Behind a Formp. 146
Utilize a Combo Box to Locate Recordsp. 147
Toggle a Form's Viewing or Editingp. 148
Display or Hide Tab Control Pagesp. 150
8) Creating Reports
Introducing Access Reportsp. 152
Various Report Possibilitiesp. 153
Take Advantage of the Report Wizardp. 154
Create a New Reportp. 156
Work with Calculated Expressionsp. 158
Hide Rows Based on the Value of a Fieldp. 160
Sort Information on Reportsp. 161
Add Groupings to a Reportp. 162
Open a Report Based on a Form Filterp. 164
Supply a Parameter Using a Formp. 166
Display Different Views of the Same Reportp. 168
9) Analyzing Data Using Pivottable and Pivotchart Views
Introducing the Pivot Table and PivotChartp. 170
Using the PivotTable Wizardp. 172
Add a Filter to the Pivot Tablep. 174
Using Top/Bottom Values and Other Filtersp. 176
Display Summary/Detail Datap. 178
Create a Simple PivotChart Formp. 180
Drill, Filter, and Get Data on PivotChartsp. 182
10) Importing, Linking, and Exporting Data
Import or Link Datap. 184
Export Data from Accessp. 185
Using Windows SharePoint Servicesp. 186
Introducing XMLp. 187
Split and Link an Access Databasep. 188
Import Data from Microsoft Excelp. 190
Import Data from Text Filesp. 192
Import Data from SQL Serverp. 194
Import Lists from Windows SharePoint Servicesp. 196
Export, Analyze, and E-mail Data to Excelp. 198
Export Data as Text Filesp. 200
Export Data as XMLp. 202
Export a Table to Windows SharePoint Servicesp. 204
11) Accessing Data Directly with ADO
Introducing ActiveX Data Objectsp. 206
View or Deselect Library Referencesp. 208
Create an ADO Connectionp. 210
Open an ADO Recordsetp. 212
Move Around and Display Data from the Recordsetp. 214
Loop Through a Recordset Using Criteriap. 216
Manage Records in Recordsetsp. 218
Execute a Bulk Query Using the ADO Commandp. 220
Using a Parameter with the ADO Commandp. 222
12) Automating Other Office Products
Using Automation to Control Other Office Productsp. 224
Create a Word Document from Accessp. 226
Add a Bookmark to a Word Documentp. 228
Insert Access Data into a Bookmarked Word Documentp. 229
Create an Excel Spreadsheet from Accessp. 230
Load Recordset Data From Access into Excelp. 232
Using the Excel Chart Wizard from Accessp. 234
Create Outlook E-mail from Accessp. 236
13) Securing Access Databases
Work with Security in Accessp. 238
Using a Single Database Passwordp. 240
Create an Access MDE Filep. 241
Encode and Decode a Databasep. 242
Set the Password for VBA Codep. 243
Work with Workgroupsp. 244
Create Groupsp. 246
Create and Assign Users to Groupsp. 248
Assign Permissionsp. 250
Introducing the User-Level Security Wizardp. 252
14) Replicating Your Database
Introducing Replicationp. 256
Create a Replica Using Menusp. 257
Create a New Briefcase to Replicate a Databasep. 258
Synchronize Your Replicasp. 260
Resolve Data Conflictsp. 262
Create a Replica Using VBAp. 264
Synchronize Replicas Using VBAp. 266
15) Publishing Data to the Internet
Access and the Internetp. 268
Set the Hyperlink Properties of Controlsp. 270
Add and Use a Hyperlink Field in a Tablep. 272
Using VBA to Follow a Hyperlinkp. 274
Publish Access Data to HTMLp. 276
Using the Data Access Page Wizardp. 278
Convert Forms and Reports to Data Access Pagesp. 280
Appendix A
Leszynski Naming Coventions for Microsoft Accessp. 282
Appendix B
What's on the CD-ROMp. 292
Using the E-Version of this Bookp. 294
Wiley Publishing, Inc. End-User License Agreementp. 296