Microsoft Access 97 (or higher)

I have a simple CD database that has the following fields:
CD ID (unique)
CD Title
Access Code
Owner

I would like to know how to have a report list all the items a user searched for, for example, if I enter [Type Title to Search] under the CDTitle field (in query) this will find only items trped that match in Title. How can I have the user type their request and ALL FIELD get quiried at the same time, in other words, I would type ‘TEST’, all CD ID’s, CD Titles, Access Codes and Owner would find the word TEST and report that record(s). Let me know if I need to elaborate more.

Thank you