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
12 years	No Subject	Bonnie
12 years	No Subject	Jim Ogier
13 years	Access SQL Seminar Part 2	Jyotsana J
13 years	SQL and capital letters	Zied Ben Afia
13 years	Markup	Lone Vistoft
13 years	Markup	Lone Vistoft
13 years	VendorProductUpdateF UnitPrice	Lone Vistoft
13 years	DateSerial Format	MUBEEZI MICAH
13 years	Deleting duplicate records	Ala Qabaja
13 years	Compile Error invalid use of property	Jes
14 years	updating my unit cost	Jim
14 years	update the original database	Jim
14 years	No Subject	shamsMomin
14 years	Pressing Enter	Bonnie
14 years	Pressing Enter	Bonnie
14 years	No Subject	BONNIE STAIB
14 years	No Subject	Bonnie
15 years	No Subject	Rob Miller
15 years	Access SQL Seminar Part 2	eddy geijselaers
15 years	Access SQL Seminar Part 2	eddy geijselaers
<< Previous Next >>

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