Looking for publications submission tracker database template

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

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
 
Back
Top