Đã 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 to write a report, logo 10 000, image by paper, general manager, free template to create logo, free logo letter, free great company logo, free custom logo free, free company logo template, free business logo template, find a custom logo, example of project, example of letter, custom logo here, custom logo free, custom it company logo, custom free logo, custom company logo, custom business logo, create your logo with your phone, create your custom logo, create your company logo free, create your company logo for free, create your business logo free, create personalised logo

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