General :: Searchable Artwork Database

We have a database that has the records of the artwork that we own. (We are a textile company). This database is used mainly to record any new artwork that we buy and to add information such as size, category, style, etc. We now want to be able to link all the scan images for this artwork to each record in the database. I know how to do one record at a time by linking it to the scan image, but is there a faster way to automatically do it because we have about 13,000 pieces of artwork? Each record has a unique artwork number that we also used to save the scan image and all the scan images are in one folder.

Then once we accomplish this, we need to be able to create a way that the design staff can quickly search the artwork. The goal is for the designer to specify certain parameters, like size, category and style and then have Access provide all the images that follow the parameters.