Based on the storyboarding experience, this step in the process of building a database establishes the literal connections between tables. Discover how relationships make an Access database more powerful and useful than a series of unrelated worksheets in an Excel workbook that contains the same data—this is because the relationships allow all the data to work together.
- [Instructor] Relating the tables…in your database is pretty serious business.…Relationships are the cornerstone of a relational database…but it's incredibly easy to create the relationships.…Now, I'm going to do that by hopping over…to the database tools tab, I'm gonna click on relationships,…and then, if it doesn't appear on its own,…the show table dialogue box, I click the show table button.…Now, the show table dialogue box lists all my tables.…I could have tables that aren't going to be involved…in any relationships but all five of mine will be…and I'll give two ways to add them to this workspace.…
You can double click on them.…Or you can click on them and hit the add button.…I find double clicking easier.…Let me just move these out of the way…so that you can see them up here.…I'm gonna double click on orders,…then products, and then vendors.…And then I close the dialogue box.…Now, I'm gonna spread them out…because, believe it or not, the method…by which you relate them is to drag from box to box,…and the more room you have in…
Author
Laurie Ann Ulrich
Released
8/14/2018- Planning your sales database
- Building tables
- Choosing data types
- Setting up field validations
- Creating lookup tables
- Building and editing relationships
- Creating forms
- Designing queries
- Creating sales reports
- Generating useful macros
- Designing a convenient navigation form
Skill Level Advanced
Duration
Views
-
Introduction
-
1. Planning Your Sales Solution Database
-
Storyboarding3m 21s
-
Brainstorming1m 47s
-
-
2. Creating Your Sales Solution Tables
-
Table-building tips3m 45s
-
Choosing the right data type2m 23s
-
-
3. Field Customization
-
Input masks4m 53s
-
Lookup tables4m 25s
-
4. Relationships
-
Editing relationships4m 15s
-
5. Forms
-
Create a form for each table2m 36s
-
Creating lookup controls4m 5s
-
Create a read-only form2m 11s
-
Adding a field to a form2m 45s
-
-
6. Queries
-
Customer status3m 26s
-
Customers last order date2m 46s
-
Products by vendor4m 25s
-
-
7. Reports
-
Customer directory10m 11s
-
Product price list5m 24s
-
Order report5m 47s
-
-
8. Macros
-
9. Sales Solution Interface
-
Edit the navigation form2m 42s
-
Conclusion
-
Next steps1m 18s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Creating basic relationships between tables