Access SQL Seminars
A Three-Part Series to Learn the SQL Programming Language
| |
|
|
 |
SQL Seminar Part 1
Learn how to program using the SQL language to greatly enhance your Access databases. Learn the basics of SELECT queries, WHERE conditions, and ORDER BY clauses. You will also learn how to integrate custom SQL statements into your Access forms, reports, and controls. |
 |
| |
|
|
|
SQL Seminar Part 2
Supercharge your Access databases with the full power of SQL. This seminar will focus primarily on action queries to manipulate the data in your tables, but lots of other topics are covered as well. Learn the one type of query you need to use SQL for: UNION queries. Launching SQL from your VBA code, aliases, table joins, crosstab and union queries, calculations in your queries, aggregate functions, and lots more. Tons of examples. |
 |
| |
|
|
|
SQL Seminar Part 3
This seminar is all about manipulating the structure of your Access database - building and modifying tables and queries with SQL commands. The techniques in this seminar are especially useful for the administrator or developer who has to support remote database files. You can now update them (add a table, change a field, etc.) with simple SQL commands. |
 |
| |
|
|
|
SQL Server Online
This seminar will teach you 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. |
 |
| |
|
|
|
