Hey Everyone!
I just started trying to get into access and I long story short, I'm kind of lost trying to figure out how to get started learning how to use Access. In the past I've done 95% of my work via excel. I started using that to create simple forms and eventually used it to create data tables for analysis.
I'm working on trying to create a type of free-form filter (for lack of better term) for this massive data sheet I have in excel, but unfortunately I think I've reached the limitations of what excel can do and I'm thinking I may have to explore Access if I want to do it right. By free form filter, I mean a filter where the user can input a list of criterias, in any order, and that the table will output that value onto a sheet. The closest example I can get to this is like McMaster Carr and how if you want to search for an item, you initially start with a huge selection of categories and each time you click another category, it updates the next selection list based on what you have previously selected and so on until you get one or two items.
Like I said, I am ultra new to Access and I'm just trying to wrap my head around this beast of a program lol any help would go a long way
Thanks guys