Users appreciate Access’ strong integration with other Microsoft Office applications and the familiar look that makes it easy to get up and running quickly. Whether you use your database to manage contacts and customers or creating a tracking system for inventory, Access provides an easy way for all levels of desktop users to find, manage and share data.

    Access brings not only the traditional broad range of easy data management tools but also adds increased integration with the Web for easier sharing of data across a variety of platforms and user levels and additional ease-of-use enhancements to assist with personal productivity.

    As evidenced by many of our applications that have been in production for years, Access can act as a front-end client to corporate-level, back-end databases, such as Microsoft SQL Server. Access can be used in two ways: as a standalone application for creating databases for individual or departmental use or as an easy-to-use interface client to a more scalable and robust back-end database that was previously only available to professional database administrators (DBAs).

    Microsoft Access supports OLE DB, a standard for data access. This allows Access to connect directly to Microsoft SQL Server instead of using the Jet engine, the traditional default database engine in Access. Power-users and developers may now create solutions that combine the ease of use of the Access interface (client) with the scalability and reliability of Microsoft SQL Server.