Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to store my students' information such as marks, etc. And I need a way to make calculations on this information. I also want the application to make it easy to fill students' information (in the beginning of the term) and to publish their marks online later on.

Should I use MS Excel or MS Access? When should I use one of them over the other?

share|improve this question

closed as primarily opinion-based by and31415, LPChip, Doktoro Reichard, Journeyman Geek Aug 10 at 5:43

Many good questions generate some degree of opinion based on expert experience, but answers to this question will tend to be almost entirely based on opinions, rather than facts, references, or specific expertise.If this question can be reworded to fit the rules in the help center, please edit the question.

5 Answers 5

I would go for MS Access because if a user has to fill in the sheet, it becomes prone to errors. MS Access is a database and can calculate fields and protect fields based on earlier entries. It is more advanced to build the sheet, but if done properly, it will be far easier to fill in. Additionally, it is easier to generate a proper report showing just the information you want to display, not everything. This is also possible with Excel, but a lot harder to do.

If there isn't much calculation to be done, and the application does not have to be that extensive, Excel may just do it. But Excel is meant as a sheet that you work in, not as a database, where Access is meant as a database with different methods to fill in the information and extract other information.

If you are the only person to work in the sheet all the time, Excel is probably a better choice if the data and calculations and reports are limited.

share|improve this answer
    
+1 and also most applications quickly get into requirements for separate related tables, each with a unique granularity. Access shines at this whereas Excel is very weak. In this example you might well need separate tables for Students, Courses, Students in Courses, Marks for Students in Courses ... –  Mike Honey Aug 10 at 23:20

Storing students' information and performance would be easy in either Excel or Access. In Access, OP would just need one table. However, calculations are much harder in Access, because the function interface is highly nonintuitive. Also, using calculation in Access is overall far less intuitive, because functions operate on arrays, rather than on individual cells. Excel is probably the best choice.

share|improve this answer

I have been in similiar situation in the past. For the simple management of one course, I was able to do everything with Excel and also use this data easily to generate word documents.

Some years before I programmed a student management tool in Access. For this purpose (many courses, different tasks, different degree paths etc.) and the fact that the output and forms where used by other people and potentially less tech-savy staff Access was great. Also the data became much cleaner, as input validation got rid of some "best practices" used before.

So if it is just for your course, and next term you are only going to copy the file and use it as a template - go with Excel. If you are working together with other staff on the same data and want to manage data across terms etc. Access will be far better in the long run, but will require more work upfront.

share|improve this answer

One year, as a science teacher of a small private school, I had to do report cards for 300+ students because the grading computer system in place was no longer accessible (a mini-crisis of sorts). With no budget for more actual grading software, I was left to use Excel and/or Access to make report cards. I decided to use both Excel and Access. Here is why:

1) Excel was already being used to store grades, and overall is much simpler to create tables with. Access is a real pain to work with in terms of table development.

2) We needed to be able to combine multiple records and create reports. Access is designed to create reports from multiple tables with linked variables.

3) Access can do a dynamic link to multiple Excel spreadsheets, which updates the database whenever the Excel files change. This meant we didn't have to load things more than once.

All in all it went pretty well, though I will say that the system was definitely on the fritz and crashed a few times with so many tables being linked (this was with Office 2003). The nice part of working with database software though is that the data is locked and even a software crash does not kill your database file. I think Excel now has a lot more capabilities... so you might not need Access at all, though I've never created reports with Excel.

share|improve this answer

I think this is primarily opinion-based, but here we go anyway.

If you are not a computer professional, you should never use MS Access. I think it was very unfortunate that MS produced Access, providing the illusion that non-computer professionals can mess around with relational databases. If you try to do it, you will get it seriously wrong.

If you are a computer professional, then the question becomes seriously opinion-based. If the problem I'm trying to solve has a low budget, I usually prefer simpler solutions that anyone can understand, rather than something that will become unmaintainable the moment I leave or the moment the money flow is hindered or the moment that I don't have enough time to maintain it. If I have a higher budget, I usually prefer other database systems.

share|improve this answer
3  
Access and Excel are tools. The fact Excel is more intuitive to use than Access does help justify the dislike some people have against Access but they remain tools: one can learn to use them effectively given enough work. –  Doktoro Reichard Aug 9 at 17:37
2  
Excel ceases to be simpler than Access when it doesn't fit with the structure of your data. I've seen too many examples of people reinventing Access within Excel, using VLOOKUP and complicated VBA –  James_pic Aug 9 at 18:07
    
@DoktoroReichard A Boeing 777 is also a tool, isn't it? You can certainly learn to use it given enough work. However, you will not do that amount of work unless you intend to become a professional pilot. –  Antonis Christofides Aug 9 at 20:09
    
@AntonisChristofides I know quite a few people who learn to fly heavy jets because they can not but because they want to be a professional pilot. Anyone can learn Access if they wish. I know it quite well and will never be a professional programmer. –  wbeard52 Aug 9 at 20:13

Not the answer you're looking for? Browse other questions tagged or ask your own question.