fbpx
Logo
Mail us
ben@accessdatabasetutorial.com
Home » Posts tagged "ms access primary keys"

Tag Archives: ms access primary keys

Microsoft Access Tutorial: Creating A Many-To-Many Relationship


Microsoft Access Tutorial

Let’s revisit a popular aspect to your Microsoft Access Tutorial database design; Creating a many-to-many relationship. Firstly, watch this quick video which explain the key components and the starting steps to getting to the many-to-many state for your Access database. In order to create this type of relationship, it’s now clear we need an interceding or junction table to handle the two-way joins of the outer tables with the option of setting referential integrity option which tightens the operational side […]

Tags: , , , ,

Access Database 2007: Assigning a Primary Key to a Table Microsoft Lesson 2.7


Access Database 2007

Microsoft Access Databases must really have primary keys applied to each core table to help manage relationships and keep data integrity 100% enforced to avoid those unexpected errors. Take a look at this quick tutorial on How To Set the Primary in Microsoft Access My Comments on Microsoft Access Database Primary Keys I’m not a fan of mutiple fields to act as a group for the primary key as discussed in this video tutorial. I believe there should only be […]

Tags: , , , ,