Help needed - Access or Excel?

[missbee]

I am sorry if posting too much, but I am trying to figure out the best way to create a database and the more i find out the more questions I have!

I want to create a questionnaire front database for the teachers at school - why did I volunteer? But anyway. I need the functionality where I can go to open the questionnaire, go through a page per subject category and click each subject category that the student/students have done in a project, then click on the student/s which would then create a record per student listing all the subjects the y covered in the project. In also want on the first page to put in the date, and importantly, by hand a unique identifier so if I want to look at the class overall I can sort by this code and eliminate the duplicate records for each student.

The relationship would be for the student table and date table.

The subjects I would want all as look up tables - would I need to create one table per subject category, i.e. not just ENglish, but English lit and how can I put in a toggle which can be clicked on to then transfer that code to the record?

Any ideas appreciated, sorry if you saw my last posts, as I work through this it is changing my requirements..

Also someone said that this might be better in Excel?

Thank you in advance

 

[gemma-the-husky]

the problem is that access is not as, well, accessible as excel

You will find stuff like this far harder to do in access than in excel (assuming you can find a way to do it in excel). If you are new and need quick results, then access may not be the best at this point.

access databases have to planned carefully. however, it's worth persevering with learning, because they are generally more powerful than spreadsheets for data handling.