|
|
|
|
|
|
AIN102: Microsoft Access Focus on Queries
|
Book List |
Course Links
|
|
|
|
Tuition: $165.00 per student |
Length: 1 day |
|
|
Synopsis:
Learn effective MS Access query design in this unique, hands-on course. Covers select, maketable, append, update, delete and union queries. Includes single and multi-table queries, functions, summary queries, inner joins, outer joins, and subqueries. Ideal course for those seeking a deeper knowledge of Access queries than is taught in traditional Access classes.
|
|
Formats:
Custom scheduled corporate groups (min. 2 students) at your facility or via Remote Learning. Single individuals may arrange a private online session.
|
|
Scheduling:
Flexible to suit your requirements. Both onsite and online classes are custom scheduled.
|
|
Group
Discounts:
2-4 students 20%, 5-8 30%, >8 quote
|
|
|
|
| Session 1 | Basic MS Access Data Retrieval | 3.0 Hours | | |
- Relational database foundations
- Basic data retrieval operations
- Select queries
- Filters, Where clause
- Special Operators, Searching
- Sorting
- Calculated fields, Concatenation
- Parameter Queries
| | | Session 2 | Advanced MS Access Queries | 3.0 Hours | | |
- String Manipulation
- Date Functions, Etc.
- SQL Aggregate functions (SUM, AVG, etc.)
- Group by
- Having
- Inner join, outer joins, self join
- Subqueries
- Unions
- Action queries (Maketable, Append, Update, Delete, Maketable)
| |
|
|
Materials:
Students will receive a notebook with a printout of all slides used in their class and a training certificate.
|
|
Location:
Classes are normally taught on-site at your facilities or at our studio in San Juan Capistrano, Orange County, California. We may also be able to host the class in a rented university classroom near you. Please see FAQs if interested.
|
|
Related Services |
|
Need
help with a project? We may also provide programming
and consulting services covering the above material. See
Programming and Consulting for more information.
|
|
|
|
