What are One-To-One Relationships in Access 2007? A One-To-One Relationship is a relation or connection of a Primary Key in one Table to a Primary Key in another. It's extremley important to note that when you create a One-To-One Relationship that you remember the first table you dragged the initiator of the relationship from? Why? Because in our Access 2007 training video we'll show you how that knowledge affects how you will structure your database for the front end user. If done incorrectly, then the will be data editing issues when it comes to removing and updating your data. See this for yourself in our Access 2007 training videos by our certified trainer!

Purchase the training video and you can see this in action for yourself!