Savvy Axis Logo SAY
XISS

Course Details

  1. Home
  2. Course

Microsoft Access Course – Intermediate Level

Advance your Microsoft Access skills and learn to work with relational databases, queries, and data analysis tools. This course is ideal for those looking to deepen their database knowledge.

4.8 Rating Intermediate Course 8 Weeks

About this Course

This intermediate course in Microsoft Access expands upon the basics to cover relational databases, complex queries, and essential database management tools. You’ll learn how to create relationships between tables, use advanced query functions, and manage larger data sets effectively. By the end of this course, you’ll be able to build more dynamic and functional databases.

Course Objective

The objective of this course is to deepen your understanding of Microsoft Access by teaching you to build relational databases, develop complex queries, and apply effective database management practices for intermediate-level projects.

Skills you'll gain

Design Relational Databases Advanced Query Techniques Data Analysis & Reporting

Syllabus

  • Overview of Microsoft Access Interface
    • Understanding the Access Interface and Ribbon
    • Navigating Database Objects (Tables, Queries, Forms, Reports)
    • Customizing the Quick Access Toolbar
  • Basic Database Concepts
    • Understanding Databases and Their Uses
    • Introduction to Relational Databases

  • Table Creation and Setup
    • Creating a New Table
    • Setting Data Types and Field Properties
    • Understanding Primary Keys and Their Importance
  • Working with Table Data
    • Adding, Editing, and Deleting Records
    • Sorting and Filtering Table Data

  • Introduction to Queries
    • Understanding the Purpose of Queries
    • Creating Basic Queries with Query Wizard
  • Query Criteria and Filters
    • Applying Criteria to Limit Data
    • Using Wildcards and Parameters in Queries

  • Introduction to Forms
    • Creating a Simple Form Using the Form Wizard
    • Using the Form Design View
  • Customizing Form Layouts
    • Formatting Controls and Layouts
    • Setting Tab Order and Control Properties

  • Working with Calculated Fields
    • Creating Calculations and Expressions in Queries
    • Understanding Aggregate Functions (SUM, AVG, COUNT)
  • Parameter and Crosstab Queries
    • Creating Parameter Queries for User Input
    • Designing Crosstab Queries for Summary Data

  • Using Form Controls
    • Adding Text Boxes, Labels, Combo Boxes, and Checkboxes
    • Managing Control Properties and Event Handlers
  • Form Navigation and Search Features
    • Adding Navigation Buttons for Record Movement
    • Implementing Search Functionality in Forms

  • Setting Up Data Validation
    • Defining Field Validation Rules and Text
    • Using Input Masks for Data Entry Control
  • Managing Errors and Warnings
    • Setting Default Values and Limiting Null Entries
    • Handling Common Data Entry Errors

  • Designing Complex Reports
    • Creating Grouped and Sorted Reports
    • Adding Calculated Fields and Summary Totals
  • Report Formatting and Printing Options
    • Applying Conditional Formatting to Reports
    • Setting Up Page Layout and Print Settings

About the Instructor

Shalini Baskaran

Founder & CEO

4.98 Instructor rating

40 Students

Shalini Baskaran, is the CEO and Curriculum Director at Savvy Axiss. With a deep background in computer science, she has designed numerous courses to build strong foundations for aspiring programmers. Known for her clear, practical teaching style, she excels at making complex topics accessible. She is passionate about empowering students with real-world skills, and she looks forward to guiding you through this foundational journey in programming.

Fee ₹ 2999

₹ 1999

ENROLL NOW

Duration

8 Weeks

Class Time

1.5 Hours

Enrolled

250 students

Language

English / Tamil

Skill Level

Intermediate

Schedule

Monday to Friday

Certificate

Yes

Share this Course