Join Adam Wilbert for an in-depth discussion in this video Working with joins, part of Access 2013: Queries.
…When creating queries that include…multiple tables, it's important to understand…how those tables are related in order to get meaningful results.…Typically, Access will be able to assist you in…building these relationships if they've not been previously defined.…But there are occasions when you'll need to…create or modify how your tables are joined together.…Let's take a look at a couple of examples.…First, I'm going to go to DATABASE TOOLS and take a…look at the Relationships that we have in this database.…We can see that we have relationships between…products, orders, customers, states and our employees here.…
These are indicated by the black lines between each of these tables.…Let's go ahead and delete some of…these joins between customers, states and orders.…I'll click here, and then I'll right click and say delete.…It's going to warn me about my relationships, and I'll just say yes.…Next, I'm going to delete the one between customers and states.…Again, I'll just right click on it and say delete.…Once again, I'll say yes to permanently delete the selected relationship.…
Author
Released
7/24/2014- Defining criteria
- Understanding comparison operators
- Using joins
- Creating parameter queries
- Using Expression Builder to work with functions
- Working with dates and times
- Creating conditional statements
- Finding duplicate records
- Creating backups
- Making, deleting, and appending records
- Understanding SQL basics and writing SQL queries
- Useful query tricks
Skill Level Intermediate
Duration
Views
Related Courses
-
Access 2013 Essential Training
with Adam Wilbert5h 4m Beginner -
Access 2010: Shortcuts
with Alicia Katz Pollock3h 43m Intermediate -
Wayne Winston on Analytics
with Wayne Winston50m 38s Appropriate for all -
Learning Relational Databases (2014)
with Adam Wilbert2h 39m Beginner
-
Introduction
-
Welcome1m 2s
-
Introducing the database5m 17s
-
-
1. Creating Queries in Access
-
Understanding queries4m 36s
-
Using the Query Wizard6m 22s
-
-
2. Creating Simple Select Queries
-
Defining criteria10m 14s
-
Renaming the column headers3m 22s
-
Exploring the property sheet7m 14s
-
Working with joins8m 26s
-
-
3. Creating Parameter Queries
-
Creating a combo box7m 3s
-
4. Getting Started with Functions
-
Using mathematical operators8m 25s
-
Applying functions to text7m 46s
-
5. Applying Aggregate Calculations
-
6. Working with Dates in Queries
-
Formatting dates6m 12s
-
Sorting formatted dates6m 40s
-
Defining today's date3m 45s
-
Calculating time intervals7m 54s
-
7. Understanding Program Flow Functions
-
Introducing IIf2m 32s
-
Creating an IIf function6m 16s
-
Using the Switch function6m 41s
-
-
8. Alternative Query Types
-
Finding duplicate records4m 12s
-
Creating crosstab results6m 31s
-
Creating backups1m 45s
-
Creating update queries6m 20s
-
-
9. Exploring SQL Syntax
-
Understanding SQL basics7m 23s
-
Writing SQL queries4m 51s
-
Writing a union query4m 55s
-
-
10. Useful Query Tricks
-
Using domain functions7m 12s
-
-
Conclusion
-
Next steps49s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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: Working with joins