代做CSC101 Computer Literacy Assignment 1代做Java语言

Course Code: CSC101 Computer Literacy

Assignment 1     WORD (10%)

Suppose you are the Sales manager of the “Stars Automotive Company”, you have to create a letter to invite all business partners to participate the 50th  anniversary party.

Please upload your answer (word document and data source file) through Moodle. Use your student id number as the filename, such as 2334*****.doc and 2334*****.mdb

(a)  Modify a promotion letter “invite.doc” in a single A4 size page with headers and footers and document setting as below.

Document setting:

i.      Font size in 12 Century, Paper size in A4.

ii.     Top and bottom margins are in 1.8 cm, and left and right margins are in 2.5 cm.

iii.    Set the paper orientation to Landscape.

iv.    Insert your name in the Header with bottom border.

v.     Use Tab (Left Align at 15 cm) to make alignment of recipient's address and complimentary close.

vi.    The “Footnote” indicated by a small number “1” is placed next to the word “Super Hotel” in this letter. The source of this footnote should be provided at the end of this letter in size 10 Century, with this sentence “Address: 1, Tai Po Road, Tai Po, N.T.” .

A figure is provided (next page) as for your reference.

(b)   You are required to use the mailing merge function to generate letters.

i.      Create a data source with the format in Table 1 and save as “company.mdb” .

ii.     Insert four merge fields “Name”, “JobTitle”, “Company”, and “Address” in “invite.doc” .

iii.    If the receiver is a supplier, put letter “A” after the words “reception table”, or put letter “B” .

iv.    Merge all records with the letter in descending order of the company name.

Name	JobTitle	Address	CompanyName	Relation
Robin Chu	Manager	12 Kai Tak Street, Wong Tai Sin, Kln.	Motor Ltd	Supplier
Flora Yu	Engineer	3 Castle Peak Street, Lai Chi Kok, Kln.	RollStone Ltd	Supplier
Adam Law	Technician	35 Kwai Chung Street, Kwai Fong, N.T.	Lee’s Company	Client
Paul Lam	CEO	16 Tai Po Road, Tai Po, N.T.	Lam’s Company	Client

Table 1

The Letter Content with merge fields