Microsoft Access Table Relationships

Microsoft Access Table Relationships

An ideal database is free of redundant or duplicate data. To achieve that, you must split your data into many subject-based tables so each subject is presented only once. To do that in Microsoft Access, you place common fields in tables that are related. But before you do that, you must need to understand the relationships between your tables, then you can specify these relationships in your Access 2013 database.

microsoft access table relationships

In this article, I will elaborate to you the ten things you need to know about table relationships in Microsoft Access.

1. A one-to-many relationship is when one record in the parent table connects to many records in the child table.

To exemplify this, let’s take for example two tables: one for doctors and the other is for patients. A doctor can have several patients. In this case, you will Continue reading “Microsoft Access Table Relationships”

Microsoft Access Database: Pass Through Queries

Microsoft Access Database:  Pass Through Queries

There are many Microsoft Access queries to choose from that will manage your database reporting requirements but there are a handful of lesser known types of queries that you may not be aware of.

One in particular is a query called ‘Pass Through Query‘ as the following short video tutorial quickly explains…

https://youtu.be/DBchzNZXru4

Putting aside for the heavy American accent, it clearly explains the use for this type of query and the power behind how Continue reading “Microsoft Access Database: Pass Through Queries”