Can anone help me with a databae for monitoring books

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am looking for a access databaes for me to input the books from my school
and i want to be able to do a seach on things such as, title, author,
subject, level, seris etc

thnks john
 
I dont know if theres any around,but its easy to make. You can make a table
called Book. You would put all of the fields that you noted in your question
in that table. You can let Access make your primary key or you can make one
of your own. If you plan to make your own primary key, remember that the
primary key is the field that makes every record unique. In your case the
ISBN number of the book may be a good choice for the primary key. As for
searching, you can make quieries. You can either use the wizard or make it
straight from the design view. If you make it straight from the design view,
choose all of the fields that you want and set the criteria for the one that
you want access to search by. For example, if you want to search by author,
select all of the fields that you want to see. At the criteria section of the
author field, type in [Enter Author:]. This will activate a prompt that will
ask you for the name of the author. You can do the same thing for any other
search. You can also make a form that operates just like the prompt. The only
difference would just be the appearance of the window asking you for the
certain field that you want to search by. I hope this helps you out.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top