Looking for Writer Assignment Application

[Alan Bell]

I want to keep track of writers and photographers and
their assignments for a newsletter. I envision a contact
screen and an assignment screen. Then I want to be able to
display the info in a variety of ways: by writer, by issue
number, by deadline date, finished assignments, unfinished
assignments, unassigned stories, etc. It be nice to be
able to create an assignment in the application and email
it to the writer but this isn't necessary. I have Access
2000 and know the principles in a general way, but never
seriously used it. I know it's supposed to be easy, but
why re-invent the wheel unnecessarily? It would seem that
this (or something similar) has been written hundreds of
times before. I've searched but can't find it. I'm not
looking for a freebie. Before I break out the manual and
try to do this myself -- which I really really don't want
to do -- can someone refer me to a ready-made source? I'm
on a PC running Win 2000, single user. There would be
maybe 100 writers and photogs and maybe 200 assignments.
(By the way, I'm here because I have Office 2000, but if
this application is ready-made as an Excel plug-in or on
another platform, that's okay with me. Can I say Filemaker
Pro 6 here without rotten tomatoes coming my way?)

 

[GVaught]

I don't know of any pre-written for writers and photographs, but Access has
some prebuilt databases that might serve your purpose with some minor
modification. Take a look at the templates that come with Access 2000. Also,
word of caution. Never store photo's within Access this will grow your
database exponentially. Generally, store hyperlinks to those photos.