Professional Sql Server Development with Access 2000 - Softcover

Dobson, Rick

Softcover

ISBN 10: 1861004834 ISBN 13: 9781861004833

Publisher: Apress, 2000

Synopsis

This book deals with the many issues involved in making the transition from Access to MS SQL Server. While Access (part of the Microsoft Office suite) has long been the small business database of choice, for enterprise level solutions SQL Server is required. Microsoft is actively encouraging users onto this more sophisticated platform by making Access 2000 compatible with SQL Server. This means solutions can be developed using Access and easily scaled up to the more powerful SQL Server when the need arises.

About this title

Review

Professional SQL Server Development with Access 2000 shows the experienced database programmer or administrator how to take advantage of SQL Server using the built-in tools and capabilities of Access 2000. Filled with screen shots and plenty of practical advice for working with data, this book proves that Access is a great tool for getting the most out of SQL Server.

Usually associated with the lower end, Access 2000 has clearly grown up with the features that let you connect to SQL Server 7/2000, but with the convenience of a graphical tool. The book covers not only the features of Microsoft databases, but also how to rely on Access 2000 as your tool of choice for common administrative and programming tasks. Starting from table design, plus the powerful database diagramming tools available in Access, you learn how to create effective database designs, with a full discussion of joins, indexes, constraints, views, and other advanced features that make this book good for even more advanced readers. Besides admin functionality, there's coverage of VBA for database programmers and T-SQL, Microsoft's version of SQL, including an excellent section on stored procedures and triggers.

While there's a lot of textual description in this book, there are also plenty of easy-to-understand screen shots, making this a useful resource to have at your desk. The graphics that detail the use of Access 2000 toolbars (which list the functions for each tiny button) are very good. The tutorial turns towards using Access 2000 features (forms and reports) to work with SQL Server data on the back end. Later sections examine the options you have for Web development, including Access's own Data Access Pages, datasheets, and a short introduction to using Active Server Pages on Microsoft IIS.

Reference sections of database security and upsizing older Access databases to SQL Server help round out this comprehensive and thoughtfully written book, which shows that Access 2000 really can let you access higher-end features on today's Windows platform. It's perfect for any administrator or database programmer who wants to benefit from Access and SQL Server used together. --Richard Dragan

Edition details

• Publisher: Apress
• Publication date: 2000
• Language: English
• ISBN 10: 1861004834
• ISBN 13: 9781861004833
• Binding: Paperback
• Number of pages: 700