Good morning! This is my first post and I'm a bit stumped with Access. I have several large excel data files. They contain sales history from the past five years. The rows are essentially: SKU, Item Description, Store Location, Increment of Product (either weight or single unit), Total Units sold, Total Sales and Period within the year. I don't know how to breakdown the files into relevant tables that would have a relationship.
I know the SKU is the most important because I want to be able to run queries showing what where the total sales/units sold over the life of the item, potentially broken down by period. Any help would be greatly appreciated!