Thursday, 23 July 2026

Tally Practical

 Practical Sum: 1 

1. Received capital(Anu) Amount Rs.100000(50000+50000) 

2. Received capital(Aswini) Amount Rs.50000 

3. 1.1.2018 Deposit bank(CUB) - 5000(cash to bank) 

4. 2.1.2018 Deposit bank(CUB) - 5000(cash to bank) 

5. 1.1.2018 Deposit bank(SBI) - 15000(cash to bank) 

6. 2.1.2018 Deposit bank(SBI) - 7500(cash to bank) 

7. 1-2-2018 Withdraw Amount from CUB(2000)(bank to cash) 

8. 2-2-2018 Withdraw Amount from CUB(1500)(bank to cash) 

9. 1-2-2018 Withdraw Amount from SBI(1500)(bank to cash) 

10. CUB to SBI Rs.100(Fund transfer)(bank to bank) 

11. petty cash(cash in hand) amount Rs. 1000 

12. Cash Deposit into SBI bank Rs. 1,50,000  

13. Cash Withdraw from SBI bank Rs. 25,000   

14. Fund Transfer from SBI to CUB Rs.2000  

15. Jahab Deposit into SBI bank Rs. 55,000 by cash 

16. Jasmine withdraw From SBI bank Rs. 5,000 by cash 

17. Fund Transfer from CUB (Jahab) to SBI (Jasmine) Account Rs.2000

18. Opened a SBI Bank Account with Rs.100000 

19. Received for Room Rent Rs. 9000. 

20. Received for Salary of Rs. 1500 

21. Received for Travelling Expenses Rs. 2000 

22. Received from "Krishna Mohan A/c" of Rs. 12000 

23. Received from "Mehatha G/s" of  Rs. 7500 by Cash  

24. Received from "Siva Mohan Agency" of  Rs. 25000 by cash 

25. Rs.500 Interest Received from SBI Bank  

26. Sold 10 Pcs of Pen drive @ 500/- to Jahab on cash Rs. 5000  

27. Commenced (started or capital or investment) business with cash Rs.10, 000. 

28.Received Capital by cash from Jahab Rs.30000 

Tally Practical (Contra, Payment, Receipt, Journal)

 

Tally Practical (Contra, Payment, Receipt, Journal)

Contra (F4):

 1. Cash Deposit into SBI bank Rs. 15,000 (Cr (or) To: Cash, Dr (or) By: SBI) 

2. Cash Withdraw from SBI bank Rs. 25,000 (Cr (or) To: SBI, Dr (or) By: Cash) 

3. Fund Transfer from SBI to CUB Rs.2000 (Cr (or) To: SBI, Dr (or) By: CUB) 

4. Jahab Deposit into SBI bank Rs. 55,000 by cash 

5. Jasmine withdraw From SBI bank Rs. 5,000 by cash 

6. Fund Transfer from CUB (Jahab) to SBI (Jasmine) Account Rs.2000 

7. Opened a SBI Bank Account with Rs.100000 

Payment (F5): 

1. Paid for Room Rent Rs. 9000 by cash/cheque (Dr (or) By: Room Rent, Cr (Or) To: cash)  

2. Paid for Stationary of Rs. 1500 by cash/cheque 

3. Paid for Travelling Expenses Rs. 2000 by cash/cheque 

4. Paid to "Jahab A/c" of Rs. 12000 by cash/cheque 

5. Paid To "Jasmine A/c (Sundry Creditors)" of Rs. 7500 and Cash Discount Rs. 250 

6. Paid to "Jahab Agency" of Rs. 25000 by SBI Bank 

7. Paid to Tea Expenses Rs.50 

8. Paid to Local Conveyance Rs.250 

9. Paid to Printing & Stationery Rs.450 

10. Paid to Telephone charges Rs.800 

11. Paid salary 10000 and office Rent 5000 by cash  (Dr (or) By: Salary, Office Rent Cr (Or) To: cash)  

12. Paid for building (Fixed Asset) Rs.10000 

13. Paid for Machines (Fixed Asset) by cheque Rs.50000 

14. Paid for Wages Rs.1000 

15. Paid for carriage Inwards Rs.500 

