I have to discuss the benefits of using a relational database compared to a spreadsheet for making a piece of software for the department of education designed to store information about schools, pupils and attendance.
Cheers
Jat
Cheers
Jat
Why is a relational database like access better to use than a spreadsheet for storing
- Thread starter jathayer
- Start date
To relate or not to relate, that is the question...
Please visit this link:
http://www.ecu.edu.au/pa/rswa/workshop/What are databases.htm:cool:
Please visit this link:
http://www.ecu.edu.au/pa/rswa/workshop/What are databases.htm:cool:
- Local time
- Today, 09:13
- Joined
- Feb 19, 2002
- Messages
- 46,908
The link is invalid.
The benefits of a relational database are not in the storing of data but in the retrieval of it and in the database's ability to "grow" without additional programming.
The benefits of a relational database are not in the storing of data but in the retrieval of it and in the database's ability to "grow" without additional programming.
Vassago
Former Staff Turned AWF Retiree
- Local time
- Today, 09:13
- Joined
- Dec 26, 2002
- Messages
- 4,748
gmlwong
Registered User.
- Local time
- Today, 07:13
- Joined
- Feb 7, 2003
- Messages
- 48
Jathayer:
I used to work for the Denver Public Schools and they have a very good and reasonably stable Master Student Database called SaSIxp...
It features record data for all 86+ schools, every student (86,000), all demographic data, all admin. data, all curricula, etc...pretty impressive...and yes, it is and has to be a database.
The biggest point to make to your prospective listeners/decision makers is that reporting off of a spreadsheet is far too difficult and cumbersome compared to what most any databases can do; whether it be MS Access, Crystal Reports, SPSS, etc...
Spreadsheets are exactly that...accounting and number crunching intensive calculations files...you can develop some pretty slick database-like functions in Excel using macros but why when the database is already waiting for you?
I used to work for the Denver Public Schools and they have a very good and reasonably stable Master Student Database called SaSIxp...
It features record data for all 86+ schools, every student (86,000), all demographic data, all admin. data, all curricula, etc...pretty impressive...and yes, it is and has to be a database.
The biggest point to make to your prospective listeners/decision makers is that reporting off of a spreadsheet is far too difficult and cumbersome compared to what most any databases can do; whether it be MS Access, Crystal Reports, SPSS, etc...
Spreadsheets are exactly that...accounting and number crunching intensive calculations files...you can develop some pretty slick database-like functions in Excel using macros but why when the database is already waiting for you?
Similar threads
