SubTracker Database

Tags: Base Database Templates

This is a database template for tracking submissions. It is designed for writers who submit to magazines or book publishers, though it could be adapted for other types of submissions.

Screen Shot 2021 04 05 at 3.42.15 PM
Screen Shot 2021 04 10 at 10.42.17 AM
Screen Shot 2021 04 10 at 10.42.54 AM
Screen Shot 2021 04 10 at 10.43.15 AM

Description

This database template is designed for writers who submit to magazines or book publishers, though it could be adapted for other types of submissions. It is free to use, modify, and distribute.

The database contains three main tables:

  • Places: for listing magazines, book publishers, contests, etc.
  • Submissions: for cross-referencing Places & Titles submitted by date, with response, date and comment
  • Titles: for listing information about each title Each Place and Title record has a unique ID that is cross-referenced with each Submission.

Available Forms:

  • FindSubmission: allows editing of submissions and searching by title, place, and dates
  • NewSubmission: allows entry of new submissions only
  • Places: allows entry of Place information and displays submissions by each place
  • Titles: allows entry of Title information and displays submissions by each title

Available Queries:

  • Submissions_Accepted – lists all submissions “Accepted”
  • Submissions_In – lists “Available” titles not currently “Out” in any submission
  • Submissions_Out – lists all submissions that are “Out”
  • viewPlaces_by_Type-SubMethod – lists places sorted by type and submission method, omitting inactive places
  • viewTitles_by_Collection – lists titles sorted by Collection, omitting titles not in a collection
  • viewTitles_by_Mode-Kind-Genre – lists titles sorted by Mode, Kind, and then Genre

Homepage: https://kendalldunkelberg.com/subtracker-2/

Repository: https://kendalldunkelberg.files.wordpress.com/2021/02/subtrackerarchive-2.zip

Release List

Release: 1.0 – First working release of SubTracker database

Compatibility: 6.3
Operating Systems: Linux, Windows, macOS
License: GPL
ReleaseNotes:

First full working release with readme file.

The Zip archive contains SubTracker.odb and Readme.txt files.

It has been tested for LIbreOffice and OpenOffice on Mac, and should also work on Windows and Linux in OpenOffice or LibreOffice.

Other Extensions

SubTracker Database

This is a database template for tracking submissions. It is designed for writers who submit to magazines or book publishers, though it could be adapted for other types of submissions.

04-2021

Feedback

Post your review

You cannot post reviews until you have logged in. Login Here.

Reviews

No one has commented on this page yet.

RSS feed for reviews on this page | RSS feed for all reviews