YouTube Channel

Microsoft Office Access

For Competitive Examinations

MS Access Notes, MCQs & Quiz

Find Current Job Openings
Buy/Download Books

📘 Complete Syllabus for Microsoft Office Access (Full Detailed Version)

🧩 Module 1: Introduction to Microsoft Access

1. Overview

  • 1.1.5.1. Tables
  • 1.1.5.2. Queries
  • 1.1.5.3. Forms
  • 1.1.5.4. Reports
  • 1.1.5.5. Macros
  • 1.1.5.6. Modules

2. Access Interface Overview

  • 1.2.1. Start Screen & Template Gallery
  • 1.2.2. The Ribbon Interface (Tabs & Groups)
  • 1.2.3. Quick Access Toolbar (Customization)
  • 1.2.4. Navigation Pane
  • 1.2.5. Object Tabs (Document Tabs)
  • 1.2.6. Status Bar Indicators
  • 1.2.7. Context Menus
  • 1.2.8. Zoom Controls & Property Sheets

🗂️ Module 2: Database Creation & Management

1. Creating Databases

  • 2.1.1. Blank Database vs. Template Database
  • 2.1.2. Setting Database Name & Location
  • 2.1.3. Saving Database Files
  • 2.1.4. Access Options (General, Current Database, Object Designers, Proofing, Language, Client Settings)

2. Managing Databases

  • 2.2.1. Opening, Closing, Compacting & Repairing Databases
  • 2.2.2. Backing Up and Restoring Databases
  • 2.2.3. Database Splitter (Front-End & Back-End)
  • 2.2.4. Linking Tables from External Databases
  • 2.2.5. Converting Older Database Formats
  • 2.2.6. Password Protection & Encryption
  • 2.2.7. Trust Center Settings (Macro Security, Trusted Locations)

📊 Module 3: Tables – The Foundation of a Database

1. Understanding Tables

  • 3.1.1. Concept of Fields, Records & Data Types
  • 3.1.2. Primary Key and Foreign Key
  • 3.1.3. Field Properties (Field Size, Format, Input Mask, Default Value, Validation Rule, Caption, Required, Indexed)

2. Creating Tables

  • 3.2.1. Table Design View vs. Datasheet View
  • 3.2.2. Adding, Editing & Deleting Fields
  • 3.2.3. Field Data Types:
  • 3.2.3.1. Short Text
  • 3.2.3.2. Long Text (Memo)
  • 3.2.3.3. Number
  • 3.2.3.4. Date/Time & Date/Time Extended
  • 3.2.3.5. Currency
  • 3.2.3.6. AutoNumber
  • 3.2.3.7. Yes/No
  • 3.2.3.8. OLE Object
  • 3.2.3.9. Hyperlink
  • 3.2.3.10. Attachment
  • 3.2.3.11. Calculated Field
  • 3.2.3.12. Lookup Wizard

3. Table Relationships

  • 3.3.1. Creating Relationships between Tables
  • 3.3.2. One-to-One, One-to-Many, Many-to-Many Relationships
  • 3.3.3. Enforcing Referential Integrity
  • 3.3.4. Cascade Update & Cascade Delete Options
  • 3.3.5. Relationship Window Navigation

4. Table Tools

  • 3.4.1. Table Analyzer Wizard
  • 3.4.2. Indexing and Sorting Data
  • 3.4.3. Importing Data into Tables (Excel, CSV, XML, Text, ODBC, SharePoint, SQL Server)
  • 3.4.4. Exporting Tables (Excel, PDF, Text, XML, HTML)
  • 3.4.5. Data Validation Rules & Input Masks

🔍 Module 4: Queries – Retrieving and Manipulating Data

1. Query Basics

  • 4.1.1. What is a Query?
  • 4.1.2. Types of Queries:
  • 4.1.2.1. Select Query
  • 4.1.2.2. Parameter Query
  • 4.1.2.3. Crosstab Query
  • 4.1.2.4. Action Queries (Append, Update, Delete, Make-Table)
  • 4.1.2.5. Find Duplicates Query
  • 4.1.2.6. Find Unmatched Query
  • 4.1.2.7. Union Query
  • 4.1.2.8. SQL-Specific Query

