Searching for a single word in all table

[rielcas]

Hi I'm extremely new to Access and I have created a fairly large database for inventory where I work. The thing that I would really like to do is to be able to search ALL of the tables I have created for a term. For example if I wanted to find out where a bottle of 70% alcohol is, is there a way I can search through all the table I created for "70% alcohol" and it will tell me where it is located in the database?!?!

[BCJourney]

It sounds like you need to normalize your data first. You should have separate tables for related information. In this case if you have one table that simply has "Item" and "location" as in 70% alcohol and closet then you could simply open the table, highlight the field (column) you wish to search, "item" and type in "70% alcohol". This would take you to the record. You can also create a form based on the table and add a combo box to select item you are looking for. I'm not sure if you're referring to where it is located in a different context. If i misunderstood you purpose, please let me know.