16 Paid to petty cash (Cash in hand) Rs.5000 

17. Paid for Postage & stamps Rs.500 

18. Paid by Petty cash for postage & Stamps Rs.1200 

19. Cash Withdraw from capital account Rs.500 for Personal use (Dr: Drawing, Cr: cash)

Receipt (F6) 

1. Received for Room Rent Rs. 9000. (Cr (or) To: Room Rent, Dr (Or) By: cash)  

2. Received for Salary of Rs. 1500 

3. Received for Travelling Expenses Rs. 2000 

4. Received to "Krishna Mohan A/c" of Rs. 12000 

5. Received To "Mehatha G/s" of  Rs. 7500 by Cash  

6. Received to "Siva Mohan Agency" of  Rs. 25000 by cash 

7. Rs.500 Interest Received from SBI Bank (Cr (or) To: InsReceived, Dr (Or) By: cash) 

8. Sold 10 Pcs of Pen drive @ 500/- to Jahab on cash Rs. 5000 (Cr: Sales  Dr: Cash)  

9. Commenced (started or capital or investment) business with cash Rs.10, 000. 

10.Received Capital by cash from Jahab Rs.30000 

Journal (F7) 

1. Depreciation charge on Furniture Rs.5000 by cash (By: Depreciation, To: Furniture)       

2. Depreciation charge on Machinery Rs.20000 by cash (By: Depreciation, To: Machinery) 

3. Depreciation charge on Furniture & Machinery Rs. 5000 and Rs.20000 respectively 

           (By: Depreciation, To: Machinery, To: Furniture) 

4. Jahab is an employee of ISS, his monthly salary is Rs.30000/-, he took some salary advance from company of 

Rs.10000/- on 08/03/2022. Here will see how to adjust salary advance against his Mar-2022 Salary. 

Note: i) Jahab salary A/c- Direct Expenses (Salary Group) 

         ii) Salary Payable A/c – Current Liabilities 

        iii) Salary Advance to Jahab – Current Assets 

        iv) CUB – Bank Accounts  

Step1: Make Payment (F5) 

           By: Salary Advance to Jahab      10000 (Dr) 

           To:  CUB Bank (Cr) 

Step2: Make Journal (F7) 

           By: Jahab Salary A/c      30000 (Dr) 

           To: Salary Advance to Jahab      10000 (Cr) 

           To:  Salary Payable                      20000 (Cr)

Thursday, 29 January 2026

Linux

 Software(s/w)

-----------

software - set of programs

Program - set of coding  or instruction or commands

Coding - How to execute our application(setp by step)



user real time problem-----------------------Systematic manner

                                        Software


Ex1:

    2+3--------------------------------systematic or device

               calculator


Ex2 : 

   Search---------------------Systematic or device

                 Browser(Opera,Google chrome...)

Ex3:

   chat------------------------Systemtic or device

            Whatsapp,fb


Types of software

-----------------------

1. Application Software(apps)

2. System Software


1. Application Software

-----------------------------

-can visible

-user interaction(directly work with the user)

-request and response

-Windows based(GUI(Graphical User Interface) based)

Ex:

    Word,Excel,Powerpoint,Paint,Photoshop,Player,Games,Calculator,Browser.....


2. System Software

------------------------

-System Programs(inbuild programs)

-cant visible

-backbone of application software


Ex:

   1) OS    2) Translator     3) Device Drivers   4) Firmware


1) OS(Operating System)

    ---------------

-OS is a System Software

-OS is a System Programs

-brain of the computer

-control of system

-like input and output management  (request and response)

-Memory Management

-File Management

-Resource Control management(USB,Keyboard,Mouse,Printer...)


User --------------- System software or Application software

            OS


Ex:   PC   : Windows(XP,7,8,10,11), Unix, Linux, Mac, DOS---DOS Prompt(CUI - Character User Interface)--C,C++,Java,C#

     Mobile : Android, IOS, Blackberry, Bada, Funtouch,Tizen,Colors---Smartphone OS

   Keypad : Symbian


2) Translator  

---------------

-Translator is a System Software

-Translator is a System Programs

-It converts source code to machine code


Source code--------------------------------Machine code

