Access SQL Seminar Part 2 - Computer Learning Zone

Access SQL Seminar Part 2
By Richard Rost

15 years ago

This nearly five (5) hour long video seminar will pick up where Part 1 left off. You will learn more about the SQL programming language. We will focus on action queries, aliases, joins, crosstabs, union queries, aggregate functions, and more.

This seminar has several goals. You will:

1. Learn about Action queries and when to use them
2. Discover how to launch queries from VBA code
3. Create Aliases for your field and table names
4. Learn the different types of Table Joins
5. Construct a Union query
6. Work with a Crosstab query
7. Perform calculations in your SQL statements
8. Explore the different Aggregate query functions
9. Utilize string, math, time/date, and other query functions

Click here for more information on the SQL SEMINAR PART 2.

Comments for Access SQL Seminar Part 2

Age	Subject	From
5 years	SQL2 Lesson 3	Ina van Rooyen
5 years	Format Percent	Joe Hood
6 years	Product List Blank	John McFarlane
8 years	Remote copy for data entry	Adonis Briceno
8 years	RowSource	Nick Cerri
10 years	SQL Seminar	James G
10 years	SQL Seminar	James Gray
10 years	Sample db	Errol Babel
10 years	Table SQL	Richard L
10 years	Table SQL	Richard Lanoue
10 years	I m having a problem with criteria on my report	Richard Lanoue
11 years	Update Error	Richard Lanoue
11 years	Format Number	Ferida Oe
11 years	Insert into another db	Robert Jacoby
11 years	Syntax	Marc S
12 years	Subforms	Patrick Trekels
12 years	Make table query into another data base file	Robert J
12 years	No Subject	David Koehler
12 years	Having the databases for SQL	Jerry Parkinson
12 years	No Subject	Bonnie
Next >>

Subscribe to Access SQL Seminar Part 2
Get notifications when this page is updated