Microsoft Access or SQL Server: What's Right in Your Organization?
|
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:
| • | Database Needs in an Organization |
| • | Database Evolution |
| • | Database Challenges in an Organization |
| • | Access versus Excel |
| • | Database Solution Costs |
| • | Advantages and Limitations of Access |
| • | Exploring the Myths of Access Limitations |
| • | Using Access Strategically |
| • | What to Do with Access 97 Databases |
| • | Using SQL Server Strategically |
