Sample data · this browser only

Marketing projects

Microsoft Access Marketing Projects: a campaign with deliverables. Budget sits on the project; cost is the sum of child rows.

What this demo shows · Tasks is to-dos, not this campaign register · Demos

Open projects (Split · datasheet)

Open = Active and not Completed or Cancelled.

ID ProjectName Status Pri End

Project

Combos store the ID. Deliverables are this ProjectID only.

What this demo shows

A Microsoft Access marketing campaign in the browser: a project, a budget, and deliverable costs that sum against it.

  • Not Tasks — Tasks is a to-do list. This piece is tblMarketingProject plus tblDeliverable.
  • Combo stores the ID — status and priority save IDs and show names.
  • Open filter — hides Completed and Cancelled, like qselProjectsOpen.
  • Three tabs — Project (who/what/when), Details (budget, cost sum, notes), Deliverables (this ProjectID).
  • Balance — Budget minus the sum of active deliverable Cost (Access DSum).
  • Unsaved changes — leave a dirty project and you get Yes / No / Cancel (Access Me.Dirty).

Will this work when the data is in a database?

Yes. The project holds the campaign; the deliverable table holds the work and cost. On-hand style: do not store the total twice — sum the children.

Sample data only. Source: Microsoft Access Marketing Projects template. Vendors and Employees are omitted this pass.