I have an Access database with tables that I would like to set up in a new query and set parameters for. I have seen people use excel, and they can enter in date, time or other criteria into a cell and have the data from Access be updated to those criteria with charts and histograms updated. I am at a complete loss on how to start, I know that in Access, you have to type in something like =[Date:] for a parameter. But what if I also only want dates pulled from Access after 1/1/2013? Also, I will have many parameters, but I will not necessarily use them each time. For example, I may have Date, Name and Time but will only have a parameter value for one or two of the parameters and the rest will be left blank.

This kind of crosses over to Access database knowledge so I am not sure if this is the right forum to post in, but any advice is appreciated.