Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel problem...help!!!
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel problem...help!!!
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...o&userid=22362 View this thread: http://www.excelforum.com/showthread...hreadid=381102 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel problem...help!!!
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel problem...help!!!
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Problem viewing Excel 2003 Pivot Chart fields in Excel 2007 | Charts and Charting in Excel | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) |