Hello all,
Would anyone have any advice about designing a database to track an organization's total output? I work at a research company that publishes articles and papers, holds events, contributes quotations to the media, blogs, etc. We need to have a record of basically every official contribution we make. I am new to Access and I set up a database myself, but was wondering if anyone out there has experience in this and might have some good tips. I'm particularly confused about the Primary Key and am not sure how to use this, as I am not dealing with unique numbers.
Would also appreciate any comments regarding the table relationships. I need at least 7 tables for the different categories and was wondering how to best relate them to each other. For example, if one of our employees is mentioned in different tables across the database, is there a way to automatically organize all his records?
Any advice would be most welcome!