The Rational Guide to Microsoft Office Access 2007 Templates

Overview     15
Introducing Access 2007 Templates     17
The Template Concept     17
Why Access Has Templates     18
How Access Uses Templates     19
Getting Started: Choosing a Template     20
Getting Started: Creating a Database from a Template     23
Getting Started: Basic Templates     25
Getting Started: Templates for SharePoint     27
Summary     29
The .Accdt File Format     31
Why Access Uses .Accdt Files     31
The Open Packaging Convention     34
Where to Find .Accdt Files     35
Summary     38
How Templates Are Used     39
The Historical Perspective     39
Tracking Specific Data     43
Security and the Trust Center     43
Category Types     49
Summary     52
Creating a Basic Template     53
Build a Simple Application     53
Download and Install the Access Developer Extensions     54
Save Your App as an .Accdt     54
Something Extra     56
Summary     58
Designing and Sharing Templates     59
Deciding toBuild a Template     61
Template Appropriate Solutions     61
Excepted Features     63
Summary     68
Refined Application Experiences     69
Simple Targeted UI     70
Drill-through Data Editing from Reports     73
Hyperlink-Style Buttons     77
Temporary Variables (TempVars)     79
Summary     81
User-Customizable Applications     83
Data Filters     84
Custom Fields on Forms and Reports     94
Appearance of Forms and Reports     99
Individual Reports and Forms     102
Navigation to User-Created Forms and Reports     104
Summary     108
Controlling User Experiences     109
Startup Forms     110
Autoexec Macros     111
Navigation Settings     113
Customizing the Ribbon     117
Summary     126
Personalization     127
Role Selection     129
Per-Role UI Customization     133
Summary     134
Design for SharePoint     135
Supported Field Types     137
Data-Level Features to Avoid      138
Referential Integrity     138
Query Performance     140
Offline Database Limits     141
Summary     142
Branding     143
Setting a Template's Getting Started Icon     144
Form and Report Logos     145
Setting Category     146
Using AutoFormats     149
Control Default Formats     155
Watermarks     156
Summary     157
Template Security     159
Disabled Mode vs. Enabled Mode     160
The Untrusted Assumption     163
Trusted Locations vs. Digital Signing     164
Summary     166
Sharing Templates     167
Sharing .Accdt Files     167
Installing Template Files     169
Summary     170
Advanced Template Topics     171
Template File Anatomy     173
.Accdt File Structure     173
XML File Formats     176
Text Format Files     184
Summary     185
Template Collections     187
Advantages     188
Homogenization Process     203
Summary     204
Enterprise Template Deployment     205
SharePoint List and Site Templates     206
Customizing the Enterprise Desktop     209
Summary     213
Generating Templates without Running Access     215
Uses and Practical Limitations     216
Assembling Data into an .Accdt     219
Delivering Custom Reports     228
Summary     229
Integrating Templates with Add-Ins     231
Advantages     232
Invoking Add-Ins from Untrusted Databases     233
Installing Add-Ins Using the Access Package Wizard     245
Summary     247
Extras     249
Index     251
Registering Your Book     256