ADCA Course (Advanced Diploma in Computer Applications) in Greater Noida (Alpha 1)
Go beyond the basics: MS Office, accounting with Tally, web fundamentals with HTML and a database introduction. 24 modules, hands-on practice and projects for accounts, office and back-office careers.
What is the ADCA course?
The ADCA (Advanced Diploma in Computer Applications) at Skill Training Institute, Alpha 1, Greater Noida is a 12-month program with 24 modules in 6 phases. You learn computer fundamentals and typing, the MS Office suite, accounting with Tally (including GST basics), web fundamentals with HTML, and a DBMS introduction with Access and SQL basics, then complete projects and interview preparation.
Last updated:
Full syllabus: 24 modules, 6 phases
Filter by topic or search.
Phase 1: Computer Foundations Modules 1–3
Computer Fundamentals Fundamentals
How computers work, from hardware to software.
- Hardware: CPU, memory, storage
- Input & output devices
- System vs application software
- Number systems basics
- Computer terminology
Windows Operating System Fundamentals
Use the desktop, files and settings with confidence.
- Desktop, Start menu, taskbar
- Files, folders & shortcuts
- Control Panel & Settings
- Installing & removing software
- Basic troubleshooting
Typing & Keyboard Skills Fundamentals
Build the speed and accuracy that office and accounts jobs expect.
- Home-row technique
- Typing tutor practice
- Speed & accuracy tests
- Keyboard shortcuts
- Daily timed drills
Phase 2: Office Suite Modules 4–9
MS Word: Documents & Formatting Office suite
Create professional documents.
- Text & paragraph formatting
- Styles & page layout
- Tables & pictures
- Headers, footers, page numbers
- Print & Save as PDF
MS Word: Advanced Features Office suite
Long documents and bulk letters.
- Mail merge
- Table of contents
- Track changes & comments
- Templates
- Document protection
MS Excel: Basics & Formulas Office suite
Calculate and organise data.
- Cells, ranges & formatting
- Relative & absolute references
- SUM, AVERAGE, COUNT, IF
- Text & date functions
- VLOOKUP basics
MS Excel: Data Analysis & Charts Office suite
Analyse and present numbers.
- Sorting & filtering
- Data validation
- Conditional formatting
- Charts
- PivotTables
MS PowerPoint Office suite
Design and deliver presentations.
- Layouts, themes, Slide Master
- Text, images, tables, charts
- Animations & transitions
- Slide Show & notes
- Export to PDF
Internet, Email & Online Services Office suite
Communicate and work online safely.
- Browsers & smart searching
- Email etiquette & attachments
- Cloud storage & sharing
- Video meetings
- Safe browsing & passwords
Phase 3: Accounting & Tally Modules 10–14
Accounting Fundamentals Tally & accounts
The accounting basics that Tally is built on.
- Assets, liabilities, income, expenses
- Double-entry system
- Journal, ledger, trial balance
- Final accounts basics
- Cash book & bank book
Tally: Company Setup, Ledgers & Vouchers Tally & accounts
Set up a company and record daily transactions.
- Create & configure a company
- Groups & ledgers
- Payment, receipt, journal, contra vouchers
- Sales & purchase vouchers
- Edit, alter & delete entries
Tally: Inventory & Stock Tally & accounts
Manage stock and billing.
- Stock groups, items & units
- Godowns
- Purchase & sales with stock
- Stock summary reports
- Invoice printing
Tally: GST Basics Tally & accounts
Record taxes correctly.
- What GST is: CGST, SGST, IGST
- GST ledgers & tax rates
- GST sales & purchase entries
- GST reports overview
- Common posting mistakes
Tally: Reports, Banking & Data Handling Tally & accounts
Produce reports a business owner needs.
- Day book & ledger reports
- Trial balance, P&L, balance sheet
- Bank reconciliation basics
- Backup & restore data
- Printing & exporting to Excel
Phase 4: Web Fundamentals with HTML Modules 15–18
How the Web Works Web (HTML)
The building blocks behind every website.
- Websites, browsers & servers
- Domain & hosting basics
- Web page structure
- Code editor setup
- Testing in a browser
HTML: Text, Links, Images & Tables Web (HTML)
Write your first web pages.
- Document structure & tags
- Headings, paragraphs, lists
- Links & images
- Tables
- Audio & video embedding
HTML: Forms & Page Structure Web (HTML)
Collect input and organise a page.
- Forms & input types
- Semantic tags
- Iframes & meta tags
- Basic accessibility
- Publishing a simple page
CSS Basics & Mini Website Web (HTML)
Make pages look good.
- Selectors & properties
- Colours, fonts, spacing
- Box model
- Simple layouts
- Build a small website
Phase 5: Database (DBMS) Introduction Modules 19–21
DBMS Concepts Database
How data is organised.
- Data, database & DBMS
- Tables, records, fields
- Primary & foreign keys
- Relationships
- Normalisation basics
MS Access Database
Build a working database.
- Create tables & relationships
- Queries
- Forms
- Reports
- Student or stock record project
SQL Basics Database
Ask questions of a database.
- SELECT & WHERE
- ORDER BY & GROUP BY
- INSERT, UPDATE, DELETE
- Simple JOIN
- Practice queries
Phase 6: Projects & Career Modules 22–24
Office Project: Word & Excel Projects & career
Real office documents.
- Resume & letters
- Invoice & quotation
- Marks & attendance sheet
- MIS-style report
- Presentation for a business
Accounts, Web & Database Mini Projects Projects & career
Combine Tally, HTML and database skills.
- Complete company accounts in Tally
- GST invoice & reports
- Small business web page
- Access record system
- Project review
Exam & Interview Preparation Projects & career
Get ready for tests and jobs.
- Theory revision & mock tests
- Practical exam practice
- Interview questions: Office & Tally
- Resume & job-search guidance
- Doubt-clearing sessions
Who is this course for?
Beginners welcome.
| If you are | You will |
|---|---|
| Students & freshers | A deep, job-oriented computer diploma after school or college. |
| Commerce students & aspiring accountants | Tally, GST basics and Excel alongside accounting fundamentals. |
| Job seekers | Office, typing and accounting skills for accounts, admin and back-office roles. |
| Small business owners | Keep your own books in Tally, prepare documents and build a simple web page. |
| DCA learners who want more | Add Tally, HTML and database skills to your foundation. |
ADCA vs other computer courses
Pick the right course for your goal.
What is included
Everything in one program.
- 24 modules in 6 phases
- Typing practice with speed tests
- Word, Excel, PowerPoint and Access
- Accounting fundamentals and Tally with GST basics
- HTML and CSS basics with a mini website
- DBMS concepts and SQL basics
- Practical projects
- Mock tests and interview preparation
Frequently Asked Questions
About the ADCA course.
What is the ADCA course?
ADCA (Advanced Diploma in Computer Applications) is a 12-month course at Skill Training Institute, Alpha 1, Greater Noida. It combines computer fundamentals and typing, the MS Office suite, accounting with Tally, web fundamentals with HTML and a database (DBMS) introduction in 24 modules across 6 phases.
What is the difference between DCA and ADCA?
DCA is a 6-month diploma covering computer basics, typing, Office, internet and programming logic. ADCA runs 12 months and goes deeper: it adds accounting with Tally, HTML and web basics, and DBMS, alongside the Office suite.
Do I need prior computer knowledge?
No. The course starts with computer fundamentals, Windows and typing, so beginners can join.
Which Tally topics are covered?
Accounting basics, company creation, ledgers and vouchers, inventory and stock, GST basics, and reports such as day book, trial balance, profit and loss and balance sheet. Ask us which Tally version is used in the current batch.
Will I learn web design or coding?
You learn HTML and basic CSS and build a small web page. It is a web fundamentals module, not a full web development course.
What jobs can I apply for after ADCA?
Entry-level roles such as accounts assistant, Tally operator, data entry operator, office executive and back office executive, and it is a base for further IT or accounting courses.
Is the ADCA diploma valid for government jobs?
Requirements differ by recruitment. Many notifications ask for a specific certificate such as NIELIT CCC, so read the job notification carefully. If a NIELIT certificate is needed, our CCC course prepares you for it.
What is the fee, and can I attend a demo class first?
Fees depend on the mode you choose. WhatsApp or call +91-9773854034 for the current fee and to ask about a demo class.
Ready for a deeper computer career?
504, MSX Tower-2, Alpha-1 Commercial Belt, Greater Noida. See all courses.