Microsoft Access Courses (Curriculum
Suggestions...)
Prices shown are list prices before applicable discounts. Click
on the item title for a full description.
Introduction to Microsoft Access 2 day introductory course to Microsoft Access, the leading desktop database. Covers databases, tables, the datasheet, sorting and manipulating tables, import/export, queries, forms and reports. Using our supplied courseware, students will work on several small database application during this course. These database can be tailored to the needs of custom groups or private training students. No prior knowledge of Access is assumed. As part of our courseware platform students have online access to course materials such as checklists, videos and assessments.
2 days
$295.00/Student
Microsoft Access Training Part 1 1 day introduction to Microsoft Access, the most popular desktop database solution. Microsoft Access provides a wealth of powerful data management and reporting tools in a very user friendly environment. This course covers databases, tables, the datasheet, sorting and manipulating tables, basic queries, reports and forms. Using our courseware students will work on several small database applications during this course or develop their own. These can be tailored to the needs of a custom group or private training student. No prior knowledge of Access is assumed. This course is the same as AIN100 Introduction to Microsoft Access day 1.
1 day
$165.00/Student
Microsoft Access Training Part 2 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.
1 day
$165.00/Student
Accelerated Introduction to Access Accelerated Introduction to Microsoft Access, the powerful but user-friendly desktop database. For experienced Microsoft Office users. Corresponds roughly to material required for MOS certification. Covers tables, external data, queries, forms, reports, action queries, macros and navigation. Students will create a working database application during this intensive, hands-on course. This database can be tailored to the needs of custom groups or private training students. No prior knowledge of Access assumed although students should be proficent with standard Microsoft Office.
1 and 1/2 days
$245.00/Student
Microsoft Access Training Part 3 This course covers advanced form techniques, sharing data, working with macros and VBA, performing database maintenance and switchboards. Classroom activities can be tailored for private classes. Microsoft Access knowledge equivalent to AIN100 is assumed.
1 day
$165.00/Student
Microsoft Access Focus on Queries 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.
1 day
$165.00/Student
Microsoft Access Reporting & Analysis A hands-on introduction to Microsoft Access specially designed for those who will be downloading data and using Access for reporting and analysis. Course covers tables, external data, queries, action queries and reports. Classes can be tailored to the needs of custom groups or private training students. No prior knowledge of Access is assumed.
1 day
$165.00/Student
Beginning Access VBA Training One day beginning Access VBA course. Covers modules, classes, programming constructs, etc. Requires some familiarity with basic programming concepts.
1 day
$195.00/Student
Intermediate Access VBA Training Half day Intermediate Access VBA programming. Covers data manipulation via ADO and DAO. Pre-requisite: AVB201 and SQL200A or equivalent knowledge.
1/2 day
$95.00/Student
Programming Microsoft Access using VBA One day introduction to programming Access databases using VBA. Covers, modules, subs, VBA GUI, Collections, Active X and debugging.
1 day
$195.00/Student
Microsoft Access Hourly Training (Tutoring); min 1 hr Hourly price for one-on-one Private Training (Tutoring) on Microsoft Access via online Zoom session. Material may be selected as needed by the student. Possibilities include table design, queries, forms, reports macros, VBA, etc. Minimum 1 hour.
1 hr
$45.00/Hour
Access SQL & Query Design Training Introductory Access SQL Programming course using MS Access. Also covers using the MS Access Query Designer. Students will gain a thorough introduction to designing and implementing MS Access queries using JET SQL in this unique course. Can also be taught with SQL Server, MySQL or Oracle as the back-end. A basic knowledge of MS Access and query concepts is assumed.
1 day
$195.00/Student
Relational Database Design - A Practical Approach In this course students will learn the general principles involved in designing a database that complies with the relational database model. The conceptual content of this course is not specific to any software application but Microsoft Access will be used to perform the tasks in the lessons pertaining to queries. Visio or an equivalent modeling tool will be used for diagramming exercises. Students should have some familiarity with data tables and basic knowledge of how to create queries in Microsoft Access or equivalent.
1 day
$245.00/Student
Individual Microsoft Access Training Passport 4 full days of Microsoft Access classes for six months. Valid for six months from date of purchase. Additional days may be purchased on the original invoice or at any time during the passport period.
Please refer to the Combo Passport if interested in additional courses such as SQL and Database Design.
4 days
$395.00/Student
Microsoft Access courses are offered to both groups and individuals on a convenient, custom scheduled basis. We can even tailor the class to your needs. Most classes run from 9:00AM to 4:00PM with a 1 hour lunch break.
(Final prices will reflect tuition, materials,
registration, applicable discounts and charges.)
