Is it possible to create a form that has say three fields in which you can enter either an ID, Name or something else and then use these values as the imput to a search into a particular table?

Yes this is a very useful technique to learn as it has a great deal of flexibilty.
The pricipal behind it is taht you can reference values on forms from query criteria.
Example
Form name frmMyForm1
Form contains 2 fields
txtBEGINdate
txtEndDate
the query contains 2 fields you want to select on [MyAccountStart] and [MyAccountEnd}

in the query criteria for [MyAccountStart]
use

>= [forms]![frmMyForm1]![txtBeginDate]

in the query criteria for [MyAccountEnd]
use
<= [forms]![frmMyForm1]![txtEndDate]

You can amend this example to meet your needs. the great flexibilty of this method is that you can use values from multiple forms if you want to.
Hope this helps