How do I set up a database for a book review/journal in Access?

[Guest]

I have never used Access 2003 before, and am currently taking a class on
Microsoft Office applications. I reviewed the templates that were available,
but none of them fit my needs. I was wondering if anyone had any ideas, in
the mean time I will try to wing it. I want to include the title, author,
personal review, rating, genre, fiction or nonfiction, and recommendation.

 

[Jeff Boyce]

These newsgroups work great for getting help on specific questions. If
you'll describe what you've tried, and what happened (or didn't), the
volunteers here will likely offer their thoughts.

You might get fewer offers of help if, as your description could be
interpreted, you want someone to do your homework <g>!

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Well for a quick basic, you'd create a table with those fields you have
below. I take it that is the only thing you need to track. All the fields
could be text although you may want recommendation to be memo if it's going
to be long. I would think you'd make the primary key be the Title and Author
since there is a possibility that you may have a book with the same title and
you'd surely have some with the same author. You can set in the field
restrictions for each field in the table if you want..so for rating you can
make it be a 1-5 system, etc. You would then create a form based off that
table to make your entries. If you ahve never used it before the best bet
would be to use the wizards to help guide you through. As you can imagine
you can get into quite a bit of detail on how to set something up. I would
suggest though list tables, or basically making another table with a list of
book genres so that you avoid typos and can limit to what is put in that
field when you're entering a review onto your form, you'd just use a combo
box to select the genre. hope that helps some