0基础学做账：Part 2 - SQL实际操作

8小时 E-Learning (1年学习权限) & 2小时线上跟老师 Zoom Live Q&A 附送 SQL Accounts 软件学习版本

Created by

10:04:46 Hours

60 Enrolled

(0 Reviews)

Chinese

Last updated

Fri, 04-Jul-2025

Course description

文凭：

SQL Mastery 官方文凭 (需通过官方考试)

课程模块与内容：

1. 设立新账号
• 创建数据库
• 公司档案
• 设置会计期间 (Financial Period)
• 单据编号 (Document Number)
• 会计科目表 (Chart of Account)
• 供应商列表
• 顾客列表
• 期初余额 (Opening Balance)

2. 通过情景例子记录各种买卖与花费

3. 银行对账单（Bank Reconciliation)

4. 期末账项调整

Bonus Topic!

5. 变卖与报废固定资产 (Fixed Assets Disposal / Write-Off)

6. 检查财务报表（Financial Statements)
• 整体检阅（High-Level Review）
• 比率分析（Financial Ratios）

7. 利润分配（Profit Distribution)
• 宣告与支付红利 /股息
• 盈利分配账户 (Appropriation Account)

Course Gallery

SQL Handout Download

Part E [E] - Back Up | 备份
00:01:56

Quick revision - Part A to Part D

Super Admin

View profile

Lih Tyng Tan

15 years of experience in Accounting & TaxationFounder & Managing Director: Tyng & Co, Accounting & Tax firmChartered Accountant, Malaysian Institute of Accountants (MIA)Licensed Tax Agent, Chartered Tax Institute Malaysia (CTIM)ACCA AffiliateBachelor of Accounting, University of Malaya (UM)HRD Corp Accredited TrainerSQL Accounting Certified Trainer

View profile

Past Experience Gallery 11

RM330

RM1200

Lectures

34

Skill level

Beginner

Expiry period

12 Months

Certificate

Yes

Remove from cart Add to cart Buy now

Related courses

Beginner

E-Invoicing Implementation (English & Bahasa)

0

(0 Reviews)

7 hours e-Learning (1 Year Unlimited Access) + 2 hours Live Q&A with Trainer

RM700

~~RM1500~~

05:42:13 Hours

Beginner

HR 2 in 1 for Beginners: Employment Act & Payroll Management (English & Bahasa)

0

(0 Reviews)

7 hours e-Learning (1 Year Unlimited Access) + 2 hours Live Q&A with Trainer

RM700

~~RM1700~~

07:21:14 Hours

Beginner

HR 2 in 1：实战劳工法令 & Payroll速成班 (中文班)

0

(0 Reviews)

7小时 E-Learning (1年Access) + 2小时跟老师 Live Q&A

RM700

~~RM2400~~

07:29:34 Hours

Beginner

E-INVOICING 电子发票基础班 (中文班)

0

(0 Reviews)

RM700

~~RM1500~~

02:14:05 Hours

Beginner

0基础学做账：Part 1 - Full Set Accounts

0

(0 Reviews)

14.5 小时 E-Learning (1年学习权限) & 2小时线上跟老师 Zoom Live Q&A

RM520

~~RM1700~~

14:27:00 Hours

Advanced

CHRP Module (UTM) - Managing Discipline, Misconducts & Domestic Inquiry

0

(0 Reviews)

7 hours e-Learning + 2 to 4 hours live session with trainer

RM825

~~RM1650~~

08:36:47 Hours

Advanced

CHRP Module (UTM) - Writing HR Policies, SOP & Employee Handbook

0

(0 Reviews)

7 hours e-Learning + 2 to 4 hours live session with trainer

RM825

~~RM1650~~

09:27:33 Hours

Advanced

CHRP Module (UTM) - HR as Driver of Corporate Vision & Mission

0

(0 Reviews)

7 hours e-Learning + 2 to 4 hours live session with trainer

RM825

~~RM1650~~

07:34:42 Hours

Advanced

CHRP Module (UTM) - Recruitment & Selection Mastery

0

(0 Reviews)

7 hours E-Learning Video + 2 to 4 hours Live Session with Trainer

RM825

~~RM1650~~

07:29:18 Hours

Advanced

CHRP Module (UTM) - Termination, Dismissal & Retrenchment

0

(0 Reviews)

7 hours e-Learning + 2 to 4 hours live session with trainer

RM825

~~RM1650~~

08:17:15 Hours

Advanced

FREE PREVIEW: HR COMPLIANCE PRACTICAL GUIDE & BEST PRACTICES - CHRP Module (UTM) - Managing Discipline, Misconducts & Domestic Inquiry - Sexual Harassment

0

(0 Reviews)

FREE PREVIEW

RM0

00:13:48 Hours

Beginner

免费试课：0基础学做账 Full Set Accounts —— 收入认列原则 Revenue Recognition Principle

0

(0 Reviews)

免费试课

RM0

00:11:13 Hours