Is Access right for what I want to do?

[Michelle]

we want to create a database of the costumes at my church. We have well over
1,000. I was wondering if the costumes could be categorized in more than one
way, by genre (Biblical), by color, or by what production it was used in.
Would this be 1 table. I was thinking we would also have a table for actors
so we could track their sizes, as well as costumes they've worn. I would
want to include pictures of the costumes. We're trying to alleviate having
to go to the church each time we wnat to select costumes for a production, as
well as track them as far as where they are located, and just generally keep
track of what we have. Is this the right program for what we want to do?

Thanks everyone!

 

[Roger Carlson]

Yeah, I think Access would be perfect for your needs.

However, I can see a need for at least 8 tables, possibly more. The most
important thing you can do is design your table structure properly. I've
got some tutorials here:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=238 that walk
you through the process. The paragraph below is an excellent start and the
first thing the tutorial asks you to do.

You should also read some of the articles on that page before you get
started (especially "What is Normalization?", "Entity-Relationship
Diagramming", and "The Hernandez Process in a Nutshell". You can probably
skip "The Normal Forms" for now.

Hope this helps.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Mr. B]

Michelle,

Just to add to Roger's posting, I can already see the need in your table
design for more than one "many-to-many" relationships. So as they say, "A
word to the wise is sufficient."

Good luck with your project.

 

[Michelle]

Thanks everyone! I appreciate the input. At least I know I'm on the right
track.

 

[Mr. B]

Michelle,

Plase keep in mind that even during the design phase of your data structure,
there are many true experts here that will be more than willing to provide
insite and even suggestions.

So, as you come across things that are not clear, do not hesitate to post
back with your specific questions.