Recent content by 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...

Okay do I need to create queries to make the relation between the tables before the form?

This is so hard! I used to be able to do all of this 5 years ago.. bah

Hi Ozzi Thank you so much for replying! Sounds lie you are a lot more knowledged than me. This is what is so complicated, in any one day 1 or all of the students could do lots of the different subject categories! In one record, I would need to select any of the students who took part in the...

Thank you! I have now created a table for each subject - with the subcategories of the subject in the same sheet. I see what you mean about getting out of Excel thinking ha ha! I guess I am going to amend what I am trying to do - what I now need to now how to do is create a table and form...

can someone please tell me how I can link lots of different forms together and click from form 1 to the next, to the next etc in one survey AND all the data go into one record as well please? If you have a sample one I could look at I would really appreciate it ;-) thank you in advance

Oops file attached

I have attached a file to show all the categories. How can I create records whereby I click on which ones I want to select and add a code to identify the teacher aids and date please? is it possible to have 400 variable columns or do I need to rethink how to do it?

I only have a few days and need to produce what feels like a monster questionnaire and database in Ms ACcess 2010 version. Lats time I used it was 2001 version so I need a lot of help please. I want to produce a database to collect data on which subjects my students have studied in a day. So...