Home

About Us

Catalog Main Catalog Microsoft Access Courses Database Development Courses Discounts and Passports Miscellaneous Fees & Services SQL Courses

Contact Us

AIN100B: Microsoft Access Training Part 2 Book List | Course Links
Tuition: $165.00 per student Length: 1 day
Synopsis: 1 day introductory course covering database design, subdatasheets, data validation, advanced queries, and advanced reporting techniques. Using our courseware students may update several small database applications, including any created in AIN100A. This course is the same as AIN100 Introduction to Microsoft Access day 2.
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	Tables and Queries	3.0 Hours
	Designing a Relational Database Relational Database Design Create a Table Joining Tables Joining Tables Create Query Joins Relate Data Within a Table Work with Subdatasheets Using Data Validation Use Field Validation Use Form and Record Validation
Session 2	Advanced Queries and Reporting	3.0 Hours
	Creating Advanced Queries Create Parameter Queries Summarize Data Create Subqueries Create Action Queries Create Unmatched and Duplicate Queries Organize a Database for Efficiency Data Normalization Create a Junction Table Improve Table Structure Using Advanced Reporting Techniques Include Control Formatting in a Report Add a Calculated Field to a Report Add a Subreport to an Existing Report

Materials: Students will receive a comprehensive manual and a training certificate.   Location: Classes are normally taught on-site at your facilities or via online Remote Learning. 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.