Microsoft Access or SQL Server 2005: What's Right in Your Organization?
|
Summary
Learn when to use Microsoft Access and when to use SQL Server in your organization. This white paper discusses database needs, evolution, and challenges, the advantages, limitations, and myths of Access, and how to use Access and SQL Server strategically in your organization.
Microsoft Access solves many database problems, but not all, and neither do other tools. As the most popular database product in the world, Access offers the best solution for its range of capabilities. SQL Server is available for more complex solutions, offering the critical back-end database that lets organizations scale their important databases securely.
Organizations that effectively manage and deploy Access and SQL Server take advantage of the strengths of both of these industry-leading products, and give their organization a competitive edge financially and in response to user, market, and customer conditions.
Included in this document:
| • | Executive Summary |
| • | Strategic Mission and Vision |
| • | Database Needs in an Organization |
| • | Database Pyramid |
| • | Database Evolution |
| • | Database Challenges in an Organization |
| • | Access vs. Excel |
| • | Limitations of Access |
| • | Why Access is Important |
| • | Exploring the Myths of Access Limitations |
| • | Using Access Strategically |
| • | What to do with Access 97 Databases |
| • | Using SQL Server Strategically |
