Microsoft Access Level II Online

This course includes

6 hours of project-based training from experts
Software Access
Learn from a Microsoft Certified Trainer
Retake for free within 1 year
Access to class recordings (30 days)
Verified digital certificate of completion

If you're already managing databases in Microsoft Access, this self-paced Level II course will take your skills further. Learn how to create relational databases, write advanced queries, and generate sophisticated reports while deepening your understanding of fundamental concepts like relational database structure and data validation.

Building on the basics from Microsoft Access Level I, which covers creating tables, forms, reports, and queries, this course expands your knowledge to include advanced features and techniques. By mastering these skills, you’ll improve your database management efficiency and increase your ability to handle complex tasks, streamlining your workflow and boosting productivity.

Full Tuition

$325
Due before the class starts

This course includes

6 hours of project-based training from experts
Software Access
Learn from a Microsoft Certified Trainer
Retake for free within 1 year
Access to class recordings (30 days)
Verified digital certificate of completion

Learning Experience Highlights

Learn from world-class creators

Classes taught by leading photographers, designers, and artists who share real workflows and insights

Several students, sitting at computers, looking at the front of the classroom

Watch anywhere, on your schedule

Stream on-demand video lessons at your own pace. Rewatch anytime, on any device, whenever inspiration strikes

Shabang! I'm really enjoying the class. This course feels like a workshop with step by step demo on every piece of theory and with tons of details."
— Gerald B.

Comprehensive course materials

Downloadable guides & practice files crafted to support your creative journey

Join a global creative community

Connect with thousands of fellow learners and get inspired by creators from around the world

100% Online. Start Anytime

24/7 access to our premium course videos and projects.
Industry experts are assigned as your course instructor. Message your instructor with any questions.
Participate in CreativeLive online discussion forums — share ideas and receive additional support.
Hands-on quizzes and mini projects to test and reinforce concepts.

Earn a Certificate of Completion

Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!

Shareable on

Sample credential for completion of Microsoft Access Level II (Self-Paced)

Microsoft Access Level II (Self-Paced) Curriculum

What You'll Learn at a Glance

Design a relational database and join tables to retrieve data from multiple sources
Validate data entered into the database to ensure accuracy
Use advanced queries to manipulate and analyze data
Organize your database for better performance and data integrity
Customize reports to format data and create specific print layouts

Course Syllabus

Download Syllabus PDF

Designing a Relational Database

Relational Database Design
Create a Table
Create Table Relationships

Joining Tables

Create Query Joins
Relate Data Within a Table
Work with Subdatasheets

Using Data Validation

Use Field Validation
Use Form and Record Validation

Creating Advanced Queries

Create Parameter Queries
Summarize Data
Create Subqueries
Create Action Queries
Create Unmatched and Duplicate Queries

Organizing 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

Installments
	10% non-refundable deposit
$325.00	Total You Pay