It is a long long time since my last Ms Access project. I never use Ms Access in my work. But this time have to develop a simple database system for training assignments, a small project for myself.

The previous trainer use manual way to assign trainings . I almost fainted when receive stacks of student profiles in hard copy! Since this is individual training, I have to go through who should be assign in next training, which topic and so on. The look like “simple” job took me at least 1 hour to arrange schedule for a month!

Computerized Training Assignment System

I told myself MUST come out a database system myself no matter how hard it is! Of course the easiest way is Ms Access Database.

From create Table > Query > Form > Report, it recall back my programming skill that almost return back to lecturer. When need some function code or VBA coding, I search in Google to get answer.

I’m happy the very first version of the training assignment system has been accomplished. Now planning for second edition. I found our own small project is more interesting than work, should do it more. No wonder Google Inc want their staff to have their own project too.

What I’ve learned?

I’ve learned some coding that I never use before, such as ” drop down list in query” and “query of the query”. Also, I’ve learned to protect Ms Access database coding. They are two methods: password protected (as normal excel password) and make an MDE.

MDE refer to executable version of Ms Access. With MDE, others can only run the database program without seeing or changing your coding. It can use to protect your code as well as accidentally remove the codes. Do you have your own project? Please share with me, I want to hear from you.

PS: MDE can be run on Ms Access Runtime environment. It is FREE to download and install.