When relationships are defined between the multiple tables in your database, you’ll create a more flexible system that can sort, filter, and retrieve records based on a variety of criteria. Related tables can help to minimize the storage of redundant data and prevent data discrepancies from emerging.
- [Voiceover] Having data stored in your table…is a good first step, but the real power of the database…is revealed when you start relating tables to one another.…By making the connection between…how a record in one table relates to records…in another table, you can start to understand…the bigger picture of your organization or business.…In the case of the Landon Hotel,…we have rooms in one table and we have guests in another.…It would certainly make sense to see…where those two intersect, and find out…which guests checked into which rooms and when.…I've added another table to our database,…it's over here in the navigation pane…called Room Assignments.…
Lets go ahead and double click on it…to see the details that are inside.…First, we have the ID column,…which is the primary key for this table.…Its only purpose is to make sure…that Access can keep the individual records…separate from one another.…Next, we have the room number column,…and I'm just going to click here…and drag it open a little bit so we can see the full name.…
If you need a deeper dive into the topics discussed, check out Adam's Access 2016 Essential Training course.
- Loading a premade template database
- Exploring the interface
- Defining data types
- Creating tables
- Defining table relationships
- Editing forms
- Creating queries and reports
- Editing reports in Layout view