Learn SQL
Interested in learning SQL? Here at Computer Learning Zone, I've got something for everybody, whether you want to learn Microsoft Access SQL, the SQL language itself, or how to use SQL Server.
My SQL Server for Access Users course shows you how to connect Microsoft Access to SQL Server so you can keep your Access forms and reports while gaining the reliability, security, and performance of a professional database engine.
SQL with Access is perfect for beginners and introduces the SQL language inside Microsoft Access, teaching you how queries work and how to use SQL in forms, combo boxes, and other objects.
In the Access SQL Server Online Seminar, you'll learn how to connect your Access database to an online SQL Server so multiple users can access your data from anywhere using Access or even a web browser.
Finally, my Access SQL Seminars are a three-part series that teach the core SQL language in depth, including SELECT statements, filtering with WHERE, sorting with ORDER BY, UNION queries, action queries, and even running SQL directly from VBA code.
| Learn SQL Server & Language | Options Sort: Date Title | Display: Full Compact | | | | | SQL Server for Access Users Ready to take your Microsoft Access database to the next level? In this course, you'll learn how to use SQL Server as a powerful back end for your Access applications, giving you improved reliability, security, and performance as your data grows. I'll guide you step by step through installing SQL Server, connecting it to Access, and moving your data the right way. You'll keep building your forms and reports in Access while SQL Server handles the data behind the scenes. If you're ready to scale your Access databases for larger datasets and more users, this course will show you how. | |  |
| | | | SQL with Access New to SQL? Start here. This is the SQL language in Microsoft Access for the absolute beginner. 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. | |  |
| | | | Access SQL Server Online In the Microsoft Access SQL Server Online Seminar, you will learn how to connect multiple users to an online SQL Server database using either Microsoft Access or a simple Web browser as a front-end. This will allow anyone, anywhere in the world with an Internet connection, to use your Microsoft Access database, or view your data in their browser. | |  |
| | | | Access SQL Seminars A three-part series to learn the basics of the SQL language and greatly enhance your Access databases. Learn all about SELECT statements, WHERE conditions, ORDER BY clauses, UNION queries, ACTION queries, launching SQL from VBA code, replacing saved queries in your database with code, modifying table structure from SQL, and lots more! | |  |
Subscribe to Learn SQL
Get notifications when this page is updated
|