Welcome to MIS Build, the home of the St John’s School MIS Database.
As the name of this project suggests this is an own build school database that has been built with the Microsoft Office suite of applications, Access and Visual Basic for Applications. After thousands of hours of work over a four year period we have decided to share the applications that we have developed on an open source basis and we are interesting in taking project further with other schools and database developers.
The project started with an Access database that was added on to an MIS system that was purchased from a major provider. The strategy of adding on to this MIS proved to be so successful that we eventually decided to switch off the bought in system and we now meet all of our data management needs through our own in house endeavours.
This MIS system has been designed for a UK independent preparatory school and it can it can be easily implemented for this type of school environment and it can also be adapted for any small to medium sized school. If a school wants to develop its own MIS system using MS Office then the project files on this website should provide a very strong starting point.
Because MIS Build started as a set of add ons parts of this project can be bolted on to your current MIS system. Access is particularly good at working with tables of data from more than one data source.
Using MS Office to develop an in house database system offers the following advantages.
- It leverages the functionalities of Microsoft Office maximising a school’s return on their investment in this software.
- It can be easily adapted to the schools needs.
- There is a huge, active and helpful community of forums and websites that can support MS Office development. Almost all of the problems that you might encounter can be answered with a well phrased Google search. There is also a wealth of printed material covering MS Office development.
- MS Office is in constant development and so for instance the new 2010 version of Access offers excellent integration with SharePoint 2010 offering a development path that should enable a school to easily and securely share information via a SharePoint website.
- There are a large number of Access developers so it is quite easy to find a good consultant to support a school’s use of this system if that is required.
- All of the backend database administration tasks can be carried out using Access and MS SQL Server.