Uploaded August 2026 | Updated September 2026, 2 weeks ago
In today's Quick Queries we will explain the different views in Microsoft Access, including Design View, Datasheet View, Form View, Layout View, SQL View, and Print Preview. We will also discuss a VBA Exit Sub versus Exit Function error, preventing Excel imports from truncating long text, manually splitting and linking a database, organizing the Navigation Pane, setting expectations for larger database projects, and the difference between SQL written in a query and dynamic SQL built in VBA.
Peter from Denver, Colorado (a Platinum Member) asks I just started working with Microsoft Access, and I get confused when the screen changes. Sometimes I'm typing customer information into rows, then I accidentally end up moving boxes and seeing all kinds of settings. People mention Design View, Form View, and other views. What are they all for, and how do I know which one I should be using?
CHAPTERS:
00:00 Introduction
01:03 Understanding Microsoft Access Views
12:03 Recommended Access Beginner Course
12:43 Fixing Exit Sub In A Function Errors
15:30 Preventing Excel Import Text Truncation
17:53 Splitting A Database And Linked Tables
19:35 Building A Sales And Inventory Database
23:03 Writing SQL Directly Vs Building SQL In VBA
26:17 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Quick Queries #103: 599cd.com/QQ103
PREREQUISITES:
Quick Queries Listing: 599cd.com/QuickQueries
Quick Queries #102: 599cd.com/QQ102
LINKS:
Split Your Database: 599cd.com/Split
Concatenation: 599cd.com/Concat
UP NEXT:
Quick Queries #104: 599cd.com/QQ104
Captain's Log: 599cd.com/Log
Merch Store: 599cd.com/Merch
RECOMMENDED COURSES:
Barcode Seminar: 599cd.com/BarcodeSeminar
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, Access Design View, Form View, Datasheet View, Query Design View, SQL View, Table Design View, Report Design View, Layout View, Print Preview, QBE grid, Exit Sub not allowed in Function, Excel import Long Text, split database linked tables
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
In today's Quick Queries we will explain the different views in Microsoft Access, including Design View, Datasheet View, Form View, Layout View, SQL View, and Print Preview. We will also discuss a VBA Exit Sub versus Exit Function error, preventing Excel imports from truncating long text, manually splitting and linking a database, organizing the Navigation Pane, setting expectations for larger database projects, and the difference between SQL written in a query and dynamic SQL built in VBA.
Peter from Denver, Colorado (a Platinum Member) asks I just started working with Microsoft Access, and I get confused when the screen changes. Sometimes I'm typing customer information into rows, then I accidentally end up moving boxes and seeing all kinds of settings. People mention Design View, Form View, and other views. What are they all for, and how do I know which one I should be using?
CHAPTERS:
00:00 Introduction
01:03 Understanding Microsoft Access Views
12:03 Recommended Access Beginner Course
12:43 Fixing Exit Sub In A Function Errors
15:30 Preventing Excel Import Text Truncation
17:53 Splitting A Database And Linked Tables
19:35 Building A Sales And Inventory Database
23:03 Writing SQL Directly Vs Building SQL In VBA
26:17 Conclusion
BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember
LEARN MORE:
Quick Queries #103: 599cd.com/QQ103
PREREQUISITES:
Quick Queries Listing: 599cd.com/QuickQueries
Quick Queries #102: 599cd.com/QQ102
LINKS:
Split Your Database: 599cd.com/Split
Concatenation: 599cd.com/Concat
UP NEXT:
Quick Queries #104: 599cd.com/QQ104
Captain's Log: 599cd.com/Log
Merch Store: 599cd.com/Merch
RECOMMENDED COURSES:
Barcode Seminar: 599cd.com/BarcodeSeminar
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, Access Design View, Form View, Datasheet View, Query Design View, SQL View, Table Design View, Report Design View, Layout View, Print Preview, QBE grid, Exit Sub not allowed in Function, Excel import Long Text, split database linked tables
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
