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 tables…is a good first step, but the real power of the database…is reviled 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.…
Let's 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 gonna 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 Office 365: 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