Đã Trao

Microsoft Access Job by Accessnewbie

Problem One [25 marks]

The user has a form in MSAccess. The form contains information about the client. The client fields are – client’s first name, client’s last name, their street address, suburb and city, their landline number and their cell phone number and their email address.

However the user does not always want to see the email address and would like to have a button that will show or hide the email address.

Write a set of instructions that will solve this problem.

Problem Two [30 marks +20 marks = 50 marks]

The user has a MSAccess database called Customers. There is a table that contains information about the customer including the fields FirstName, LastName, Street address, Suburb, City and Email Address and their credit limit.

The user has written a letter and would like to personalise the letter and send it by email to each client.

Here is an example of the personalised letter.

Dear John Smith,

It is with great pleasure that we would like to inform you that your new credit limit with our company is now $10,000.

We look forward to doing business with you.

Yours sincerely,

Gerard Lovell

General Manager

Write a set of instructions that will solve this problem.

Note: you are free to choose an email system and whether the letter is send in the email or as an attachment.

Problem Three [25 marks]

The user has so far created five reports in a MSAccess database. He is yet to create 15 more. He has suddenly thought that it would be good if the reports could be printed automatically with the company logo and address in the header of the report. This way he does not have to use the letterhead paper. He thinks a report template may be a good idea to do this with.

You need to come up with one method that will solve this user’s problem.

First find an appropriate image for the logo.

Write a set of instructions that will solve the problem.

Kỹ năng: Microsoft Access

Xem thêm: method write report, logo 000, image paper, general manager, free template create logo, free logo letter, free great company logo, free company logo template, free business logo template, find custom logo, custom free logo, custom company logo, custom business logo, create personalised logo, create letterhead logo free, create free letterhead logo, create custom logo free, company logo paper, be smith, dear john letter example, project manager free, free business letter template, find business manager, customer project manager, custom logo free

Về Bên Thuê:
( 0 nhận xét ) New Zealand

Mã Dự Án: #1690347

1 freelancer đang chào giá trung bình $60 cho công việc này

rhomeu

Hired by the Employer

$60 NZD trong 4 ngày
(60 Đánh Giá)
7.0