Microsoft Access 2010 Bible

xxix

Contents

Chapter 31: Distributing Access Applications . . . . . . . . . . . . . . . . . . . . 1083

Defining the Current Database Options...........................................................................1084

Application options ...............................................................................................1085

Navigation options ................................................................................................1089

Ribbon and toolbar options ...................................................................................1090

Name AutoCorrect Options ...................................................................................1091

Testing the Application before Distribution .....................................................................1092

Polishing Your Application .............................................................................................1094

Giving your application a consistent look and feel .................................................1094

Adding common professional components ............................................................1095

Bulletproofing an Application .........................................................................................1098

Using error trapping on all Visual Basic procedures ..............................................1099

Separating tables from the rest of the application ..................................................1099

Documenting the application ................................................................................1100

Summary ........................................................................................................................1100

Part V: Access and Windows SharePoint Services 1101

Chapter 32: Understanding Windows SharePoint Services  . . . . . . . . . 1103

Introducing SharePoint ...................................................................................................1104

Reviewing Various Types of SharePoint Sites...................................................................1106

Working with SharePoint Lists ........................................................................................1107

Looking at a SharePoint Web Site ...................................................................................1108

Editing SharePoint list items ..................................................................................1110

Creating SharePoint lists........................................................................................1112

Summary ........................................................................................................................1115

Chapter 33: Integrating Access with SharePoint . . . . . . . . . . . . . . . . . . 1117

Introducing SharePoint as a Data Source .........................................................................1118

Sharing Access Data with SharePoint ..............................................................................1119

Linking to SharePoint lists .....................................................................................1119

Exporting Access tables to SharePoint ...................................................................1123

Moving Access tables to SharePoint .......................................................................1127

Using SharePoint Templates ............................................................................................1131

Summary ........................................................................................................................1134

Chapter 34: Understanding Access Services . . . . . . . . . . . . . . . . . . . . . 1135

Explaining Managed Applications ...................................................................................1136

Looking at Web Publishing in Access ..............................................................................1137

Why SharePoint? ...................................................................................................1137

Leveraging SharePoint features ..............................................................................1137

Publishing Access applications to SharePoint ........................................................1138

Understanding Access Services ........................................................................................1140

02_475348-ftoc.indd xxix02_475348-ftoc.indd xxix 4/1/10 1:42 PM4/1/10 1:42 PM