UBS ACCOUNTING

ASSIGNMENT 1

 

Sunny started an electrical company, Sunny Electrical Company on 1^st of January 2008 with capital RM50, 000.00 in the bank.

The following are the transactions for the month of January 2018:

02/01/2018  He purchased 1000 bulbs by cheque RM 2,000.00

03/01/2018  He purchased 2000 lamps by cheque RM 10,000.00

04/01/2018  He purchased 500 speakers by cheque RM 15,000.00

05/01/2018  He sold all 1000 bulbs and received cheque RM 2,500.00

06/01/2018  He sold all 2000 lamps and received cheque RM 13,200.00

07/01/2018  He sold all 500 speakers and received cheque RM 19,500.00

Cheques were issued for the following expenses:  

31/01/2018  Rental              RM2,000.00

31/01/2018  Salary             RM4,000.00  

31/01/2018  Traveling        RM4,00.00 

 

Read More

VB6: KEYPAD - Backspace Function

Read More

Date format: How to store Month format

Dim amaun As Double
Dim Noic

For i = 4 To 16


amaun = 0
amaun = Dat_Excel.Recordset(i)


If amaun > 0 Then
Dat_potongan.Recordset.AddNew
Dat_potongan.Recordset("id_member") = Me.Dat_Excel.Recordset(1)
Dat_potongan.Recordset("noic") = Me.Dat_Excel.Recordset(2)
Dat_potongan.Recordset("ddate") = Txt_Date.Text
Dat_potongan.Recordset("company") = Me.Dat_Excel.Recordset(3)
Dat_potongan.Recordset("deduction") = i - 3
Dat_potongan.Recordset("amount") = Me.Dat_Excel.Recordset(i)
Dat_potongan.Recordset("Bulan") = Format$(Txt_Date, "mm")
Dat_potongan.Recordset("Jenis_sek") = Combo_Sheet.Text
Dat_potongan.Recordset.Update
End If


Next i


M345:
Dat_Excel.Recordset.MoveNext

DoEvents
Loop

M123:
Batal:


End Sub

Read More

Import Data from UBS to SQL Account ?

• Open SQL Account  

• Go to the File --> Import --> UBS Account...

•  Browse the database location from UBS - (C:\UBSACC90\DATA) --> Connect --> Execute

Read More

How to Format a Computer

Need to learn how to format your computer? Formatting a drive prepares the surface of the disk to store new data. Computers are often formatted before they are sold, donated, or returned to employers. Likewise, computers with viruses or errors can be formatted and returned to their "out of the box" settings.

How to Format a Computer with Windows 7

Warning - Formatting hard drive information does not permanently erase the data. Even after a computer has been formatted, deleted files can be easily recovered. To format your hard disk during Windows 7 installation, you'll need to start, or boot, your computer using the Windows 7 installation disc or USB flash drive.

1. Turn on your computer so that Windows starts normally, insert the Windows 7 installation disc or USB flash drive, and then shut down your computer.

 

1. Restart your computer.
2. Press any key when prompted, and then follow the instructions that appear.
3. On the "Install Windows" page, enter your language and other preferences, and then click Next.

1. If the "Install Windows" page doesn't appear, and you're not asked to press any key, you might need to change some system settings. To learn how to do this, see Start your computer from a Windows 7 installation disc or USB flash drive.
2. On the "Please read the license terms" page, if you accept the license terms, click I accept the license terms, and then click Next.

1. On the "Which type of installation do you want?" page, click Custom.
2. On the "Where do you want to install Windows?" page, click Drive options (advanced).
3. Click the partition that you want to format and click Format.
   
   • If you have more than one partition on this hard drive and want to get rid them to make one big drive again, then select a partition and click on the Delete option for each partition. Once you have deleted all of the partitions, select the Unallocated Space partition and click Format.
   • Pick the formatting option that you want.
   • When you've finished formatting, click Next.
4. Follow the instructions to finish installing Windows 7, which include naming your computer and setting up an initial user account.
5. If you do not want to reinstall Windows 7, you can cancel the installation at this point and keep your newly formatted drives.

Read More

Account Basic

Accounting is the systematic and comprehensive recording of financial transactions pertaining to a business. Accounting also refers to the process of summarizing, analysing and reporting these transactions to oversight agencies, regulators and tax collection entities. This video show you how to understand the account.

Read More