2. Query Design

  • 4.2.1. Using Query Design View
  • 4.2.2. Adding Tables to Queries
  • 4.2.3. Setting Criteria, Sorting, and Filtering
  • 4.2.4. Using Wildcards and Operators:
  • 4.2.4.1. AND, OR, BETWEEN, LIKE, IN, NOT, IS NULL
  • 4.2.5. Calculated Fields and Expressions
  • 4.2.6. Totals Row (Aggregate Functions)
  • 4.2.7. Using Expression Builder
  • 4.2.8. Group By, Count, Sum, Avg, Min, Max Functions

3. SQL View

  • 4.3.1. SQL Syntax in Access
  • 4.3.2. SELECT, FROM, WHERE, ORDER BY Clauses
  • 4.3.3. Joins (INNER, LEFT, RIGHT, CROSS)
  • 4.3.4. Subqueries
  • 4.3.5. Creating and Saving SQL Queries
  • 4.3.1. Insert shapes, lines, arrows

🧾 Module 5: Forms – Data Entry & User Interface

1. Creating Forms

  • 5.1.1. Form Wizard
  • 5.1.2. Blank Form & Form Design View
  • 5.1.3. Split Form, Multiple Items Form, Navigation Form

2. Form Controls

  • 5.2.1. Bound vs. Unbound Controls
  • 5.2.2. Text Box, Combo Box, List Box, Option Group, Command Button, Label, Image, Subform/Subreport, Tab Control
  • 5.2.3. Inserting Controls from the Design Tab

3. Form Layouts

  • 5.3.1. Design View vs. Layout View
  • 5.3.2. Aligning & Sizing Controls
  • 5.3.3. Grouping, Anchoring & Tab Order
  • 5.3.4. Conditional Formatting in Forms
  • 5.3.5. Control Properties (Data, Event, Format, Other)

4. Advanced Form Features

  • 5.4.1. Creating Subforms
  • 5.4.2. Combo Box Lookup Fields
  • 5.4.3. Using Macros in Forms
  • 5.4.4. Navigation Control & Custom Menu Forms
  • 5.4.5. Form Events (On Load, On Click, On Current, On Change)

📑 Module 6: Reports – Data Presentation

1. Creating Reports

  • 6.1.1. Report Wizard
  • 6.1.2. Blank Report
  • 6.1.3. Label Wizard

2. Report Design

  • 6.2.1. Report Sections: Report Header, Page Header, Detail, Page Footer, Report Footer
  • 6.2.2. Grouping & Sorting Data
  • 6.2.3. Adding Totals & Calculations
  • 6.2.4. Adding Images, Charts, and Logos
  • 6.2.5. Conditional Formatting in Reports
  • 6.2.6. Page Setup (Margins, Orientation, Size)

3. Report Tools

  • 6.3.1. Design View & Print Preview
  • 6.3.2. Customizing Fonts, Colors, Themes
  • 6.3.3. Using Expression Builder in Reports
  • 6.3.4. Exporting Reports (PDF, Word, Excel, Email)

⚙️ Module 7: Macros & Automation

1. Introduction to Macros

  • 7.1.1. What is a Macro?
  • 7.1.2. Macro Security Settings

2. Creating Macros

  • 7.2.1. Macro Designer Interface
  • 7.2.2. Action Catalog
  • 7.2.3. Adding, Editing & Deleting Macro Actions

3. Macro Actions

  • 7.3.1. OpenForm, CloseForm, OpenReport
  • 7.3.2. GoToRecord, GoToControl, RunCommand
  • 7.3.3. SetValue, MsgBox, StopMacro, If/Else Conditions
  • 7.3.4. RunMacro, RunCode
  • 7.3.5. Data Macros (Table Event Triggers: After Insert, After Update, After Delete)

4. Embedded Macros

  • 7.4.1. Attaching Macros to Form or Report Events
  • 7.4.2. Handling Form Validation with Macros

💻 Module 8: Modules & VBA Programming

1. Introduction to VBA

  • 8.1.1. What is VBA in Access
  • 8.1.2. VBA Editor Interface
  • 8.1.3. Writing and Running Procedures

2. VBA Components

  • 8.2.1. Sub Procedures and Functions
  • 8.2.2. Variables, Constants & Data Types
  • 8.2.3. Operators and Control Structures (If, For, While, Select Case)
  • 8.2.4. Working with Access Objects through VBA

3. Automating Tasks

  • 8.3.1. Automating Forms, Reports, and Queries
  • 8.3.2. Error Handling (On Error Resume Next, Err.Description)
  • 8.3.3. Creating Custom Functions
  • 8.3.4. Using Events in VBA (Form_Load, Form_Current, Click)

