• EddoWagt@feddit.nl
    link
    fedilink
    arrow-up
    6
    ·
    11 months ago

    Something like Microsoft Access is literally built to be a database, while I don’t have experience personally with that program, I’ve heard it’s miles better for that type of work than excel

    • Syndic@feddit.de
      link
      fedilink
      arrow-up
      5
      ·
      11 months ago

      Access has the benefit that it allows you to build a front end and can have a relational database on the back end. You also can use real databases such as SQL. So it’s definitely better in that regard than Excel.

      But of course it also has it’s limits in terms of speed and efficiency. I’ve definitely seen Access solutions which should have ported to a proper one years ago.