Access logo

Access Database Design

Since 1994 ACCESSible IT Limited has specialised in Microsoft Access databases, Visual Basic for Applications (VBA) and Sql Server database development. We create bespoke, reliable, legal, secure, robust databases and applications using Access, Excel, Word and Outlook for personnel management, absence monitoring, document management, caring services, bulk e-mailing, SMS Messaging, billing, work-in-progress, costing, training timetables and classroom allocation. These systems support clients in central and local government, the engineering and automotive industries as well as commerce and the charitable sector. Our clients are based in Coventry, Warwickshire, West Midlands, Nottinghamshire, Leicestershire, Northamptonshire, Devon and London. We use TeamViewer to provide remote guidance, support and training.

We offer experienced, sound, commercially unbiased, free of charge advice about trends, issues, bugs and best practice for a proposed or existing Access or SQL Server database - We understand the limits of these products, we can guide you through a project that will not fail.

Microsoft Access Database Design

MS Access is a rapid application development tool for creating relational databases quickly. First published in 1992 , it has become a solid and reliable platform for data management. It has a first rate reporting package as well as the ability to share data with the Office suite and Power Pivot.

The advent of Office 365 and SharePoint has seen new life breathed into the product with the ability to use it for web-databases.

Visual Basic for Applications (VBA) Design

VBA is the common feature that allows all the MS Office applications (Excel, Word, Outlook etc) to manipulate and share data. The simplicity of the language means that development time is short - systems can be built in days where other languages take weeks. The current version of the language appeared in 1993, it is a mature and stable programming language.

SQL Server Database Design

SQL Server is now our preferred back-end data store for MS Access because in 2007 full user level security was removed. We specialise in developing robust data models upon which the whole system can rely as the business changes and develops. The history of SQL Server can be read here. Access links into SQL Server so that you can query and report on the data in exactly the same way you would with a 'normal' Access database. Using SQL Server as the back-end means, of course, that you are not limited to a small set of simultaneous users. And, best of all, SQL Server Express is free!