Channel: Computer Learning Zone
Category: Education
Tags: is sql same as microsoft accesswhy you should learn sqlcan you use sql in microsoft access#lessonvocabulary#trainingmicrosoft accessselect statement#database#learnsql language vs. server#tutorialmicrosoft access sql reference#msaccessms accesshow to use sql with microsoft access#microsoftaccess#howtoaccess sql basic conceptsmicrosoft access sqlis access good for sqlsyntaxstructured query language#helpsql viewms access tutorial
Description: In this video, I'll teach you about the basics of SQL and how to use it in Microsoft Access. We'll see how to edit the SQL of an Access Query, how to modify the Record Source of a form, and the Row Source of a combo box. Ari from Hollywood, Florida (a Platinum Member) asks: I have a billion queries in my Access database. Is there any way to consolodate those so the list is a little more manageable? Most of them are just variations on the same theme, like different ways to sort customer lists. Silver Members and up get access to an Extended Cut of this video. Members will learn how to manipulate SQL using VBA code. We will change a form's RecordSource property and a combo box's RowSource property directly using VBA. This will allow us to make dynamic events by using click events in our forms. MEMBERS VIDEO: youtu.be/OYXzj2Hp3y0 BECOME A MEMBER: YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join or My Site: 599cd.com/THMember LEARN MORE: 599cd.com/SQLwithAccess LINKS: Access Beginner Level 1: 599cd.com/ACB1 Invoicing: 599cd.com/Invoicing Double-Double Quotes: 599cd.com/Double SUGGESTED COURSE: SQL Seminars: 599cd.com/SQL OTHER 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: twitter.com/LearningAccess en.wikipedia.org/wiki/Microsoft_Access products.office.com/en-us/access microsoft.com/en-us/microsoft-365/blog/access KEYWORDS: microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Access SQL basic concepts, vocabulary, syntax, SELECT statement, Microsoft Access SQL, Microsoft Access SQL reference, Can you use SQL in Microsoft Access, Is SQL same as Microsoft Access, Is Access good for SQL, How to Use SQL with Microsoft Access, SQL View, structured query language, why you should learn SQL, sql language vs. server QUESTIONS: Please feel free to post your questions or comments below. Thanks.