Tweet
Relationships link data from individual tables to increase its usefulness.
Access creates relational databases, which means that data is stored in various separate tables by subject or task, but the data is related and can be brought together in ways that you specify.
Even though a club's database might store member contact information separately from its lists of recycling volunteers or holiday planning data, the database can pull all this information together whenever you want.
So, you could quickly print a list of who's volunteered to recycle newspapers this Saturday, along with their up-to-date addresses and phone numbers.
The two sets of data are relational, so that information in one set of data (such as Nancy Davolio's name on the recycling list) is associated with, or "knows about," the applicable information in the other set of data (Nancy Davolio's contact information).
To make the most of your database, you'll want to set up the tables of data to reflect the subjects and tasks associated with your data.
While planning your database, consider the scenarios in which people will be entering data, looking up data, or reporting data. A little forethought can go a long way.
Access creates relational databases, which means that data is stored in various separate tables by subject or task, but the data is related and can be brought together in ways that you specify.
Even though a club's database might store member contact information separately from its lists of recycling volunteers or holiday planning data, the database can pull all this information together whenever you want.
So, you could quickly print a list of who's volunteered to recycle newspapers this Saturday, along with their up-to-date addresses and phone numbers.
The two sets of data are relational, so that information in one set of data (such as Nancy Davolio's name on the recycling list) is associated with, or "knows about," the applicable information in the other set of data (Nancy Davolio's contact information).
To make the most of your database, you'll want to set up the tables of data to reflect the subjects and tasks associated with your data.
While planning your database, consider the scenarios in which people will be entering data, looking up data, or reporting data. A little forethought can go a long way.