When clicking the application form it goes straight onto my user form called “application form”. The button uses A recorded macro and generates onto my application form which is made using the “Toolbox”. Here is my application form:
My application form has a lot of VB coding to it, for example; when I have filed in all the box’s and press sent, it will reset all the box’s to there initial state, as well as bring up a message saying “Your Application has been sent” as shown here:
Here is some of the coding my user form (application form):
For my next button called “Contact Details” on my switchboard
I used a recorded macro. When pressed this button brings up another user form called “Contact Details” as shown here:
I chose a user form instead of designing it on Excel itself because I thought it looked a lot more professional and presentable. I didn’t use much VB coding for this, only for the “OK” button which then exits the user form. Here is the designing stage of it:
When clicking the “Applicants” on the switchboard as shown here
It will automatically show the application forms sent by the user on a database. The Education Department use this information as well as the schools. Here is what the database looks like:
As you can see it is layered all nicely for the Education Department to read fast. There is 2 recorded macro buttons. “Back” goes back to the switchboard and “Print” prints a copy of the database. Information is automatically stored into this database as soon as the user presses send on the application form as already shown. I used simple VB (Visual Basic) coding to get the data to be layered row after row. Here is the coding for this:
When pressing the “Exit” Button on my switchboard it closes AND saves the database and the whole program. As shown here:
Overall I used a lot of VB, to edit and use codes to make my system work.