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
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.
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
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.