(user understand)   Translator              (binary code,(0,1),low level,object code,Target code)

(English)


Ex: Compiler, Interpreter, Assembler


Compiler

-------------

-Compiler is a translator

-Compiler is a System Software

-Compiler is a System Programs

-Error checking(check all lines)


Source code--------------------------------Machine code

(user understand)  Compiler              (binary code,(0,1),low level,object code,Target code)

(English)


Ex:

    st1;

    st2;   //error

    st3;

    st4;  //error

    st5;

 

       Compiler Result : error at 2 and 4


Interpreter

-------------

-Interpreter is a translator

-Interpreter is a System Software

-Interpreter is a System Programs

-convert line by line


Source code--------------------------------Machine code

(user understand)  Interpreter             (binary code,(0,1),low level,object code,Target code)

(English)


Ex:

    st1;

    st2;   //error

    st3;

    st4;  //error

    st5;

 

       Interpreter Result : error at 2


Assembler

--------------

-Assembler is a translator

-Assembler is a System Software

-Assembler is a System Programs


Assembly code --------------------------------Machine code

(user understand)    Assembler             (binary code,(0,1),low level,object code,Target code)

(English)

(Numonics) or Cryptic

(Microcontoller--Microchip)

Ex:

  ADD,SUB,PRINT

==================================

OS

---

-Operating System

-OS is a System software or system programs

-brain of the computer

-Control of system

  (input and output management)

  (Resource Management)-Keyboard...

  (Memory management)

  (File management)

Ex(PC): Windows,DOS,Unix,Linux,Max

Mobile: Android,IoS,Windows,Bada,Tizen,Blackberry,Colors,Symbian

  


Linux

-------

-Developed by : Linus Torvalds

-Year : 1991 sep(1.0)

-Written in : C and Assembler

-License : GNU & GPL(General Public License)

-Kernal Based OS(Monolithic  Space : Kernal Type) (.ko)


Features of Linux

---------------------

-Linux is a OS(Operating system)

-Linux is a OSS(Open Source Software- Free download, Free Use(free Lic), Source Code Available)

-Linux is a Multiuser(Share multiple User) & Multitask OS

-Linux is a NOS(Network Operating System)   

-Linux Shell based(program) & Desktop Based OS (GUI)

-OS is a System Software

-OS is a System Programs

-brain of the computer

-control of system

-like input and output management  (request and response)

-Memory Management

-File Management

-Resource Control management(USB,Keyboard,Mouse,Printer...)

===================================

Uses of Linux

----------------

-Cloud Computing

-Embedded Devices

-Mainframe Computers

-Mobile Devices

-Personal Computers

-Servers

-Super Computers

-Routers

-Automation Controls

-TV

-Digital Video Recorders

-Video Games Controller

-Smartwatches

-Tablets

-cars

-Refrigerators

-Laptops & Desktop PC

===============================

Apllications of Linux

-------------------------

-Dell inspiration mini

-Google Android

-HP mini

-Motorola motoRokr

-Sony Bravia TV

-Volvo car(Navigation System)

-Yamaha motit Keyboard

==============================

Linux Distribution(Distro) -- Linux Version ***

--------------------------

Desktop (GUI Based)--Window   --Execute Our application software

---------

-Fedora

-Linux Mint

-Debian

-SUSE Linux

-Ubuntu


Shell Based  --Execute our Programming

--------------

-RED Hat Linux

-Gentoo

-Canonical

-Slack ware  Linux

-Caldera Linux

-Mandrake Linux

-CentOS

-Mandriva

-ArchLinux

===================================

Linux Architecture

-----------------------

1. Hardware

2. Kernel

3. Shell

4. Applications


1. Hardware 

   -Physical components of computer

    Ex: Harddisc, RAM,ROM,Motherboard,Terminals


2. Kernel

   -extension : .ko 

   -locate : /lib/modules

   -Its is a OS

   -brain of the computer

   -system software or system programs

   -control of system

      (like input and output management

              Resource management, File,Memory) 

   -schedule management 


3. Shell

-Its is a CLI(Command Line Interface) or CUI(character User Interface)

-It is used to execute programs

-Variables,Arrays and fucntion,strings manipualtion

