How do I use Access to keep record of theatre performances?

[Guest]

I want to set up an Access data base so that I can look up actors, roles,
directors, authors, composers, theatres, plays, musicals, and dates. Example:
What shows, roles, etc. have I seen with the actor Christopher Plummer?

 

[Jeff Boyce]

George

Have you checked on-line for templates that might already do this? While
Excel lets you add rows/columns and Word lets you type/correct, Access is a
relational database, and most folks don't do databases in real life (like
they do spreadsheets and documents).

Access has a bit of a steep learning curve, so if you can find some
pre-existing templates (try at Microsoft.com, enter "template" as a search
term), you can tease them apart for more ideas.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

I want to set up an Access data base so that I can look up actors, roles,
directors, authors, composers, theatres, plays, musicals, and dates. Example:
What shows, roles, etc. have I seen with the actor Christopher Plummer?

This can certainly be done, but it's a nontrivial application! You'll need
tables for (at least): Plays; Authors; Actors; Theatres; Performances; and
some "relationship" tables joining them. Laying out the entire table structure
is more than I have time for this morning. One place to look is for a template
for DVD or video collections - they share many of the same features, you'ld
just need to add a Performances table and adapt the relationships.

John W. Vinson [MVP]