🌐 Module 9: Data Import, Export & Integration

  • 9.1. Importing Data (Excel, CSV, XML, SharePoint, SQL Server, Outlook)
  • 9.2. Exporting Data (Excel, Word, PDF, Text, HTML)
  • 9.3. Linking External Data Sources
  • 9.4. Using ODBC Connections
  • 9.5. Working with SharePoint Lists
  • 9.6. Mail Merge with Microsoft Word

🔐 Module 10: Database Security & Maintenance

  • 10.1. Setting Database Passwords
  • 10.2. Encryption with Database Password
  • 10.3. User-Level Security (Legacy MDB Databases)
  • 10.4. Managing Permissions
  • 10.5. Backing Up Databases
  • 10.6. Compact and Repair Utility
  • 10.7. Splitting Databases for Multi-User Environments

🧠 Module 11: Advanced Access Features

  • 11.1. Access Options Customization
  • 11.2. Navigation Form Creation
  • 11.3. Startup Options (Custom Splash Screen, Hiding Navigation Pane)
  • 11.4. Custom Menus and Ribbons
  • 11.5. Switchboard Manager (Legacy Feature)
  • 11.6. Data Validation Rules & Expressions
  • 11.7. Using TempVars
  • 11.8. Creating Linked Table Manager
  • 11.9. Database Documentation Tool

📈 Module 12: Database Design & Best Practices

  • 12.1. Principles of Database Normalization (1NF, 2NF, 3NF)
  • 12.2. Entity Relationship (ER) Design
  • 12.3. Data Integrity & Referential Integrity
  • 12.4. Designing User-Friendly Interfaces
  • 12.5. Performance Optimization (Indexing, Queries)
  • 12.6. Backup & Version Management

🧾 Module 13: Printing, Sharing & Publishing

  • 13.1. Page Setup for Forms & Reports
  • 13.2. Print Preview Options
  • 13.3. Export to PDF/XPS
  • 13.4. Email Reports Directly from Access
  • 13.5. Publish to SharePoint & Access Services (for older versions)

🧰 Module 14: Shortcuts, Tips & Tricks

  • 14.1. Keyboard Shortcuts (Ctrl, Shift, Alt combinations)
  • 14.2. Navigation Shortcuts in Datasheet View
  • 14.3. Debugging Queries and VBA Code
  • 14.4. Performance Optimization Tips
  • 14.5. Common Troubleshooting Techniques

🧩 Module 15: Practice Projects & Case Studies

  • 15.1. Create a Library Management System
  • 15.2. Create a Student Database System
  • 15.3. Create a Sales & Inventory System
  • 15.4. Create a Clinic Appointment Database
  • 15.5. Create an Employee Payroll System

All courses are free, don’t give any charges, ignore them  if anyone charge.

Contact For Assistance/Give If You Have Any Suggession

The Website Is Yours | Keep Reading | Upgrade Your Skill | Get Success | Stay Stress Free

Quick Links

  • Home
  • About
  • Blog
  • Job Openings
  • Downloads
  • Shop
  • Contact

Subject/Courses

  • Mathematics
  • General Studies
  • English Language
  • Reasoning
  • Computer
  • Current Affairs
  • MCQ's Tests

Important Links

  • Exams
  • Notifications
  • Admit Card
  • Employment Exchange
  • Cast/Resident Certificate
  • Educational Certificates
  • Police Verification

Legal Links

  • Privacy Policy
  • Terms Of Use
  • Disclaimer
  • Refund Policy
  • Delivery Policy
  • Sitemap
  • Support

Social Connects

YouTube Channel
Facebook Page
Telegram Group
WhatsApp Group

Copyright © 2004-2025 Mind Set Education – Managed By: mLand India Technologies. All Rights Reserved.

error: Content is protected !!

IMPORTANT NOTICE

We are MindSet Competitive Education Team/ Family. We are currently uploading our course contents continuously to complete and to lunch the website for you all as soon as possible. But we are continuously update course contents/topics from START, so you can stat your Competitive Preparation Journey from start to end step by step.

Anybody Interested To Join Our Courses(Free For All) and get everyday updates on courses/topics/Current affairs.

JOIN OUR WHATSAPP GROUP
JOIN OUR TELEGRAM GROUP