MadSmiler Posted July 5, 2016 Posted July 5, 2016 Hi I'm fairly new to Microsoft access and i have been set with a task. I have been told to create a register for my school which will be a checklist for each form to see if they have brought all there equipment with them. I am trying to make it look like this for each form such as year 7 - group 1 Year 7.1 [TABLE=width: 500] [TR] [TD]Name[/TD] [TD]05/07/16[/TD] [TD]06/07/16[/TD] [TD]07/07/16[/TD] [TD]08/07/16[/TD] [TD]11/07/16[/TD] [TD]12/07/2017[/TD] [TD]13/07/2017[/TD] [TD]14/07/2017[/TD] [TD]15/07/2017[/TD] [/TR] [TR] [TD]Bill [/TD] [TD]Tick[/TD] [TD]Tick[/TD] [TD]Tick[/TD] [TD][/TD] [TD]Tick[/TD] [TD]Tick[/TD] [TD][/TD] [TD]Tick[/TD] [TD]Tick[/TD] [/TR] [TR] [TD]Dave[/TD] [TD]Tick[/TD] [TD][/TD] [TD]Tick[/TD] [TD]Tick[/TD] [TD]Tick[/TD] [TD]Tick[/TD] [TD]Tick[/TD] [TD][/TD] [TD][/TD] [/TR] [TR] [TD]Gary[/TD] [TD][/TD] [TD]Tick[/TD] [TD][/TD] [TD]Tick[/TD] [TD][/TD] [TD][/TD] [TD]Tick[/TD] [TD][/TD] [TD]Tick[/TD] [/TR] [/TABLE] I also need is so i can make a report to see when they haven't done it.
3s-gtech Posted July 5, 2016 Posted July 5, 2016 *Obligatory Access question* Does it have to be done in Access?
MadSmiler Posted July 5, 2016 Author Posted July 5, 2016 Nope, just thought it would be the easiest way as 40+ teachers need to access the same document.
3s-gtech Posted July 5, 2016 Posted July 5, 2016 Access can be truly terrible at multiple user access. It's a good while since I've tried anything that did this (horrendous, breakdown inducing commercial software based on Access db) but I would strongly suggest you look at doing this web based with MySQL. You'll be learning far more useful and transferable skills, and it'll work.
dapaulio Posted July 5, 2016 Posted July 5, 2016 Do you use lesson monitor in SIMS. you can add additional present codes that can mark the student as forgetting homework/equipment.
NotSoFast Posted July 5, 2016 Posted July 5, 2016 (edited) If this is just to be done daily by form tutors I'd use a shared spreadsheet with a tab for each year group, assuming your MIS doesn't support doing this without using an external solution. A Google spreadsheet would be easy, and you could have an analysis tab pulling together the top offenders using a query. I agree with earlier posters that Access is awful for multi-user scenarios. Edited July 5, 2016 by NotSoFast
jinnantonnixx Posted July 5, 2016 Posted July 5, 2016 (edited) I'm a big fan of Sqlite for small databases. It's the most widely used database in the world. This looks like a good way to manage it. SQLiteStudio Alternatively, and this is a bit of a curveball, have you thought about Google Forms? https://www.google.co.uk/forms/about/ Google Forms are quick and easy, and do all the heavy lifting of collecting data for you. Edited July 5, 2016 by jinnantonnixx
kearton Posted July 5, 2016 Posted July 5, 2016 Quite possibly my fave meme ever... https://cdn.meme.am/instances/500x/55060001.jpg 1
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now