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.
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
Publications
Articles may or may not have Authors
There may be a need to identify Publications by Tags based on Subscribers
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) |
| Home |
| Access Basics |
| Data Modeling 101 |
| Utter Access - Design Strategies |
| Naming Conventions |
| Modeling Human Relationships |