School of Secretarial Studies

Certificate of Office Administration Home Semester & Subjects Calendar & Timetable Video Seminars Other Subjects 1. COA101 Business Communication I 2. COA102 Business English 3. COA103 Business Studies 4. COA104 Office Procedures I 5. COA105 Word Processing Techniques 6. COA106 Spreadsheet Processing Techniques 7. COA201 Business Communication II 8. COA202 Book-Keeping & Accounts 9. COA203 Work Ethics 10. COA204 Office Procedures II 11. COA205 Outlook Express and Powerpoint 12. COA206 Access and Desktop Publishing 13. COA301 Personality Development 14. COA302 Practical Training 15. MPW1133 Malaysian Studies 16. MPW1143/MPW1153 Moral/Islamic Studies 17. MPW1113/MPW1123 Bahasa Kebangsaan A/B Programs Offered 1. Certificate of Office Administration 2. Diploma in Executive Secretaryship 3. Diploma in Corporate Administration » All stamfordonline Courses

---

SUBJECT CODE	: COA206
SUBJECT NAME	: ACCESS AND DESKTOP PUBLISHING
SEMESTER	: 2
CREDIT HOURS	: 2
SCHOOL	: School of Secretarial Studies
COURSE	: Certificate in Office Administration

---

Lecture Notes :
Past Exam Paper :
Syllabus :

---

OBJECTIVES

• Access the internet
• Apply the concepts of desktop publishing

LEARNING OUTCOME

Upon completion of this unit, students will be able to:

• Communicate via email
• Publish high quality office documents and newsletters

SYNOPSIS

Unit 1 - ACCESS
Databases

• What is Database
• Access Objects
• Access Queries, Forms, Reports

Unit 2 - Database File

• Database Window
• Getting Objects
• Relational Database

Unit 3 - Database Creation

• Creating a new database
• Access database wizard
• Opening database window

Unit 4 - Table Design

• New tables for a new database
• Table Design view window
• Mask wizard

Unit 5 - Adding and Editing Data

• Datasheet view
• Adding field and record to a table
• Creating a quick form for data entry

Unit 6 - Table Relationship

• Database matchmaker
• Types of relationships of the database and tables
• Test the relationships and deleting relationships

Unit 7 - Customising

• Creating a form
• Form design
• Dressing up the forms with colour and borders

Unit 8 - DESKTOP PUBLISHING
Access desktop publishing package

• Appropriate printer
• Quality of print

Unit 9 - Set up page

• Margin
• Columns

Unit 10 - Import

• Text
• Headings
• Alignment

Unit 11 - Understand and apply terms

• Font
• Serif and sans serif
• Typeface
• Baseline

Unit 12 - Display

• Boxes
• Bolders
• Shading
• Layout

Unit 13 - Amendments

• Changing text
• Typeface
• Body text
• Type sizes

Unit 14 - Save and Print Documents