Starting point - Excel DB

[erutherford]

I have about 25 customers, some customers have just 1 vehicle, while others have 2, 3 or more. I maintain all of them, both the customer and their car collection. I used to keep one workbook per customer. I would like to use 1 workbook for all customers and their vehicles. This would allow me to make improvements to just one workbook and all account will be improved. Where as before I was upgrading each workbook.

My starting point would be to create 3 tables (customer, car, work performed). Next would be to create an unique ID for each table?

One other question, is the Pivot table the same as a query in Access?

thanks

 

[Kyle123]

No, it's not the same.

Why not use Access? It's much better suited than Excel