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.

COURSE PREREQUISITE(S)

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 NOTES

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.

LESSON 1

Understanding Database Relationships; Defining a Database Relationship; Modifying Table Design

LESSON 2

Selecting Data from a Single Table; Selecting Data from Multiple Tables; Creating Parameter and Action Queries; Summarizing and Grouping Data; Optimizing a Query

LESSON 3

Creating Advanced Forms; Using Advanced Controls; Creating and Modifying a Subform; Creating and Modifying a Switchboard Form

LESSON 4

Creating a Complex Report; Working with Subreports and Charting Data; Creating PivotTables and PivotCharts

LESSON 5

Importing and Exporting Data; Data Collection; Introducing Microsoft SharePoint Services; Sharing Files on the Web Using Microsoft SharePoint

LESSON 6

Creating and Using a Macro; Maintaining a Database; Optimizing and Documenting a Database

0 hours
Course Duration
Request Information