Software Coaching

Home

Classes that I teach

Testimonials

Contact Information

My Teaching Schedule

Access 2007

Session 4:

Querying with SQL
 SQL and Access
 Writing SQL statements
 Attaching SQL queries to controls


Advanced queries
 Creating crosstab queries
 Creating parameter queries
 Using action queries


Macros
 Creating, running, and modifying macros
 Attaching macros to the events of database objects


Advanced macros
 Creating macros to provide user interaction
 Creating macros that require user input
 Creating the AutoKeys and AutoExec macros
 Creating macros for data transfer


Web Hosting powered by Network Solutions®