Microsoft Access 2002: How can I search for records? Please Help!?

I work in a book store. I created a table using Access 2002 that lists all the books in overstock by ISBN#, Title, Author, Units in Stock, and Shelf#. Is there any way that I can create a dialogue box, or something similar, that will allow some one to type in the criteria of a certain book, i.e. the ISBN# or part of the title, that will allow them to gain access to rest of the record without having to scroll through the entire list or create a filter? This is a possibility according to the help menu but I am not very familiar with Access so it is all too confusing for me. Please help.|||Pretty hard to give you a step by step here. But, basicallly, what you need to do is to create a form based on your table.





You can create a form using the Form wizard and it is fairly straight forward. Add all the fields in your table to your form when creating it.





Then add a command button from the Access toolbox.


Next create a macro to open the Find function when the button is clicked.





You would want to set Access to open your database and automatically display the form you have constructed. Then you could click the button and enter the ISBN# to pull up the rest of the record.