Microsoft Access Quick Queries #17: Avoid Beginner Mistakes, Align Forms, Chart Tips, and More

Welcome to another TechHelp Quick Queries video brought to you by Access Learning Zone. I am your instructor, Richard Rost. Quick Queries videos are for me to answer your questions that may not need a whole video themselves. In today's video...
TOPICS:
Importance of not starting a major project as a beginner in Access
Learning the basics of Access before starting an end project
Introduction to relationships and combo boxes in Access
Creating simple practice databases for learning
Aligning and drawing lines in Access forms and reports
Differences between line drawing tools in Access and other Office tools
Limitations of border control properties in Access
Using layout view to specify gridlines in Access
Custom control and design of forms in Access
Setting up and using the quick launch toolbar in Access
View code button function in Access
Discussion on offline storage needs versus online services
Billing date storage solutions in Access
Modern charts in Access and their limitations compared to classic charts
Using VBA code to control form and report appearances in Access
Understanding kernel32 and its use in Access through DLL
Discussion on the position memory of reports in Access
Customizing the appearance of forms and reports through VBA in Access
LEARN MORE:
599cd.com/QQ17
PREVIOUS QUICK QUERIES VIDEOS:
Quick Queries: 599cd.com/QuickQueries
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMember
COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
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
ADDITIONAL RESOURCES:
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database,, importing data,enhancing forms,Quick Launch Toolbar,VBA Editor,local data storage,database performance,kernel32 DLL functions,customizing reports,VBA,drawing lines on forms,vertical lines in reports,field borders,layouts,stacked layout,grid line properties,border customization,VBA code editing,quick launch toolbar customization,online data storage,performance analysis tool,using kernel32 in Access,report sizing with VBA,Access charts,modern charts in Access,Access tutorial for beginners,intermediate Access tutorial,Access database management,Access forms and reports,custom VBA functions
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@Jojosmith342]

all thumbs up to the BEST TEACHER RICHARD ROST. Thank you very much for your other valuable lessons. Already SUBSCRIBED from the very 1st lesson for his time & hard work. God bless you and yours. Live long and prosper Richard to continue to help the world 🙏

[@ryeaton]

I love the Quick Queries!

[@easyspeak101]

Yes thanks Richard, I would love to see the ongoing monthly balance table, incorporated into the other days "Account Statement 3" project posted the other day.. Thanks 👍👍

[@nickbroekhuizen8858]

Thanks for using my question...😄

[@Shadow.Dragon]

Richard, thanks for your thoughts on the performance analysis within Access. Since starting to watch your videos, I'm now exploring more of Access' capabilities. I didn't want to waste time/effort using the performance analysis tool if it was not worth it!

[@599CD]

Yeah... never had any need for it.

[@599CD]

Yeah... never had a use for it.

[@Satyasaibabu125]

Namaskar Richard, Thanks and appreciate your effort to familiarize microsoft access to all. How to concatenate 2 or 3 combo boxes and resulting values should be text in each field instead of numbers. Help please.