Pro Access 2010 Development

Cover......Page 1
Contents at a Glance......Page 3
Contents......Page 574
About the Author......Page 587
About the Technical Reviewer......Page 588
Preface......Page 590
Introduction......Page 5
Choosing the Application Architecture......Page 6
The Sample Application......Page 7
Getting Started......Page 16
Using Primary Keys......Page 19
Normalizing a Database......Page 20
Designing the Tables......Page 21
Creating the Customer Table......Page 23
Creating the Category Table......Page 28
Creating the Media Table......Page 30
Creating the Item Table......Page 34
Creating the ItemInventory Table......Page 41
Creating the Loan Table......Page 47
Creating the Request Table......Page 51
Summary......Page 53
Understanding Data Macros......Page 55
Creating Your First Data Macro......Page 56
Testing Your Macro......Page 59
Understanding Data Blocks......Page 60
Using Aliases......Page 61
Using Data Actions......Page 62
Making Sure the Item is Available......Page 63
Calculating the Late Fee......Page 65
Validating Renewals......Page 67
Modifying the Loan After Insert Event......Page 68
Handling Requested Items......Page 70
Creating a Named Data Macro......Page 71
Creating a Named Data Macro to Compute Overdue Fees......Page 73
Debugging Data Macros......Page 75
Using the LogEvent Action......Page 76
Summary......Page 77
Creating a Simple Query......Page 79
Adding Tables......Page 82
Using Joins......Page 83
Making Additional Changes......Page 86
Creating the AddInventoryItem Query......Page 89
Enhancing the Request Feature......Page 93
Building the AllLoans Query......Page 98
Designing the LoanSummary Query......Page 100
Summary......Page 104
Slicing, Dicing, and Drilling......Page 105
Creating a PivotTable View......Page 106
Understanding the PivotTable Layout......Page 107
Using the PivotTable Fields......Page 108
Defining the Column Field......Page 110
Using Date Fields......Page 111
Adding a Filter Field......Page 113
Including Multiple Values......Page 114
Using Calculated Columns......Page 116
Adding Additional Column Fields......Page 117
Creating a Field Hierarchy......Page 118
Configuring a PivotChart View......Page 120
Changing the Chart Type......Page 122
Exporting a PivotTable View to Excel......Page 124
Summary......Page 125
Using the Form Wizard......Page 127
Using the Available Views......Page 130
Sorting the Records......Page 132
Generating the Media Form......Page 133
Modifying the Form Fields......Page 135
Generating the InventoryItem Form......Page 137
Designing the InventoryItem Form......Page 140
Modifying the Form Fields......Page 141
Using the Tabular Layout Option......Page 143
Using the Columnar Layout Option......Page 144
Using the Justified Layout Option......Page 145
Using a Layout......Page 146
Using the Standard Form Template......Page 147
Arranging the Form’s Layout......Page 149
Adding a Subform......Page 150
Summary......Page 152
Implementing a Customer Search Feature......Page 153
Creating the CustomerSearch Dialog Box......Page 154
Building a CustomerDisplay Form......Page 163
Creating the CheckOut Form......Page 166
Building an InventoryItemLookup Form......Page 173
Linking the InventoryItemLookup Subform......Page 178
Designing the CheckOut Details......Page 180
Implementing the CheckOut Logic......Page 184
Testing the Application......Page 187
Summary......Page 189
Creating a CustomerUpdate Form......Page 191
Configuring the Form Controls......Page 195
Creating the CustomerAdmin Form......Page 197
Testing the Profile Page......Page 205
Building the Items on Loan Tab......Page 206
Enhancing the LoanDetails Query......Page 207
Designing a CustomerLoan Form......Page 208
Configuring the Datasheet View......Page 211
Designing the Items on Loan Page......Page 212
Connecting the Pieces......Page 214
Testing the Page......Page 217
Building the Loan History Tab......Page 218
Summary......Page 220
Image Support in Access......Page 221
Adding a Picture to the Item Table......Page 223
Modifying the Item Form......Page 224
Displaying an Image......Page 226
Implementing Item Search......Page 229
Importing Item Data......Page 230
Designing the Search Form......Page 233
Testing the Search Function......Page 241
Using Conditional Formatting......Page 242
Invoking the ItemSearch Form......Page 245
Adding an Inventory Item......Page 247
Adding a Web Browser......Page 249
Using Page Breaks......Page 251
Modifying the CustomerLoan Form......Page 253
Summary......Page 254
Form Navigation......Page 255
Creating the Menu Form......Page 256
Ribbon Navigation......Page 262
Implementing a Sample Ribbon Tab......Page 263
Displaying the System Objects......Page 267
Building a Custom Ribbon......Page 268
Designing the Tables......Page 269
Creating the Menu Forms......Page 270
Populating the Menu Tables......Page 272
Using MSO Images......Page 275
Implementing the Custom Ribbon......Page 276
Locking Down the Database......Page 283
Removing Navigation......Page 284
Compiling the Database......Page 287
Summary......Page 289
Understanding Office Themes......Page 290
Applying an Office Theme......Page 299
Making Other Visual Adjustments......Page 301
Adding a Banner Graphic......Page 302
Using a Background Image......Page 304
Summary......Page 306
Understanding Report Sections......Page 307
Creating a Simple Report......Page 310
Modifying the Page Setup......Page 311
Modifying the Report Layout......Page 313
Using the Report Wizard......Page 315
Exploring the Design View......Page 323
Using the Layout View......Page 325
Configuring Grouping and Sorting......Page 327
Using Unbound Controls......Page 330
Adding the Data-Bound Controls......Page 334
Formatting the Report Header......Page 335
Adding a Subreport......Page 336
Modifying the CheckOut Form......Page 339
Creating an InventoryItemDetail Query......Page 341
Using the Label Wizard......Page 343
Modifying the Color Scheme......Page 347
Creating the DailyLoans Report......Page 348
Creating a DailyReport Macro......Page 349
Creating a Scheduled Task......Page 351
Modifying the Daily Report Macro......Page 354
Summary......Page 355
Using Linked Tables......Page 357
Project Overview......Page 358
Upsizing with Access......Page 359
Using the Upsizing Wizard......Page 361
Viewing the Upsizing Results......Page 368
Adjusting the OpenRecordset Code......Page 370
Installing SQL Server Migration Assistant......Page 371
Configuring a SQL Azure Database......Page 374
Migrating the Data to SQL Azure......Page 377
Viewing the Migration Results......Page 383
Linking the Views......Page 385
Data Macros with Linked Tables......Page 386
Summary......Page 387
Simulating the Access Runtime......Page 388
Understanding the Filename Extensions......Page 391
Modifying the Application......Page 392
Supporting Images in a Distributed Environment......Page 393
Modifying the Application......Page 394
Relinking the Linked Tables......Page 395
Creating an Executable File......Page 396
Installing the Package Solution Wizard......Page 397
Using the Package Solution Wizard......Page 399
Deploying the Installation File......Page 405
Summary......Page 408
Publishing to the Web......Page 409
Updating the Data Macros......Page 410
Using the Compatibility Checker......Page 415
Publishing to Access Services......Page 416
Exploring the SharePoint Site......Page 418
Exploring the Access Database......Page 421
Restoring the VBA Code......Page 422
Fixing the Default Value......Page 423
Using Web Databases......Page 425
Creating Web Forms......Page 428
Creating a Category Web Form......Page 429
Creating a Media Web Form......Page 431
Creating a Customer List Web Form......Page 432
Creating a Navigation Form......Page 433
Setting the Default Web Form......Page 434
Creating the Initial Form......Page 436
Creating the InventoryItem Subform......Page 437
Adding the Picture and Web Browser......Page 438
Adding an InventoryItem Record......Page 442
Providing a Search Feature......Page 444
Modifying the Navigation Form......Page 445
Summary......Page 446
Creating the OverdueItems Query......Page 449
Creating a Data Macro......Page 452
Adding a UI Macro......Page 453
Sending the E-mails......Page 454
Creating the OverdueItemDetails Query......Page 455
Implementing the VBA Code......Page 457
Sending the E-mails......Page 460
Understanding Data Collection......Page 462
Defining a Data Collection E-mail......Page 463
Processing the Replies......Page 475
Resending the E-mail......Page 478
Summary......Page 479
Linking a SharePoint List......Page 480
Creating a Team SharePoint Site......Page 481
Creating a Linked Table......Page 483
Using the Linked Tables......Page 485
Modifying the Data File Name......Page 488
Creating the Linked Table......Page 489
Using the Linked Table......Page 492
Importing an XML File......Page 494
Understanding the XML Import Process......Page 495
Importing the Exchange Rates......Page 496
Summary......Page 500
Using Timers......Page 501
Adding a Digital Clock......Page 502
Creating Simple Animation......Page 503
Calling the Windows API......Page 505
Creating the UserName TempVar......Page 507
Storing the CheckOut User......Page 509
Displaying HTML Content......Page 510
Modifying the Item Form......Page 511
Passing HTML Content to a Web Browser Control......Page 512
Adding a Chart......Page 515
Summary......Page 519
Understanding Disabled Content......Page 520
Trusting a Document......Page 524
Creating a Certificate......Page 529
Package an Access Database......Page 530
Installing a Signed Database......Page 532
Configuring Sandbox Mode......Page 536
Encrypting an Access Database......Page 537
Summary......Page 539
Downloading the Template......Page 540
Publishing the Database......Page 542
Setting Up Your Employee Record......Page 544
Exploring the Access Client Application......Page 546
A......Page 551
C......Page 552
D......Page 555
F......Page 557
I......Page 558
L......Page 560
M......Page 561
P......Page 563
R......Page 565
S......Page 567
T......Page 568
U......Page 569
X, Y, Z......Page 570