12-Month Diploma · Office + Accounting + Web + DBMS
ADCA — Advanced Diploma in Computer Applications
32 hands-on modules · 20+ tools & features · 200+ hours of training · A deeper diploma combining the office suite, Tally & accounting basics, HTML web fundamentals and an introduction to database management — built for office, accounts and entry-level IT roles.
Who this course is for
Built for students, freshers and job-seekers who want a deeper, one-year diploma that goes beyond office basics — combining document & spreadsheet skills with real accounting practice on Tally, an introduction to building web pages, and the fundamentals of how databases work.
By the end you'll produce professional documents in Word, Excel & PowerPoint, maintain company accounts and GST invoices in Tally Prime, build a simple website using HTML & CSS, and write basic SQL queries against a small database — a strong, well-rounded foundation for office, accounts and entry-level IT roles.
1Program structure
Six phases over 48 weeks, moving from computer fundamentals through the office suite and internet skills into Tally & accounting, HTML web basics, and a first introduction to database management.
| Phase | Modules | Focus |
|---|---|---|
| Phase 1 — Computer Fundamentals & Typing | 01–06 | Computer basics, hardware/software, Windows OS, file management, keyboard skills, touch-typing practice |
| Phase 2 — Office Suite | 07–14 | MS Word documents & mail merge, MS Excel formulas, charts & pivot tables, MS PowerPoint, MS Access basics |
| Phase 3 — Internet, Digital Tools & Cyber Safety | 15–18 | Internet & browsers, email, digital financial tools, government e-services, cyber safety |
| Phase 4 — Tally & Accounting Basics | 19–24 | Accounting fundamentals, Tally Prime setup, ledgers & vouchers, inventory, GST invoicing, financial reports |
| Phase 5 — Web Fundamentals (HTML & CSS) | 25–28 | How the web works, HTML structure & tags, forms/tables/media, CSS styling basics |
| Phase 6 — Introduction to DBMS & Capstone | 29–32 | Database concepts, tables/keys/relationships, SQL basics, final capstone project |
2Full 32-module curriculum
Tap a phase to expand it, then tap any module for what it covers. Every module ends in a hands-on practice task and a short checklist, so you learn by doing, not just watching.
Phase 1 Computer Fundamentals & Typing Modules 01–06 Computer basics, hardware/software, Windows OS, file management, keyboard skills, touch-typing practice +
01Introduction to Computers & Hardware+
What a computer is, input/output devices, CPU & memory basics, and the difference between hardware and software.
02Operating System Basics (Windows)+
Desktop, Start menu, taskbar, Control Panel/Settings, installing & uninstalling programs, and basic troubleshooting.
03File & Folder Management+
Creating, renaming, moving, copying and deleting files/folders, and organising data sensibly on a shared computer.
04Typing Fundamentals & Keyboard Skills+
Correct finger placement, home-row technique, and building muscle memory for accurate, screen-free typing.
05Touch-Typing Speed & Accuracy Building+
Timed typing drills in English/Hindi, tracking words-per-minute, and reducing errors under time pressure.
06Peripherals, Storage & Basic Maintenance+
Printers, scanners, pen drives, cloud vs local storage, and simple upkeep habits like updates and safe shutdowns.
Phase 2 Office Suite Modules 07–14 MS Word documents & mail merge, MS Excel formulas, charts & pivot tables, MS PowerPoint, MS Access basics +
07MS Word — Documents & Formatting+
Typing, formatting and structuring documents — fonts, alignment, styles, headers/footers, and page setup.
08MS Word — Tables, Mail Merge & Templates+
Building tables, using Mail Merge for bulk letters, and creating reusable templates for common documents.
09MS Excel — Basics & Formulas+
Cells, rows & columns, everyday formulas (SUM, AVERAGE, IF), and building a clean, error-free data table.
10MS Excel — Charts & Pivot Tables+
Turning raw numbers into charts, building pivot tables for quick summaries, and preparing a sheet ready for printing or sharing.
11MS Excel — Advanced Functions & Lookups+
Nested IF, VLOOKUP/HLOOKUP, conditional formatting, and building a small automated report from raw data.
12MS PowerPoint — Presentations+
Building slides, layouts, images & text, transitions, and presenting information clearly and confidently.
13MS Access — Database Basics+
What a database is, creating simple tables, and running basic queries to find and organise records.
14Office Suite Integration Project+
A combined exercise linking Word, Excel and PowerPoint output into one coherent office task, mirroring real workplace requests.
Phase 3 Internet, Digital Tools & Cyber Safety Modules 15–18 Internet & browsers, email, digital financial tools & government e-services, cyber safety +
15Internet Basics & Browsers+
How the internet & web pages work, browsers, search engines, and finding reliable information quickly.
16Email & Cloud Storage+
Creating an email account, writing professional emails and attachments, plus uploading & sharing files on cloud storage.
17Digital Financial Tools & Government e-Services+
Setting up and safely using UPI/net banking, plus DigiLocker & UMANG for documents and government services.
18Cyber Safety & Online Security+
Passwords, phishing & scam awareness, safe browsing habits, and protecting personal data online.
Phase 4 Tally & Accounting Basics Modules 19–24 Accounting fundamentals, Tally Prime setup, ledgers & vouchers, inventory, GST invoicing, financial reports +
19Fundamentals of Accounting & Bookkeeping+
Basic accounting terms, types of accounts, and the golden rules of debit & credit before touching any software.
20Introduction to Tally Prime+
Installing & navigating Tally Prime, creating a company, and setting up a chart of accounts.
21Ledgers, Vouchers & Day Book Entries+
Creating ledgers, recording payment/receipt/sales/purchase vouchers, and reviewing the day book.
22Inventory Management in Tally+
Stock groups & items, purchase/sales with inventory, and tracking stock summary reports.
23GST Basics & Tax Invoicing+
GST fundamentals, enabling GST in Tally, and generating GST-compliant sales & purchase invoices.
24Financial Reports & Statements+
Generating trial balance, profit & loss account, and balance sheet directly from your Tally data.
Phase 5 Web Fundamentals (HTML & CSS) Modules 25–28 How the web works, HTML structure & tags, forms/tables/media, CSS styling basics +
25Introduction to the Web & How Websites Work+
Client vs server, what a browser does with a web page, and setting up a simple code editor.
26HTML — Structure, Tags & Elements+
Page structure, headings, paragraphs, links & images, and building your first static web page.
27HTML — Forms, Tables & Media+
Building input forms, structuring tabular data, and embedding images, audio & video on a page.
28CSS Basics — Styling Web Pages+
Colours, fonts, spacing & layout with CSS, and styling the page you built into something presentable.
Phase 6 Introduction to DBMS & Capstone Modules 29–32 Database concepts, tables/keys/relationships, SQL basics, final capstone project +
29Introduction to Databases & DBMS Concepts+
What a DBMS is, why databases matter over spreadsheets, and an overview of common database software.
30Tables, Keys & Relationships+
Designing tables, primary & foreign keys, and how related tables connect to model real data.
31SQL Basics — Queries, Insert & Update+
Writing SELECT queries to fetch data, and using INSERT/UPDATE/DELETE to manage records safely.
32Diploma Capstone Project+
A final project combining office, Tally/accounting and web/database skills into one demonstrable deliverable, planned and built independently.
320 tools & features you'll use
Everything is taught hands-on on real computers — not simulations. Swipe or use the arrows to browse every category.
4How each module is taught
Every module in the program follows the same simple, practice-first lens, so you always know what to expect in class.
Watch & Understand
Trainer demonstrates the formula, tool or technique step by step, using real data-heavy examples.
Practice Live
You repeat every step on your own computer in class, right after the demonstration, not days later.
Hands-on Exercise
A short practical task using the same tool, close to a real day-to-day or government-form scenario.
Doubt Clearing
One-on-one help for anyone still stuck, before the class moves to the next module.
Weekly Assessment
A short practical test every week so gaps are caught early, not at the end of the course.
5Projects & practice work
Eight practical assignments across the full syllabus — from everyday office documents to a working, database-driven capstone.
- Task 1. Timed touch-typing test at a target speed & accuracy in English/Hindi
- Task 2. Formal letter with a mail-merged address list in MS Word
- Task 3. Expense/budget tracker in MS Excel with formulas, a pivot table and a chart
- Task 4. An 8-slide presentation in MS PowerPoint on a given topic
- Task 5. Small MS Access database with a simple query
- Task 6. Company accounts set up in Tally Prime with ledgers, vouchers and a GST invoice
- Task 7. A static web page (personal profile or small business page) built with HTML & CSS
- Task 8. Diploma capstone project: a small database-driven mini application (e.g. student or inventory records) with SQL queries and a short report
6Assessment & certification
Weekly practical tests on typing, office tools, Tally/accounting, HTML & DBMS, with instructor feedback so nobody falls behind silently.
Final practical exam covering all six phases, plus the capstone project used as your demonstrable proof of skill.
Advanced Diploma in Computer Applications (ADCA) certificate on successful completion, plus resume & interview-readiness support through our 100% Placement Assist program.
7Quick answers
Do I need any prior computer knowledge to join ADCA?
No. ADCA is designed for beginners — Phase 1 starts from computer basics and typing, so no prior experience is assumed.
Do I need an accounting background before the Tally module?
No. Phase 4 starts with basic accounting & bookkeeping concepts (debit, credit, types of accounts) before you touch Tally Prime, building up gradually to vouchers, inventory, GST invoicing and financial reports.
Do I need to know coding before the HTML or DBMS modules?
No prior coding is assumed. Phase 5 starts with how the web works before any HTML tags, and Phase 6 starts with plain-language database concepts before writing your first SQL query.
How is ADCA different from DCA?
DCA is a 6-month, 24-module diploma covering the office suite, internet skills and an introduction to programming logic. ADCA is a 12-month, 32-module diploma that covers the same office & internet foundation in more depth, then adds Tally & accounting, HTML/CSS web fundamentals and an introduction to DBMS & SQL — making it a broader diploma for accounts and entry-level IT roles.
Do I need my own laptop for this course?
No. Classes are conducted on institute computers with all required software installed. You're welcome to bring your own laptop if you prefer to practice on it.
Are classes online, offline, or both?
Both. Offline batches run at our Alpha-1, Greater Noida campus; online live batches follow the same curriculum with the same trainers. Morning, evening and weekend timings are available — ask your counsellor for the current schedule.
What can I do after completing this course?
You'll be ready for office assistant, accounts/billing assistant, data-entry and junior back-office roles, with a working foundation in Tally, HTML and databases if you want to progress into our Accounting, Web Development or Data Analytics courses next, with the same placement support.
Ready to see a class live?
Book a free, no-obligation demo class and sit in on a real ADCA session before you decide anything.