Data Model ~ Publications...

I originally started this as a demo to show how to handle multicolumn reports with images.  It quickly became a way to handle Newsletters, Blogs, RSS Feeds and more.  So this Data Model has the extra added bonus of having forms, reports and sample data, however, the balance is up to you!  To download the Data Model click here.
Business Rules...
Publications may have a Logo (image)
There may be Subscribers
There may be several different types of Publications
Publications will contain one or more Articles
There can be multiple Articles to one Publication
Articles may or may not have images
Rearranging of Articles because of deletion ot just because it's not wanted
Subscribers may request different delivery options (Frequency of Publication)
Articles can be printed without a Publication
Main Entities...
Articles may or may not have Authors
There may be a need to identify Publications by Tags based on Subscribers
Most of the Error Code is what I call *Lazy woMan's* code (On Error Resume Next).  So, you want to make sure you add proper Error Handling!
The difficult I do immediately, the impossible takes a little bit longer.
Data Models
Tips (Main)
Restaurant Reservations
Property Management
Jobs (or Work Orders)
Training with Attendance
Products (Shoes of Clothing)
Clubs (or Associations)
Purchase Order with Inventory
Hotel Bookings
Real Estate
Grocery List Maker
Recipes with Grocery List Maker
Parking Lot
Appointments (i.e. Salon)
Damage Investigations
Call Center
Tour Agency
Training (with Cirriculum)
Access Basics
Data Modeling 101
Utter Access - Design Strategies
Naming Conventions
Modeling Human Relationships
This site uses cookies to collect data on usage. By continuing to browse this site you consent to this policy. Find out more here.