Version 1901           Approx 8.7 MB                       First Published 18 Jun 2016                   Last Updated 20 Nov 2022

This application can be used to easily maintain students' network user names, passwords and email addresses.

It is a standalone version of an application which is also supplied with the School Data Analyser program.

It was originally intended for use in schools and colleges
However, it could easily be adapted for use with staff in schools or businesses.

Features include:
a)   creation of user names and email addresses based on specified formats
b)   random generation of passwords based on a specified number of characters and patterns such as words, upper/lower case letters and numbers
c)   management of missing and duplicate data
d)   sending email direct from Access using CDO

The application will run in 32-bit or 64-bit Access (version 2010 or later)

Main form


Edit Student Info form


Example Report


Admin Menu form


Random Password generator - format 6W3N - word with 6 or more letters followed by 3 numbers


Random Password generator - format 7ULN - 7 characters including upper/lower case & numbers



The free example database is supplied with a complete set of data for a fictitious school, Mendip Heights, in order to fully test the features of the application.

Click to download:  
      Student ICT Database v1901         (32/64 bit ACCDE)
      Student ICT Database help guide   (PDF file)

This application is supplied FREE as an Access 'executable' file (ACCDE)
This means that program code is NOT available for viewing.

If you would like full access to the program code, this can be purchased at a reasonable price.

An ACCDB file will then be supplied with full program code so you can enter your own data, modify the application or use parts of it in your own applications.

Click to purchase:  Full Source Code


Please use the contact form to let me know whether you found this example app useful or if you have any questions.

Colin Riddington           Mendip Data Systems                 Last Updated 20 Nov 2022

Return to Example Databases Page

Return to Top