Looking for publications submission tracker database template

[MrKen]

I'm looking for an Access template for tracking publication submissions from
authors/scholars. Types of data would be: information about the submission
(title, length, format, authorship, etc.); information about the potential
publisher (journal name, contact info, formatting preferences, etc.); dates
and response information (accept/reject/revise (what revisions). Since each
publication might have multiple submissions before an acceptance, the
database would have to associate each pub with multiple journals/publishers
until an acceptance. The interoperability of Access could also be used to
spit the contact info into form cover letters to go with submissions.

 

[Tim Ferguson]

I'm looking for an Access template for tracking publication
submissions from authors/scholars. Types of data would be:
information about the submission (title, length, format, authorship,
etc.); information about the potential publisher (journal name,
contact info, formatting preferences, etc.); dates and response
information (accept/reject/revise (what revisions). Since each
publication might have multiple submissions before an acceptance, the
database would have to associate each pub with multiple
journals/publishers until an acceptance. The interoperability of
Access could also be used to spit the contact info into form cover
letters to go with submissions.

How about this (* is a PK, + is a FK):

Instititions(*InstID, FullName, Address, etc)

People(*PersonID, FName, LName, Institution+, etc)

Papers(*PaperID, FullTitle, FinallyPublishedOn)

Journals(*JournCode, FullName, Publisher, WebPage)

Submissions(*PaperID, *DateRcvd, DateSentToReferees,
FormatType, AdviceSummaryType)

Referees(*PaperID, *DateRcvd, *SentTo, DateSent, CoveredBy)
(PaperID, DateRvcd) ref to Submissions
(SentTo) ref to People

Authors(*PaperID+, *PersonID+, RoleInPaper, IsPrimeAuthor, etc)


.... and so on.

Hope that helps


Tim F