Uploaded July 2026 | Updated September 2026, 2 weeks ago
In this lesson, we discuss the many meanings of "pull data" in Microsoft Access, including displaying related records with queries, intentionally copying historical or default values, importing or linking external data, retrieving single values with DLookup, exporting data, and synchronizing sources. We also cover foreign keys, table relationships, placeholder dates, SQL Server views, and using a Windows machine or SQL Server when Access data must be accessed from a web application.
Jerome from Philadelphia, Pennsylvania (a Gold Member) asks I'm working on a Microsoft Access database, and I need to pull data from somewhere else into the part of the database I'm working on. I've searched online, but I keep finding completely different answers. Some people say to use a query, some say to copy the data, and others say I need code. What is the best way to pull data in Access?
CHAPTERS:
00:00 Introduction
01:31 What "Pull Data" Can Mean
02:20 Displaying Related Data With Queries
03:21 Copying Historical Snapshot Values
04:24 Importing Or Linking External Data
05:22 Pulling Data From Websites And APIs
06:28 Retrieving A Single Value
07:46 Retrieving Sets Of Records With Queries
08:31 Exporting Data From Access
11:07 Synchronizing Data Sources
12:05 Pulling Default Values Into Transactions
13:13 Defining Your Data Pull Requirements
13:58 The Answer: Join Related Tables
15:54 Using Access Databases With Macs And Websites
17:09 Designing Table Relationships And Foreign Keys
20:44 Using Placeholder Dates Instead Of Nulls
23:13 Using SQL Server Views In Access
24:41 Why Video Quizzes Are Teaching Tools
26:37 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Quick Queries #101: 599cd.com/QQ101
PREREQUISITES:
Quick Queries Listing: 599cd.com/QuickQueries
Quick Queries #100: 599cd.com/QQ100
LINKS:
Relationships: 599cd.com/Relationships
Outer Joins: 599cd.com/OuterJoin
Normalizing Data: 599cd.com/Normalizing
Storing Duplicate Data: 599cd.com/StoringDuplicateData
Import Access: 599cd.com/Import
Import Excel: 599cd.com/ImportExcel
Web API: 599cd.com/WebAPI
Edge Browser: 599cd.com/EdgeBrowser
DLookup: 599cd.com/DLookup
Value From a Form: 599cd.com/FormName
What is a Query?: 599cd.com/Query
Query Criteria: 599cd.com/Criteria
Recordsets: 599cd.com/Recordset
Export to Excel: 599cd.com/ExportToExcel
Export Reports to PDF: 599cd.com/ExportPDF
Export to Word: 599cd.com/ExportToWord
Export Text: 599cd.com/ExportText
Sync Remote Database: 599cd.com/SyncRemoteDB
Default Value: 599cd.com/Default
Paul Jack's Question: 599cd.com/a?125627
NZ Function: 599cd.com/NZ
About the Video Quizzes: 599cd.com/a?126003
UP NEXT:
Quick Queries #102: 599cd.com/QQ102
Captain's Log: 599cd.com/Log
Merch Store: 599cd.com/Merch
RECOMMENDED COURSES:
Access Beginner 1: 599cd.com/ACB1
Access Developer Courses: 599cd.com/Developer
SQL Server for Access Users: 599cd.com/SQLSA
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/DiamondSponsors
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
TechHelp, QQ, Quick Queries, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, pull data from another table, display related table data, join tables in query, Access relational query, copy values between tables, historical snapshot data, import Excel to Access, linked tables, staging table, DLookup, select query criteria, export Access data to Excel
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
In this lesson, we discuss the many meanings of "pull data" in Microsoft Access, including displaying related records with queries, intentionally copying historical or default values, importing or linking external data, retrieving single values with DLookup, exporting data, and synchronizing sources. We also cover foreign keys, table relationships, placeholder dates, SQL Server views, and using a Windows machine or SQL Server when Access data must be accessed from a web application.
Jerome from Philadelphia, Pennsylvania (a Gold Member) asks I'm working on a Microsoft Access database, and I need to pull data from somewhere else into the part of the database I'm working on. I've searched online, but I keep finding completely different answers. Some people say to use a query, some say to copy the data, and others say I need code. What is the best way to pull data in Access?
CHAPTERS:
00:00 Introduction
01:31 What "Pull Data" Can Mean
02:20 Displaying Related Data With Queries
03:21 Copying Historical Snapshot Values
04:24 Importing Or Linking External Data
05:22 Pulling Data From Websites And APIs
06:28 Retrieving A Single Value
07:46 Retrieving Sets Of Records With Queries
08:31 Exporting Data From Access
11:07 Synchronizing Data Sources
12:05 Pulling Default Values Into Transactions
13:13 Defining Your Data Pull Requirements
13:58 The Answer: Join Related Tables
15:54 Using Access Databases With Macs And Websites
17:09 Designing Table Relationships And Foreign Keys
20:44 Using Placeholder Dates Instead Of Nulls
23:13 Using SQL Server Views In Access
24:41 Why Video Quizzes Are Teaching Tools
26:37 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Quick Queries #101: 599cd.com/QQ101
PREREQUISITES:
Quick Queries Listing: 599cd.com/QuickQueries
Quick Queries #100: 599cd.com/QQ100
LINKS:
Relationships: 599cd.com/Relationships
Outer Joins: 599cd.com/OuterJoin
Normalizing Data: 599cd.com/Normalizing
Storing Duplicate Data: 599cd.com/StoringDuplicateData
Import Access: 599cd.com/Import
Import Excel: 599cd.com/ImportExcel
Web API: 599cd.com/WebAPI
Edge Browser: 599cd.com/EdgeBrowser
DLookup: 599cd.com/DLookup
Value From a Form: 599cd.com/FormName
What is a Query?: 599cd.com/Query
Query Criteria: 599cd.com/Criteria
Recordsets: 599cd.com/Recordset
Export to Excel: 599cd.com/ExportToExcel
Export Reports to PDF: 599cd.com/ExportPDF
Export to Word: 599cd.com/ExportToWord
Export Text: 599cd.com/ExportText
Sync Remote Database: 599cd.com/SyncRemoteDB
Default Value: 599cd.com/Default
Paul Jack's Question: 599cd.com/a?125627
NZ Function: 599cd.com/NZ
About the Video Quizzes: 599cd.com/a?126003
UP NEXT:
Quick Queries #102: 599cd.com/QQ102
Captain's Log: 599cd.com/Log
Merch Store: 599cd.com/Merch
RECOMMENDED COURSES:
Access Beginner 1: 599cd.com/ACB1
Access Developer Courses: 599cd.com/Developer
SQL Server for Access Users: 599cd.com/SQLSA
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/DiamondSponsors
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access
KEYWORDS:
TechHelp, QQ, Quick Queries, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, pull data from another table, display related table data, join tables in query, Access relational query, copy values between tables, historical snapshot data, import Excel to Access, linked tables, staging table, DLookup, select query criteria, export Access data to Excel
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
