Originally Posted by
Ajax
definitely
size should not come into it. What matters is good database design. Applying excel principles (which combine storage with presentation) is not the way databases work. tables store data whilst queries, forms and reports present data. Go down the excel route and you will quickly run into trouble.
Besides, your table B does not require a record for location 1, account 1, period 05/2020. Your picture in post #6 has 6 rows which are not required.
Also, none of your tables have a primary key.