How to search data after stored it in Access 2007

[HafizAzny]

Hello there,

My practical supervisor ask me to do customer database and Im using Access 2007 to maked the database.I must make 2 thing to my project.


1)Enter customer detail in database and I already finished it using form.
2)She want me to make find customer function in database.(For example after customer data stored.When someday my supervisor want to search a customer data,she only press customer name for example Mark and the detail of Mark appeared)

........
My problem is I dont know how to make find customer function in access 2007..anybody please help me...Some said used query but i dont know how to do it..Only 1 more task to finish my project. Search Customer Data......

p/s:sorry for my bad English because my English not very well..I hope you will understand...Thanks...

[June7]

For parameterized query approach (query would be the RecordSource of form), review tutorials at http://datapigtechnologies.com/AccessMain.htm especially 'Build a Custom Filter in Your Form' and 'Creating a Basic Search Form' in Access Forms: Tips and Techniques section.

[HafizAzny]

For parameterized query approach (query would be the RecordSource of form), review tutorials at http://datapigtechnologies.com/AccessMain.htm especially 'Build a Custom Filter in Your Form' and 'Creating a Basic Search Form' in Access Forms: Tips and Techniques section.

Ok thanks for your reply...but i still dont get it how to make search customer data after watching your video..because it not show step by step how to use query and coding..Im beginner in making database please give video tutorial step by step how to make search customer data..Thanks..

[June7]

The videos are very specific and have served to teach thousands of beginners. I am not going to try writing a book here in a forum thread on Access basic functionality. I suggest you get an introductory book on Access and go through exercises.

[HafizAzny]

The videos are very specific and have served to teach thousands of beginners. I am not going to try writing a book here in a forum thread on Access basic functionality. I suggest you get an introductory book on Access and go through exercises.

owh ok..anyways thanks for help...

[June7]

You can also do a google search on 'how to build a search form in Access'. There are many other tutorials and threads discussing the topic. Here is another http://www.everythingaccess.com/tuto...-criteria-form.

[HafizAzny]

Ok thanks for your help..I will try to finish my project..sometimes i got confused about query and the coding...but i will watch the tutorial over and over until I can get the information given in the tutorial...thanks again...

[HafizAzny]

June 7...I alraedy follow step in video..but when I click run quer button it said please insert parameter value..why??
Oswaldo:I need button function to run search data..

[June7]

The prompt is because Access can't find the control referenced, usually due to misspelling. Do you want to provide project for analysis? Follow instructions at bottom of my post.