Good day. Requires advice. The task is to make a system in an educational institution for calculating and rating the pedagogical load. There is such a table in Excel, it will be supplemented and will be large. The problem is that it will be necessary to sample the groups, objects, and etc., and output to the report (as in Access) and print. How easier to implement? From options:

  1. Excel + Access (Only Access is inconvenient, because a large table is obtained), but the question arises how to make a report in Excel ...
  2. Web (php + mysql), but the question arises how to make a sample, such a complex table and print the generated report
  3. Vb.net + mysql, making the report is not difficult, but making such a complex table ...

What do you advise? Thank you in advance.

alt text

    2 answers 2

    In general, the taste and color here with friends is difficult. I think there will be experts on all 3m of your options and they will tell you that it is better to do just that. Choose you of course. As for the first and third options, I will not tell you anything. I think it can be solved without problems. As for the second:

    1. organize the database correctly
    2. make selections by tables and form html table.
    3. if you need to output it to excel, the phpexcel solution will help you, which your html table will easily convert to excel and give in the desired format.
    • Only php is slowly working with Excel files) but in general yes) - IVsevolod

    there will be ... and they will tell you what is better that way

    Exactly :)

    I have option 4: Excel . Himself one. And do not throw rotten tomatoes :)

    Of course, Excel without the help of a VBA friend will not do in any way, but with the proper organization of the data, several tens of thousands of lines are processed smartly.

    I admit, the option is not the best, Excel + Access is better. But it’s better if you can work with both brothers.