Sample data · this browser only
Publications
A small article book: publications, articles, and subscribers.
Combos store IDs. Startup is fmnuMain.
Open hides inactive, like qselPublicationsOpen.
| ID | Title | Issue | Type |
|---|
Publication
Save or select a publication first, then add an article.
| Title | Author | Date | Published |
|---|
Save or select a publication first, then add a tag.
| Tag |
|---|
| ID | Title | Publication | Author |
|---|
Article
| ID | Name | Phone |
|---|
Subscriber
Save or select a subscriber first, then add a subscription.
| Publication | Start | Frequency |
|---|
What this demo shows
A Microsoft Access publications book in the browser: an issue, the articles on it, and the people who subscribe.
- tblAuthor is not tblEmployees — writers are a thin people table, not Time Card staff.
- tblSubscriber is not tblCustomers — subscribers are people (FirstName / LastName), not companies.
- tblDeliveryFrequency is not tblFrequency — calibration already froze IntervalDays on that name.
- Articles child tab — idle until the publication is saved. An article can also sit unassigned.
- Table of contents — this publication's articles in
SortOrder. Move up / Move down / Renumber. Unassigned drafts stay on the Articles list. - Tags child tab — junction
trelPublicationTag. Combos store IDs. - Subscriptions child tab — idle until the subscriber is saved.
- Unsaved changes — Yes / No / Cancel before leaving a dirty record.
Will this work when the data is in a database?
Yes. Publication, article, subscriber, and subscription are separate tables with FKs. Multi-column reports, logos, and article image paths from the source sample are omitted this pass.
Sample data only. Source: Publications on access-diva.com.