MiscroSoft Access Databases
Microsoft Access is a very useful database management tool written and supported by Microsoft.
Access is tricky to learn and this is probably the reason why I encounter ‘Systems’ written in Excel.
Excel is not really designed as a DBMS although it does have some great features including the charting element.
Power Bi has now superseded Excel for data dashboards in particular and Dax offers far more flexibility when it comes to working with aggregated data from multiple data sources.
Access does have its own table set and rules running under MicroSoft Jet. This is good for a couple of users sharing but if you need a multiuser database management system then you will need to consider an additional DBMS called MS SQL Server.
It is quite simple to generate data in SQL server and the table can then be indexed correctly and be part of a relational structure. Relational means that the system follows rules around referential integrity. The tables in SQL server are linked using ODBC unless of course you are stuck with the experimental version 2010 of Access which is fully integrated with SQL server. It soon stopped after a few years because it was over the top and made it difficult to port databases between versions.
The advent of the Office 365 suite has now made Access along with Excel & Power Bi a fully integrated DBMS with some serious data sharing power.
If you are serious about your data and need a system where people are restricted in what they can actually do (No more changed formulae or deleted cells). then give us a call.
Database Design
Database Development
ms access
System Design