Online SQL Server Database Demonstration

Combining an online SQL Server Database for data collection and an Access application for data analysis can be a powerful tool. If there are many clients they can use a browser (Internet Explorer, Firefox etc.) to input their data on a Website in an easy and accessible way. The main users can then run an Access application connected to the online SQL Server database to carry out more detailed work on the data.

Examples applications:

  • Online Grant Application Forms
  • Medical Trial Results
  • Questionnaires
  • Online Booking
  • Volunteer Activity Information

This demonstration of an online SQL Server Database illustrates the collection of feedback information from the provision of a service. The demonstration allows you to register, log in, fill out a questionnaire form, view a list of completed forms and edit them.

This information is stored on a secure SQL Server database host. The information gathered by this browser based application (Internet Explorer, Firefox, etc.) can then be analysed by an Access Database linked directly to the online database, providing a level of detail not easily obtained using a browser.

This gives the combined applications the best of both worlds - the Website based online data entry gives easy access to the Questionnaire, while the Login gives the necessary security. The system user can use their direct link through Microsoft Access to analyse the data collected.