Form to Facilitate Query/Report

[FelipeH]

Hello everyone. Second post, being the first one on the "Introduce Yourself" section.

First of all, I am a medium-leveled Excel user and started messing with Access this morning. I'm following a dummie guide (very good guide, by the way). So you can be a little more than basic, but not too much.
Well, enough for the introduction. What have I gotten with me, anyways?

I am a database developer, hence I can create a query named "Search by Client", enter a client name related filter and get what I want. Elaborate reports from that. OK.
Although, when I think of the end-user, I don't want him to create queries and stuff, this is meant for developers, not for end-users/operational staff.

So I thought that Access probably would have this feature, then I started searching on this forum. I saw a screenshot of a guy who accomplished this (at least I think he did). The screenshot is attached to this thread.

If you guys could light me out topics on how to do this.
What I need: to create an easy way for my end-user to apply filters.
Then, when he has already chosen the filters, I need to show him the results or with a report or - better - inside a form, I don't know.

Thanks in advance, people.

 

[Alansidman]

Here is a good starting point

http://www.datapigtechnologies.com/flashfiles/searchform.html

Alan

 

[FelipeH]

Here is a good starting point



Alan

Thanks. Would you mind posting the keywords linking with the video? That would help me a lot when searching more things about it. By keywords I mean, how is this called? Form querying? You know, the coined terms so I can search for it.

 

[Alansidman]

In this case, I would have used the term MS Access Search Form to search. For similar type videos, click here

http://www.datapigtechnologies.com/AccessMain.htm

Also, there are many good videos on YouTube. When searching try what you believe are good search terms. Also, if you haven't picked up a book on Access. Do it now. It will be really beneficial in getting you to understand basics and terms. I used Virginia Andersons book when I started out, but there are many more. Check out your local bookstore or try Amazon.

 

[FelipeH]

In this case, I would have used the term MS Access Search Form to search. For similar type videos, click here



Also, there are many good videos on YouTube. When searching try what you believe are good search terms. Also, if you haven't picked up a book on Access. Do it now. It will be really beneficial in getting you to understand basics and terms. I used Virginia Andersons book when I started out, but there are many more. Check out your local bookstore or try Amazon.

I see. The video you pointed out really helped me. Coincidentally, I found other similar video on youtube. I have picked up Access for Dummies, it really helped me with basics and terms understanding.

Thanks for datapig main page, tried to find it but had no success.