School of Secretarial Studies

Diploma in Corporate Administration Home Semester & Subjects Calendar & Timetable Video Seminars Other Subjects 1. MPW1113/MPW1123 Bahasa Kebangsaan A/B 2. DCA101 Business English 3. DCA102 Business Statistics 4. DCA103 Business Accounting 5. DCA104 Management Theories 6. DCA105 Desktop Publshing and Database 7. DCA106 Financial Accounting 8. DCA107 Human Resources Management 9. DCA108 Micoeconomics 10. MPW1133 Malaysian Studies 11. DCA109 Business Communication 12. DCA110 Business Organisation & Management 13. DCA111 Macroeconomics 14. MPW1143/MPW1153 Moral/Islamic Studies 15. DCA112 Quantitative Methods 16. DCA201 Cost Accounting 17. DCA202 Information Technology 18. DCA203 Law of Meetings 19. DCA204 Public Relations 20. DCA205 Business Ethics 21. DCA206 Business Law 22. DCA207 Corporate Administration I 23. DCA208 Financal Management 24. DCA209 Management Information System 25. DCA210 Taxation 26. DCA211 Corporate Administration II 27. DCA212 Corporate Compliance & Practice 28. DCA213 Marketing 29. DCA214 Personality Development Programs Offered 1. Certificate of Office Administration 2. Diploma in Executive Secretaryship 3. Diploma in Corporate Administration » All stamfordonline Courses

---

SUBJECT CODE	: DCA105
SUBJECT NAME	: DESKTOP PUBLSHING AND DATABASE
SEMESTER	: 2
CREDIT HOURS	: 2
SCHOOL	: School of Secretarial Studies
COURSE	: Diploma / Diploma in Corporate Administration

---

Lecture Notes :	DCA 105 Lesson 1.pdf DCA 105 Lesson 2.pdf DCA 105 Lesson 3.pdf DCA 105 Lesson 4.pdf DCA 105 Lesson 5.pdf DCA 105 Lesson 6.pdf DCA 105 Lesson 7.pdf DCA 105 Lesson 8.pdf DCA 105 Lesson 9.pdf DCA 105 Lesson 10.pdf DCA 105 Lesson 11.pdf DCA 105 Lesson 12.pdf DCA 105 Lesson 13.pdf
Past Exam Paper :	DCA 105 DTP and Databases Oct 06.pdf
Syllabus :	DCA105.pdf

---

OBJECTIVES
This module provides hands-on spreadsheet application. It teaches the concepts and the practical knowledge thereof in order to produce students who are well-versed in elementary to intermediate level spreadsheet skills; This module provides hands-on database application. It teaches database concepts via a popular database package, in order to produce students who are well-versed with elementary to intermediate competency of Microsoft Access skills. The areas covered will be basic database concepts and processing skills, query and form production.

LEARNING OUTCOME
On completion of this subject, the learners should be able to:

list the various components of a database, in the context of a business system, design and populate the components of a database based on the user requirements of a business system, design and use queries in order to produce a selection of data across one or more tables, design and create forms in order to allow user-friendly entry of data, design and create reports in order to generate hardcopy listings and summary information for senior management consumption, explain the purpose of desktop publishing (DTP) in the context of marketing and advertising, list the main DTP applications available today, list and explain the three areas of DTP: image editing, illustration and page layout, apply desktop publishing techniques in the process of planning, designing, creation, and printing of publications, demonstrate how each of the following design principles apply to a publication: organization, simplicity, tone, visual variety, reader assistance, consistency and accuracy, use style sheets to promote appearance by defining text attributes in a publication, select appropriate typeface for greatest effect and apply formatting control through the manual use of automatic leading, kerning and hyphenation capabilities, select and produce effective graphics in a publication.

SYNOPSIS

Description and functions of databases; creation of databases using Microsoft Access. The concept of desktop publishing using computer and information technology; different types of electronic publications according to use and function; fonts and typefaces; formatting the page using text, headings and alignments, setting up pages using margins and columns; use of boxes and tables; enhancement of documents using colour; using the Internet as a resource for desktop publishing.