Introduction to Microsoft Access 2 day introductory course covering 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.
Microsoft Access Level 1 1 day introductory Microsoft Access course covering 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. These can be tailored to the needs of a custom group or private training student. No prior knowledge of Access is assumed. The next class in sequence is AIN100B Microsoft Access level 2.Following the class students will have on-going access to online materials such as videos and assesments.
Microsoft Access Level 2 1 day introductory course covering database normalization, subdatasheets, import/export, advanced queries, reports and forms. 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. Microsoft Access knowledge equivalent to AIN100A is assumed. The next class in sequence is AIN103 Microsoft Access level 3.Following the class students will have ongoing access to online support materials such as videos and assesments.
Accelerated Introduction to Access Accelerated Introduction to Microsoft Access course 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
Microsoft Access Level 3 This course covers advanced form design, working with macros, sharing data, and performing database maintenance. Classroom activities can be tailored for private classes. Microsoft Access knowledge equivalent to AIN100B is assumed.
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.
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.
Access SQL & Query Design Introductory Access SQL Programming course using MS Access. Also covers using the MS Access Query Designer. Students will gain a thourough introduction to designing and implementing MS Access queries using Access's JET SQL in this unique course. Can be taught with SQL Server, MySQL or Oracle as the back-end. A basic knowledge of MS Access and query concepts is assumed.
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.
Microsoft Access courses are offered in three formats: 1) on-site at your location or our studio in San Juan Capistrano, Orange County, California), 2) Private one-one-training as arranged, and 3) scheduled classes in San Juan Capistrano (most offered every week or two). See calendar...
(Final prices will reflect tuition, materials,
registration, applicable discounts and charges.)