MS Access Media Clipping Database Template


Direct Download Link

Get it from CNET Download.com!

Visit the application page on download.com

I have developed this media clipping database template in Microsoft Access after so many experiments, and sharing it as a gift with those who are interested in databases and would like to manage their print, electronic and broadcast media clippings efficiently.

Important Features

  1. Rather than embedded attachments, the application uses paths to store clipping files in a directory, resulting a very light-size database file.
  2. Auto-generated reports and analytical graphs
  3. Web and desktop versions

MCD

System requirements

Microsoft Access 2010/2013

How to use the template

Download the zip file, extract the folder ‘Media Clipping Database’ and save it on C partition on your hard disk. Go to the folder and open the web or desktop file. The latter offers more features, like, analytical graphs, detailed reports, etc. Replace the filled in fields with your data and see the results.

You can publish your clippings or reports as pdf or export as html files.

Structure

Here is the structure of the database elements:

Tables

Media

ID: An auto number generated automatically with each record
Media: Name of media outlet
Medium: Like, newspaper, TV, radio, etc.
Language: Like, English, Urdu, Sindhi
City Head Office: City in which the head office is located
Comments: Any extra information you would like to add
Logo: Path to the image of the media logo

Contacts

First name, last name, job title, company (media), contact details, etc.

Topics

List of coverage topics

Employees

ID: An auto number generated automatically with each record
Full Name: Full name of employee updating the database

Clippings

The Clippings table stores the information about clippings; field-wise details are given below:
ID: An auto number generated automatically with each record
Date: Publication/on air date
Region: Area/country
Entity: Company entity
Department: Company department
Nature: Nature or tone of the clip, like, negative, neutral, and positive
Coverage Type: Like, brief news, features, etc.
Source: Like, arranged, not arranged or released by your company
Media: Name of media outlet
Media Contact: Like, name of the reporter
Heading/Hyperlink: Heading, hyperlinked with an online link to the coverage, if any
Summary: A brief summary of the news (maximum 255 characters)
Body Text: Contents of the news
Topic Category: Select a topic from the list if you would like to divide your coverage topic-wise, like, eHealth, AIDS, pregnancy, etc.
Current Story Topic: Main topic of a coverage, like, National Symposium, Teachers’ Day, etc. Headings could be different under that main topic.
Event Title: Like, World Diabetes Day
Release Title: Title of press release or photo caption. If the release is related to an event, keep the event and release title same.
Image Path: Browse to a directory to save the path to display a clip image in the database
Position: Like, page number
Duration: For video and audio coverage, in minutes.
Edition: Like, Karachi edition
Employee: Employee signed in
Update Date: Date on which the record updated

Tips

By clicking on a field in the table, you can change the properties as per your requirement, like:
Field size: Maximum characters allowed
Default value: Auto filled, like, current date in the date field that can be modified by the user
Required: If checked, the record could not be saved without filling in this field, etc.

In lookup fields, that display a list to select an item, you can right-click on the arrow on a form and edit the list items.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s