"We have been very pleased with the competent, prompt and courteous service they have provided to us."Stu Perlman
Database systems are comprised of a Front End and Back End. The term Front End refers to the user interface which consists of the screen forms and reports. The Back End has the tables that store the data, including the relationships between the tables, data queries and other behind the scenes technology that accepts information from and displays information to the user via the Front End.
In a Microsoft Access database, it starts off as a single Microsoft Access computer file containing both the Front End and Back End. The file extension is .mdb prior to Access 2007 and .accdb for Access 2007 and later. This single file arrangement works fine for a single user. If the database has more than one user it should be “split” into a separate Front End file (FE) and Back End File (BE). This will allow the database to operate well for up to 10 concurrent users and as long as the BE does not need to be used over the Internet. So it works fine on computers networked in the same office.
If some or all of the database users will be working with the database via a web browser Front End instead of a Microsoft Access FE a different process is used to create the FE. A web browser based Front End cannot be created in Microsoft Access it has to be programmed using languages such as VB.NET or C#.NET in Microsoft Visual Studio.
If the database will be storing more than 2GB of data you will need a more powerful BE than the one included with Microsoft Access. Microsoft offers Microsoft SQL Server 2014 Express Edition, which is capable of storing up to 10GB of data. Microsoft SQL Server 2014 Express Edition is also needed to support users working with the database via a web browser. Microsoft SQL Server is free and serves the needs of 95% of WSI’s customers.
WSI does not recommend SharePoint or Office 365 as a FE or BE for your database. The reason is that Microsoft limited the functionality of SharePoint and Office 365 to inhibit people from creating malicious software that would be on Microsoft’s servers.