There isn’t a database programme on the planet that offers anything even close to what Microsoft access can give you.
In this blog I have described use of relationships between tables in Access Database. The main objective to create relationships between tables, to remove data redundancy (duplicate data).
In this blog I have described how to remove primary key from table in Access. If you remove the primary key, from table then you not identify a record.