-Arithmetic and Logical calculations 


Different types of shell

----------------------------

1. Bourne Shell (.sh) - logical and arithmetic calculation

2. C shell (.csh) - Arithmetic and expression

3. TC Shell(.tcsh) - C Shell & Word Processing

4. Korn Shell (ksh) - Arithmetic, Functions, Arrays and strings

5. GNU Bourne (Again Shell)(.bash)- default linux shell


4. Applications

-Window or desktop application

-GUI format

-end user applications

-user interaction(request and response)

Ex:

   Player,Browser, Text Editors, Database

=================================

variable

-----------



Comment line

----------------

1. single line comment  -- one line decription or author name,program title

 #

2. Multiline comment -- paragraph format

'''

'''


#Program 1 : Display your name

echo "welcome to Linux" 


#Program 2 : Add two numbers

a=10

b=20

c=$(($a+$b))

echo "Result is : $c"


#Program 3 : Add two numbers

echo "Enter a :"

read a

echo "Enter b :"

read b

c=$(($a+$b))

echo "Result is : $c"


#Program 3 : Add two numbers

echo -n "Enter a :"

read a

echo -n "Enter b :"

read b

c=$(($a+$b))

echo "Result is : $c"



1. simple interest calc

2. volume of spehere

3. cone

4. cylinder

5. area of circle

6. area of triangle

=====================================================

Control structure

----------------------

-flow the control of execution

-chnage(skip or repeate) the order of execution


Types

-------

1. Conditional statement 

2. unconditional statement

3. looping statement



1. conditional statement

-------------------------------

1. if statement

    a. simple if

    b. simple if else

    c. elif ladder

    d. nested if

2. case..esac statement 


if statement

---------------

-To check the given conditon is true or false


Types

-------

1. simple if

2. simple if else

3. elif ladder

4. nested if


1. simple if

-------------

-To check the given condition is true

-prsent true part only


syntax:

---------

if  [ condition ]

then

   statement

fi


Working

----------

step1 : to check the given condition

step2: if the given condition is true than execute true part statement

           otherwise exit from if statement


#to check +ve

echo  "Enter the value of n :"

read n


if [ $n -gt 0 ]

then

    echo "The given no is +ve"

fi

-------------------------

2. simple if else

-------------

-To check the given condition is true or false

-prsent true part and false part


syntax:

---------

if  [ condition ]

then

   statement

else

   statement

fi


Working

----------

step1 : to check the given condition

step2: if the given condition is true than execute true part statement

           otherwise execute else part statement


#to check +ve or -ve

echo  "Enter the value of n :"

read n


if [ $n -gt 0 ]

then

    echo "The given no is +ve"

else

    echo "The given no is -ve"

fi

-------------------------

echo "enter the value of n"

read n

n1=$(($n%2))


if [ $n1 -eq 0 ]

then

   echo "The given no is even"

else

   echo "The given no is odd"

fi

-------------------------

3. elif ladder

----------------

-check more than one condition


syntax:

-------

if  [condition1]

then

elif [condition2] 

 then

   statement

elif [condition3] 

 then

   statement

else

  statement

fi


Working

----------

step1 : to check the given condition

step2: if the given condition is true than execute true part statement

step3: otherwise to check another elif condition

step4: suppose all condition are flase then execute else part statement


#ex

echo "enter the value of n"

read n


if [ $n -eq 1 ]

then

  echo "Good mor"

elif [ $n -eq 2 ]

then

  echo "Good noon"

elif [ $n -eq 3 ]

then

  echo "Good eve"

elif [ $n -eq 4 ]

then

  echo "Good nt"

else

  echo "Invalid input try again"

fi

-----------------

4. nested if

--------------

-one if contain another if


syntax:

---------

if [condition]

then

   statement

    if[condition]

    then

      statement

else

 statement

---------------

Working

----------

step1 : to check the given condition

step2: if the given condition is true than execute true part statement

step3: otherwise to check another if condition

step4: suppose all condition are flase then execute else part statement


#ex1

echo "enter the value of n"

read n


n1=$(($n%4))

n2=$(($n%400))


if [ $n1 -eq 0 ]

