Recent content by lukestkd

I've addressed the structure, and created some queries which I think now show the structure is working correctly. What do you think of what I have changed thus far? The next step would be creating the forms?

As the feedback is fixed to the level and the project (and is not repeated) would it be easier to get rid of tblFeedback and put these statements in tblProjectLevelFeedback?

Thats right, one level for one project, but six different levels to be entered for each student overall (one per project). What should I do to adjust the structure for that? If keeping the class data seperate and linking that would work fine for me. Very novice Q (last access use was back...

I have six classes, containing 30 students, so about 180 in total. I need to group the students by class. Every student will do the six projects during the year, in the same order. So yes, a project has many students, and a student will have six projects. A student could have any level on...

Hi, Many thanks for your reply and advice thus far. A student will progress through the grades over a year, but will only receive one grade per project. So if the projects were named Project 1,2,3,4,5 instead of Scratch, Computer Control etc, then a student is likely to: Start on a 3c with...

Hello all, I am making a database for my ICT department. Attached as a ZIP file, 03/10 versions attached, but working from 10. It needs to contain: Student, Class, Project, Level, Feedback So far I have: tblstudents, tblClasses, tblProjects, tblLevels. tblFeedback. Which all feed into...

Thanks Plog. I've tried this, however our class codes are number letter letter letter number e.g. 9xIt2, and the number type won't let me enter it as this.

Hello all, I am making a database to store homework set within our school department. I want to run a query that feeds a report showing records sorted by class. Class codes range from 7x to 13x, access defaults to ordering this 10,11,12,13,7,8,9. Where I require 7,8,9,10,11,12,13. Can this...

Many Thanks for that, I've had a good look at it but I'm struggling to fit in to my system: I meant to mention this above: I would like to select the keywords to search for from a combo box, with a maximum of five keywords at a time I would then like to be able to select a start and end date for...

Hello, I am developing a system for my university studies which will allow me to manage the resources I have collected through my time in education. I currently have three tables, one which stores the 'Article Data', such as title, hyperlink to resource, date published etc. 2nd Table has a...