@Nobody
Well 9713_s08_qp_4 mainly, i will be glad if you could do the other paper 4 as well (oct 08, may 09, oct 09). For oct 08, may 09, oct 09 if you do just the word part of it like just mail merge and you skip the excel and access that also fine because my weakness is mainly mail merge.
Also i have 2 qs
1. in May/june o9 paper 4 qs 6
"Prepare a report for this search.
Include the Region, Boat Model, HireP/W, Company and Guests fields grouped by
Region then Company and sorted into ascending order of Guests then into ascending
order of HireP/W
Ensure that:
• all labels and data are fully visible
• the report has the heading Region and Guests
• your name, Centre number and candidate number are in the footer of the report.
Run the report for the Balearic region for 8 passengers.
Print the report. "
In this what do they mean by labels and data are fully visible ? is it that i have to make labels or is that i fields are referred to as labels and by the way the marking scheme does not mention anything about the labels
2. in nov 08 paper 4 qs 5
"Format the Charge column and the Cost column into Euros (€) with 2 decimal places."
How do i do this because in qs 4
"Enter formulae into cells B3 to B9 that will look up the customer details from the file
CUSTOMERS.CSV using a Customer id entered in cell B2.
Paste link the hire costs from the file CHARGES.CSV into the cells A15 to C24.
Enter formulae in cells E15 to E24 to calculate the cost of the furniture ordered using the
Charge and Order values.
Enter a formula into cell E25 to calculate the subtotal of the costs.
Enter a formula into cell D26 that will look up the Discount code for the customer from the
file CUSTOMERS.CSV
Enter a formula into cell E26 that will calculate the amount that will be discounted from the
Subtotal in cell E25 based on the discount rate
. The discount rate is based upon the
Discount Code in cell D26 where:
• a = no discount
• b = 10% discount
• c = 15% discount
Enter a formula into cell E27 to calculate the Total
after the discount has been taken into
account. "
i have been asked to paste link which i did by copying the cells in the charges.csv file and then by paste special i selected paste link. So when i need to format the charge column should do it in the charges.csv or the file into which i have copied the stuff into. doing it either way doesnot work by the way at least for me i cannot do anyformatting whatsoever on the charge column be it just to change the number of decimal places e.Take Care. my teacher said i will have to format it manually but i am think there might be some other method... if you do know let me know please.
THanks in advance