then

   if [ $n2 -eq 0 ]

   then

     echo "leap year"

   else

     echo "not leap"

   fi

else

  echo "not leap year"

fi

-----------------

4. case..esac statement

-------------------------------

-multiway branching statement

-choice based system

-single exp but more than one case value


syntax:

--------

case exp in

  pattern1) statement1;;

  pattern2) statement2;;

  pattern3) statement3;;

   ...

   *) statement;;

esac


working

------

step1 : to check the given condition and pattern

step2: if the given condition is true than execute pattern1 statement

step3: otherwise to check another pattern condition

step4: suppose all pattern are flase then execute else part(*) statement


#ex: case..esac

echo "Enter the value of n :"

read n

case $n in

1) echo "one";;

2) echo "two";;

3) echo "three";;

*) echo "invalid";;

esac

----------------------------------

Looping statement or repeativity or iteration

----------------------

-set of statement is repeated until condition is false


Types

-------

1. for

2. while

3. until   ------not support do while


1. for

------

-set of statement is repeated until condition s false

-entry controlled loop(first check the condition,next execute statement)


syntax1:

---------

 for var in{start..end}

 do

    statement

 done


syntax2:

---------

for((initilization;condition;increment or decrement))

do

  statement

done


working

----------

step1: initilized the given variable

step2: check the given conidition,if the condition is true than execute statement

           (suppose condition is false than exit from looping statement)

step3: next goto increment part


#ex1

for((i=1;i<5;i++))

do

  echo "welcome"

done


#ex2

for i in {1..5}

do

 echo "welcome"

done


2. while

---------

-set of statement is repeated until condition is false

-entry controlled loop(first check the condition,next execute statement)


syntax:

-------

while(condition)

do

  statement

done


working

----------

step1: initilized the given variable

step2: check the given conidition,if the condition is true than execute statement

           (suppose condition is false than exit from looping statement)

step3: next goto increment part


#while

i=1

while(($i < 5))

do

  echo "welcome"

  i=$(($i+1))

done


3. until

---------

-set of statement is repeated until condition is true


syntax:

--------

until(condition)

do

  statement

done


#Ex1

i=1

until(($i>5))

do

  echo "welcome"

  i=$(($i+1))

done

======================

break                                      

-----                                      

-break is a unconditional statement

-Exit from loop                     


syntax:

---------

for((initilization;condition;increment or decrement))

do

     if(condition)

     then

       break

     fi

done


Ex:

---

for i in {1..5}

do

   if [ $i = 3 ]

   then

    break

   fi

 echo "welcome"

done


continue

----------

-continue is a unconditional statement

-ignore(skip) current iteartion


syntax:

---------

for((initilization;condition;increment or decrement))

do

     if(condition)

     then

      continue

     fi

done


Ex:

---

for i in {1..5}

do

   if [ $i = 3 ]

   then

     continue

   fi

 echo "welcome"

done

=====================================================

Assignment Topics 

----------------------

1). Linux features,Uses,Applications & Linux Distrbutions(Distro)

2). Linux Architecture

3). Define Variable and Types of variable(Shell Variable & Environment Variable(System variable)), 

     Rules for naming a variable

4). Conditional statements (or) branching Statement

  1. if statements

     a. simple if

     b. simple if else

     c. elif ladder

     d. Nested if

  2. case..esac statements

  3. Looping statements

    a. for loop

    b. while loop

    c. until loop

  4.difference between break and continue

-----------------------------

5). Explain Vi editor & Vi commands (mode of vi editor) & Different Access mode codes

6). Substitution Command, File Mask & Root in Linux

7). Linux files and directory commands 

8). Explain File listing commands & wc commands 

9). Explain Filter commands

10). Explain tee commands & Redirection commands & Pipes commands

11). Palindrome checking program

12). sum of the individual digits

13). factorial calculation program

----------------------

Tuesday, 27 January 2026

Git Hub

 step1 : install git

step2 : install vscode

step3: login github

step4: open commandprompt  and type git

step5:

    git config --global user.name "jahabm"

    git config --global user.email "likejahab@gmail.com"

       (visual studio)

step 6 : open folder anyplace

step 7: open visual studio code and open the above folder

