I have nearly no access experience. I'm using access 2007. I have a few tables in a db that I imported from excel. Each table has 1,000 to 2,000 rows and 30 columns. Each table however has one common column (ID name). Each table has different corresponding data with the exception of the common column. I would like to perform an action ,"quirey" I think, where I can see all the data from all my rables pertaining to a specific item ID? I think I have to establish relationships but I really have no idea where to start any help is greatly appreciated!!!!