This series of seminars will teach you how
to use the SQL programming language to enhance your Access databases.
Part 1 covers the basics of SQL, and how to use SELECT queries to get
the data you want. You will also learn how to integrate custom SQL
statements into your Access forms, reports, and controls.
focuses on ACTION queries to manipulate data in your tables,
launching SQL from your VBA code, aliases, table joins, crosstab and
union queries, calculations in your queries, aggregate functions, and
teaches you how to manipulate the STRUCTURE of your database
using nothing more than SQL commands. You will learn how to build and
modify tables, queries, relationships, and lots more. This is perfect
for administrators who often have to support multiple remote database