Introduction
to Microsoft Access
Introductory course covering databases, tables, the
datasheet, sorting and manipulating tables, import/export, queries,
reports, forms, and macros. (Classes available in both Access 2003
and Access 2007).
Introduction
to Microsoft Access - I
Introductory course covering databases, tables, the
datasheet, relationships, filters, queries, basic reports and forms.
(Day 1 of AIN100 sequence; classes available in both Access 2003 and
Access 2007).
Microsoft
Access Reports and Forms
Intermediate Reports and Forms. Includes forms,
sub-forms, unbound forms, reports, sub-reports and using queries as
data sources.
Introduction
to SQL Queries
Introduction
to standard SQL queries. Intensive, hands-on SQL class focusing on
SQL data retrieval. Same as first two modules of SQL202. 212 or 201W.
Introduction
to Microsoft Access SQL
Slightly
shorter version of SQL200 SQL course specifically for MS Access
users. Hands-on class focusing on SQL data retrieval. (Advanced
version of AIN102).
Accelerated
Introduction to SQL Using Microsoft SQL Server I
Introduction
to the SQL programming language used in Microsoft SQL Server and
Sybase. Hands-on class featuring data manipulation, queries, data
modification, construction of tables, indexes, views. and constraints.
Accelerated
Introduction to SQL Using Oracle I
Introduction
to the SQL programming language as used in Oracle database systems.
Similar course to SQL202. Covers SQL select, insert, update, delete
and create statements.
Relational
Database Design
Introductory
course on the basics of relational database design including tables,
fields, keys, indexes, views, normalization, entity relationship
diagrams, and SQL.
Microsoft
Office
Courses
Click
on the course number or title for a full description with price. Please
note
that most classes include a CD with the PowerPoint slides and/or
the
CBT version of the course.
Custom Module
Do your
computer training needs differ from the standard courses? Let us
custom develop one or more half-day modules as required. And we'll
base it on your database and files if you like.
1)
On-site groups at your location in the Greater Los Angeles
and San Diego areas (or elsewhere in the U.S.). If desired, we can
also host your on-site group at our facility in San Juan Capistrano,
Orange County, California.
2)
Private 1-on-1 training at your facility or ours as arranged.
3)
Regularly scheduled classes in San Juan Capistrano - see
calendar...
(Final prices will reflect tuition
and registration, materials, discounts and
charges as applicable.)