Access Database

Access is a relational database management system (RDBMS) that is included in some versions of Microsoft Office. In its basic form it is comprised of the Microsoft Jet Database Engine, a simple graphical user interface (GUI) and a range of software development tools, but it can be used with Microsoft SQL Server instead of the Jet Database Engine.

Access is an intuitive database program that is designed to allow users to create their own tables, queries forms and reports and link them together with macros. It can be used in its ‘raw form’ and will function adequately as a basic database. But it really comes into its own when it is used as the back end to a purpose built user interface, with specifically designed input and query forms, which can enhance user control and data manipulation.

As one would expect, Access allows import from and export to most of Microsoft’s Office components (e.g. Excel, Word and Outlook). It can also access data from other sources, like Lotus 1-2-3, Open Office, ASCII, dBase, Oracle and SQL Server.

At Transition Computing, we have a team of specialist developers who can design Access Databases and create GUIs as the front end to meet any database requirement your business may have. All you need to do is tell us what you want your database to do and we’ll design, build and implement a system that will deliver benefits to your business both in terms of business processes and cost.

Please feel free to call us for advice and guidance about implementing a robust and efficient Access database for your business. We’re more than happy to talk and we’re confident we can deliver the optimum solution for your business.