Microsoft Access: I need help planning my first database

I am a new user to Microsoft Access and thus I am a little fuzzy on database design. I currently have several Excel spreadsheets with info on chemical concentrations at different locations my company manages. Each of these spreadsheets is organized by location name and test date. I have a spreadsheet for each of the chemicals that needs to be tracked; 7 sheets currently with more to come in the future. These sheets essentially have a column of location names on the far left and a row of dates that chemical tests were taken on the very top. So each sheet looks something like this.

          June-13    July-13    Aug-13   ...

Location 1

Location 2

Location 3

...

Each Location and date is repeated on each spreadsheets; the only difference between the 7 of them is the type of chemical they track. I have already transferred each of these spreadsheets into Access tables. I have also created relationships between the location name data by creating a location table. This allowed me to create a query & form to search through the data by location name. The problem is I am inexperienced with MS Access and am not sure how to rearrange my original tables to allow for Date and Chemical type search. Ideally I would like to set up my database to allow for a query and form to let others search through this data by location name, date, and chemical type. I understand the basics of query and form design but my data does not seem to be planned out in such a way to allow me to search by anything by location name. Can anybody suggest a way I can layout my tables or create new tables to help me do this? any help is appreciated as I am very new to MS access.

Thank you.