Microsoft Access 2010 Bible

Part VI

Access as an

Enterprise Platform

IN THIS PART

Chapter 36

Client/Server Concepts

Chapter 37

SQL Server as an Access

Companion

Chapter 38

Upsizing Access Databases to

SQL Server

O

ver its many versions, Access has increasingly

been used in enterprise environments. No other

desktop database provides access to as many dif-

ferent data sources as Microsoft Access, yet supports an

attractive, easy-to-use interface. Access has been used to

create every conceivable type of database application, from

managing kids’ soccer teams to handling accounts receiv-

able for Fortune 500 companies.

Each version of Access has extended previous capabilities

as an enterprise development platform while introducing

new features geared to client-server database applications.

Access 2010 seamlessly integrates with all current versions

and editions of SQL Server without sacrificing performance

or ease of use. Even beginning developers can succeed in

working with large SQL Server databases using Microsoft

Access as a development tool.

The chapters in Part VI explain client-server computing

from the Access developer’s perspective. I explain the

essential SQL Server features and technologies involved

when consuming SQL Server data on Access forms and

reports, or when upsizing an existing Access database to

SQL Server. In these chapters, you’ll learn about SQL

Server data types, SQL Server stored procedures, and how

to integrate server data with your Access applications.

44_475348-pp06.indd 118144_475348-pp06.indd 1181 4/1/10 1:59 PM4/1/10 1:59 PM