This looks like you have a single flat database with some reports. This can
easily be done in in excel by making a single table. Update it with each
event (data record), then use pivot tables to build your summary reports.
--
Regards,
Tom Ogilvy
"cloudet" wrote in
message ...
hi there everyone... i have a big problem about excel now... wondering
anyone could help me or not... Well, i'll try to tell u the story from
top to bottom first...
First of all, pls look at the diagram below :
[image: http://i7.photobucket.com/albums/y283/cloudet/scan.jpg]
I want to develop a system for keying in data for all of the students
in a college using excel, but i want to make it as compatible as access
where the raw data that will be inserted from the raw data table will
automatically updated the three table that i've mentioned in the
diagram above.In three of the table contains all of the available
student id....but in the raw data table there are only a few student
who took the exam in one month(iamgine this table is only for one
subject)....so not all of the data in the three other table will be
updated automatically(because all of the other three table contains all
of the stud id in the college)....hmmmm...i could do this manually by
checking which one must be updated n which one don't....but it took a
lot of time...can i have any button where i could click, n then it will
automatically sort n updated the other three tables.....
my second problem is that, what if the year ended 2005???will it
automatically create a new table consists of the same stud ID....BUT i
still want to keep the old data in 2005. Because the summarized table
will contain all of the data for one year only. Should i create many
summarized table from 2005 till 2020.....??????? :roll:
If u can, pls make it easier for me to update n no need for me to
continouosly create a new table for each month(for the pass n fail
table) and every year(for the summarized table).....because, then i
need to compile the summarized table in a graph report where i could
see wether there is a decrease or increase in the student's
performance.(pass or fail)
of course it will be easier if u do it in access, because it will auto
update the related rows according to the studID but i must do this in
EXCEL bcoz I MUST..... :roll: lol...
--
cloudet
------------------------------------------------------------------------
cloudet's Profile:
http://www.excelforum.com/member.php...o&userid=22362
View this thread: http://www.excelforum.com/showthread...hreadid=381102