Create search form

[LearningBee]

I have a recipe database and would like to know how to create a form to access the recipes by using keyword search such as "chicken", "beef", "dessert", "vanilla cake" and etc. I am using MS Access 2007. The database consist of four columns - ID, Title, Ingredients, Instruction.

Any help is greatly appreciated.
A beginner but eager to learn!

 

[fneily]

You will probably not like this, but here goes.
Access is a relational database with alot of non-intuitive concepts and nuances. I usually recommend taking Access courses at a local community college because you can't learn Access by yourself. You should also have lots of Access books. This will get you going with the basics of Access. This forum assumes some experience with Access. It is not a tutorial for beginners.
You state "The database consist of four columns - ID, Title, Ingredients, Instruction." No. The TABLE consists...
So you should learn the proper language.
You have a field called Ingredients. Does the plural imply more then one ingredient in the single field? If so, then your table is not normalized. Normalization is extremely important. See:
Fundamentals of Relational Database Design

http://r937.com/relational.html

You are asking how to filter a form. You'll see above your post a button with FAQ. Look through these and you'll find some good info. For your question:
faq702-4398
faq702-3702
Also use the Search button and search the Access forums (there's about 7) on Filter Form. Such as thread702-1487574

The answer to your question is also in any basic Access book.

Now if you feel I have been too harsh, then I am jealous of the easy life you lead. Life can be so more harsher.

 

[LearningBee]

I appreciate you for taking the time to answer my question that now seems to make not much sense. Thanks for pointing out the direction that I should go. You are not being harsh. You are just being honest and frank to tell me what I should do. Thanks for the links too.

 

[MajP]

I think there are a ton of Access Recipe database templates out there with plenty of Bells and Whistles. Do a little Googling and you may save a lot of time.

 

[LearningBee]

Good point and good suggestion. I will do some googling. Many thanks. Just wanting to learn!

 

[klmorgan]

Hi

If you set up a query and in the Ingredients field in the box marked Criteria Enter: Like *chicken*
This should return all records that contain chicken in the field. It seems Not to be case sensitive so would also find Chicken.

The standard wildcards appear to work in the query so the * means anything before the c or anything after the n.

Hope this helps, come back if it dosn't.

Harsh never really works for me.

Kind Regards

Keith