Here is a SUMMARY of all the topics found on this site especially this topic:
https://studentforums.biz/index.php/topic,670.120.html-Paper 2 (May/June 2009) Tricks:
=========================
-
MS Access:
*Reports summary you have to make a query from the table you made previously or so:
Firstly go to queries then create query by using design wizard after that select the desired field just as asked from the paper then click next, in the next step you will be asked whether you would like to create a detail or summary query, select summary, click summary options, tick the sum option for the particular field just as asked in the question paper that you will probably see on the left side of the box and for counting the number of fields tick the count option that you will see on the bottom of the left side, after everything has been done correctly click next and finish it n save the query.
In the next step you will be asked to export the data.
-For Word save it As .RTF
-For Graph/Chart package save it as .CSV
When you are making the report they will ask you to extract some dates from all of them.
In the criteria cell enter:
Between #1/1/2009# and #31/1/2009#
"there are total 3 spaces in the formula and write the dates in the correct format."
-------------------------------------------------------------------------------------
-
Word:
No header and footer on first page:
1) Go to file
2) Click on page setup
3) On the tabs click on layout
4) Under Headers and footers click on different first page
5) Set "from edge" margins to 0 cm
Your headers and footers will disappear on the first page.
===============================================
*Paper 3 (May/June 2009) Tricks:
===============================================
-
Powerpoint:
1)How can we ident a bullet list in powerpoint (by 2 cm for example)
2)How can we make each page in ms word have a different layout??
1) To indent, you must highlight the bullet points you want to indent and go to format then go to placeholder. Press the text box and write 2 cm internal margin from the left.
2) And to make the first page different from the rest, press File>Page Setup>Layout and mark the box saying "Different first page".
-When making the pie chart:
You have to include the Percentage and Category Name
They will also ask you to slightly pull out the part with the most percentage from the rest of the pie chart:
1) Just press on the pie chart itself once
2) Then press on the largest part
3) Then Drag It
-------------------------------------------------------------------------------------
-
Frontpage:
You will have to modify, they will give u the color (RGB) so u will go to format>style>modify>font>color>more colors>custom>enter the number they tell u for each colour (i think the color will turn purple)
-------------------------------------------------------------------------------------
-
Excel:
The formulas used are:
Sum If
Count If
Value Lookup
Calculate the Minutes & Hours by /60 and *60
===============================================
-
More Help:
===============================================
-
You have to import an image of an island or a hotel into the document. (Search from google.)-
Have a look at these steps from the mark schemes. Make sure you know how to do these:O/N 2007 Paper 2 - Step 31 & 32
M/J 2008 Paper 3 - Step 9
O/N 2008 Paper 3 - Step 29 Part 3 & 4, Step 46 & 48
-
This .zip file will help you alot!!![/u]
https://studentforums.biz/index.php?action=dlattach;topic=670.0;attach=421It was attached by "Shoaib" (No viruses, its scanned...)
==========================
Thanks To:
evilzurg307
ashgerrard
Shoaib
Monica
TheIncredibleStudent
Tammy
==========================
Enjoy!
TNas11
