Microsoft Access Level 2
The Microsoft Access Level 2 course teaches students advanced-level concepts and features of the Microsoft Access application. In this course, students work with advanced and complex queries, forms, and reports. Students learn to create PivotCharts and PivotTables, import and export data, use macros, and maintain, optimize, and document a database.
Students will accomplish the learning objectives for each lesson through a series of hands-on tasks, for which they will be given step-by-step instructions and desired result checkpoints. The tasks will provide ample opportunity for students to practice, apply, and develop the skills covered in the lesson.
A practice exercise and review questions are included at the end of each lesson to measure progress and reinforce the skills learned. There is also a Lab Exercise at the end of the course to provide further practice, review, and reinforcement of the topics learned throughout the course, and to help prepare students for the Final Exam.
To ensure successful completion of this course, it is recommended that students have completed the following courses, or possess equivalent knowledge and experience: Microsoft Access Level 1, Microsoft Excel Level 1, and Microsoft Outlook Level 1
METHOD OF DELIVERY
Integrated Learning™ System training facilitated by Academy of Learning Career College facilitators.
Course manual provided for on-going reference. There is a final exam upon completion of the course. Participants who receive 75% or higher on their exam will receive a certificate.
Understanding Database Relationships; Defining a Database Relationship; Modifying Table Design
Selecting Data from a Single Table; Selecting Data from Multiple Tables; Creating Parameter and Action Queries; Summarizing and Grouping Data; Optimizing a Query
Creating Advanced Forms; Using Advanced Controls; Creating and Modifying a Subform; Creating and Modifying a Switchboard Form
Creating a Complex Report; Working with Subreports and Charting Data; Creating PivotTables and PivotCharts
Importing and Exporting Data; Data Collection; Introducing Microsoft SharePoint Services; Sharing Files on the Web Using Microsoft SharePoint
Creating and Using a Macro; Maintaining a Database; Optimizing and Documenting a Database