• taiyang@lemmy.world
    link
    fedilink
    arrow-up
    11
    arrow-down
    1
    ·
    11 months ago

    Technically even Access would make more sense. Isn’t that part of the same office package or does that cost more?

    Granted, SQL is still better but I’ve worked in government where you’re lucky to be using digital sheets at all.

    • stoy@lemmy.zip
      link
      fedilink
      arrow-up
      11
      ·
      11 months ago

      I specifically avoided mentioning Access as I have hear horror stories about it when it goes too far.

      • taiyang@lemmy.world
        link
        fedilink
        arrow-up
        6
        ·
        11 months ago

        All those stories are 100% true. And when someone did end up hosting an Oracle based SQL database, they’d pull from it in Access and it’d take several hours for one query. My R code did the same in about 10 seconds.

        It’s not good software. Lol

        • stoy@lemmy.zip
          link
          fedilink
          arrow-up
          3
          ·
          11 months ago

          Access has its uses, need a database to catalog your (parents) physical photo albums, or perhaps you want to have a database for recipies at home to make them easier to find, then in those cases Access should be fine if you are willing to maintain it.

      • not_again@lemmy.world
        link
        fedilink
        arrow-up
        1
        ·
        11 months ago

        Reminding me of corrupted .mdb files means I need more alcohol tonight to pacify the demons in my head

    • MacN'Cheezus@lemmy.today
      link
      fedilink
      arrow-up
      5
      ·
      11 months ago

      Isn’t that part of the same office package or does that cost more?

      Not sure about the current state of things since I haven’t used MS Office in decades, and I believe it’s entirely made of web apps now, but Access definitely used to be extra. As in, there always were at least two editions of Office, one that included Access and one that didn’t. And the former was significantly more expensive.

      • TheActualDevil@lemmy.world
        link
        fedilink
        arrow-up
        4
        ·
        11 months ago

        I actually know this one. Access is available through the MS Office 2019 bundle officially and they pretend it’s not really there with 365, but if you have Office365 you can download the app version to work offline. Access still doesn’t show up on the main list in the app, but if you search it’s there. There’s also a way to search it in apps online in 365 but it just downloads it and only runs in the app.

        I recently went back to school and the basic degree requirements necessitated an intro to CIS class. It was just a glorified MS suite class. But I had an interesting time figuring out how to get to Access and no where online makes it clear. That’s the main reason I typed this out. Maybe some day someone else will have the same issue and this comment will show up on a search and be able to help them. You’re welcome future person!