Hi, I started a spreadsheat in Excel and decided I needed to put this in Access because I needed to add photos of all the records. I transferred the spreadsheet into Access successfully and the table shows up. However, the table has too many columns of data. This is for an art collection inventory. I need to keep up with all the art purchased, improvement of the art, and art sales. Would I need to setup tables like this?? I will have several restoration items, frame, cleaning, appraisals, etc. for one painting. I will have a report that shows how much I have in each painting so I will know what to sell it for. Is this possible??
Thanks for your help!! I am feeling a little lost, I have watched several normalization videos and I just don't get it. Table 1 is the spreadsheet I transferred with over 377 records.
Table 1 Painting Table 2 Restoration Table 3 Sales ID ID ID Artist Title of Painting Title of Painting Title of Painting Date Date Cirra Vendor Sold To Size Item Price Medium Cost Profit/Loss Date Acquired Purchase Price Wholesale Price Price Current Location Notes Photo