Student Sign In/Out Database

[roseannej78]

In the Learning Center, my boss wants a database to replace the old database (not MS Access) we are currently using. We keep track of students signing in and signing out of the Learning Center. He’s asked me to work on it. I’m hoping that we could start using this new database (see attached-created by "theDBguy") by mid-summer because we like it very much, but, of course, it needs modifications to meet the Learning Center requirements. I e-mailed theDBguy that created this and asked him if we could use his database. He said yes that we could use it and modify it to our liking. He said he would love to help, but he’s been really busy and he doesn’t know when he will be able to work on it. So I was hoping that you could help me. Attached is the database that we want to use. Also attached are the changes that we want. Please play around with it so you can see how it’s set up and check all the VBA codes, which I'm not familiar with at all. If you have questions, please don’t hesitate to ask me anything.



Thank you in advance!

Roseanne

[June7]

Everything you want can be done but will take time. We can help you with specific issues but major design changes is not something someone here is likely to take on for you. You just have to dig in and do it and when you encounter specific issue, post a question.

Some comments about the db and your desired changes.

A textbox instead of combobox will not prevent students entering someone else's banner ID, whether they learn the ID by hit or miss or otherwise - no system is perfectly secure and Access was not originally designed to be a secure multi-user interface. Nothing prevents student from getting to the data through 'back door'. Unless you publish the database as an executable, holding down the shift key while opening db will bypass most db option settings and the db is wide open.

The StudentTable is not a strictly normalized structure. Use of multiple yes/no fields for essentially the same data entity is an indicator of this and will likely cause issues with records searching and filtering. Is this a modification you implemented?