Skip to Main Content
Special Edition Using Microsoft® Office Access 2003
book

Special Edition Using Microsoft® Office Access 2003

by Roger Fennings
September 2003
Intermediate to advanced content levelIntermediate to advanced
1536 pages
42h 35m
English
Que
Content preview from Special Edition Using Microsoft® Office Access 2003

Chapter 20. Exploring Access Data Projects and SQL Server 2000

In this chapter

  • Moving Access to the Client/Server Model

  • Understanding the Role of SQL Server and ADP

  • Getting Acquainted with Access Data Projects

  • Working with SQL Server Tables in the Project Designer

  • Exploring SQL Server Views

  • Taking Advantage of In-line Functions

  • Examining Stored Procedures

  • Diagramming Table Relationships

  • Backing Up and Restoring Databases

  • Transferring the Project’s Database to a Server

  • Connecting to a Remote SQL Server Database

  • Linking Remote Servers

  • Securing Your Project as an .ade File

  • Troubleshooting

  • In the Real World—Strategic Database Schizophrenia

Moving Access to the Client/Server Model

Access 2003’s Access data projects (ADP), also called Microsoft Access projects or Access ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007

Teach Yourself VISUALLY™: Microsoft® Office Access™ 2007

Faithe Wempen
Pro Access 2007

Pro Access 2007

Martin WP Reid

Publisher Resources

ISBN: 0789729520Purchase book