excel problem...help!!!

[cloudet]

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...

 

[Snake Plissken]

Before u start to develop this system in excel u should consider certain
possibility. I think that the raw data should be stored in access files (
which still could be updated in standard way of course ) and excel should
be linked to these tables trhu ODBC channel. Target machine doesn't have to
contain access at all - just standard office that has access drivers. The
only thing u would do is to create user DSN source. It gives u a chance
both retrieving fresh data from access tables and make additional analysis
in excel... The way u collect data from these tables depends on query
structure hidden in excel makro and gives u additional possibility to
create pivot tables based on raw access data. What about that?

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?action=getinfo&userid=22362
View this thread:
http://www.excelforum.com/showthread.php?threadid=381102

 

[DM Unseen]

I would state it even stronger than Snake!

Never use Excel for anything beyond 1 simple tabel or some small
supporting tables. What you want(referential integrity, keys) can be
simulated/hacked/kludged in Excel. I did it just for fun to see if it
could be done. But I do not condone this for business practice. Pls
learn database moddelling (you seem to know something already) and use
a proper database. Follow Snakes advice, although if money is tight use
a free database(MS has SQL Express, but there are many alternatives out
there).

DM Unseen

 

[Tom Ogilvy]

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.