step 8 : open terminal (in visual studio)

           git clone https://github.com/Jahabm/test.git

step 9 : (open folder)

       PS C:\Users\G-TEC\Desktop\gtec> cd test

       PS C:\Users\G-TEC\Desktop\gtec\test>

step10 : create a new file(test2.txt)

step11 : open terminal (in visual studio)

                git status         (u)

                git add test2.txt 

                git status          (a)

                git commit -m "test2.txt added" 

                git push origin main

step12: git pull

Sunday, 21 September 2025

VB Database Connectivity

 Dim con As ADODB.Connection

Dim rs As ADODB.Recordset


Set con = New ADODB.Connection

con.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& App.Path &amp 

&";\database\tax.mdb;Persist Security Info=False")


con.Execute (;insert into newuser values(&

Thursday, 4 September 2025

Slide - CSS

  <html>

<head>

<style>

/* Slideshow container */

.slideshow-container {

  max-width: 1000px;

  position: relative;

  margin: auto;

 }


/* Caption text */

.text {

  color: #f2f2f2;

  font-size: 15px;

  padding: 8px 12px;

  position: absolute;

  bottom: 8px;

  width: 100%;

  text-align: center;

}


/* Number text (1/3 etc) */

.numbertext {

  color: #f2f2f2;

  font-size: 12px;

  padding: 8px 12px;

  position: absolute;

  top: 0;

}


/* The dots/bullets/indicators */

.dot {

  height: 15px;

  width: 15px;

  margin: 0 2px;

  background-color: #bbb;

  border-radius: 50%;

  display: inline-block;

  transition: background-color 0.6s ease;

}

.active {

  background-color: #717171;

}


/* Fading animation */

.fade {

  -webkit-animation-name: fade;

  -webkit-animation-duration: 1.5s;

  animation-name: fade;

  animation-duration: 1.5s;

}


@-webkit-keyframes fade {

  from {opacity: .4} 

  to {opacity: 1}

}


@keyframes fade {

  from {opacity: .4} 

  to {opacity: 1}

}


/* On smaller screens, decrease text size */

@media only screen and (max-width: 300px) {

  .text {font-size: 11px}

}



</style>

</head>

<body>

<div id="slide1">

<div class="slideshow-container">


<div class="mySlides fade">

  <div class="numbertext">1 / 4</div>

  <img src="1.jpg"height="50%" width="90%">

  <div class="text">Texcity Arts and Science College</div>

</div>


<div class="mySlides fade">

  <div class="numbertext">2 / 4</div>

  <img src="2.jpg"height="50%" style="width:90%">

  <div class="text">Texcity Arts and Science College</div>

</div>


<div class="mySlides fade">

  <div class="numbertext">3 / 4</div>

  <img src="3.jpg" height="50%" style="width:90%">

  <div class="text">Texcity Arts and Science College</div>

</div>


<div class="mySlides fade">

  <div class="numbertext">4 / 4</div>

  <img src="4.jpg" height="50%" style="width:90%">

  <div class="text">Texcity Arts and Science College</div>

</div>

<br>

<div style="text-align:center">

  <span class="dot"></span> 

  <span class="dot"></span> 

  <span class="dot"></span> 

  <span class="dot"></span> 

</div>


</div>

</div>

<script>

var slideIndex = 0;

showSlides();


function showSlides() {

  var i;

  var slides = document.getElementsByClassName("mySlides");

  var dots = document.getElementsByClassName("dot");

  for (i = 0; i < slides.length; i++) {

    slides[i].style.display = "none";  

  }

  slideIndex++;

  if (slideIndex > slides.length) {slideIndex = 1}    

  for (i = 0; i < dots.length; i++) {

    dots[i].className = dots[i].className.replace(" active", "");

  }

  slides[slideIndex-1].style.display = "block";  

  dots[slideIndex-1].className += " active";

  setTimeout(showSlides, 2000); // Change image every 2 seconds

}

</script>

</body>

</html>


Tally Practical

  Practical Sum: 1  1. Received capital(Anu) Amount Rs.100000(50000+50000)  2. Received capital(Aswini) Amount Rs.50000  3. 1.1.2018 Deposit...