Qualification > Miscellaneous
IT quesrtion
tnas11:
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=421
It was attached by "Shoaib" (No viruses, its scanned...)
==========================
Thanks To:
evilzurg307
ashgerrard
Shoaib
Monica
TheIncredibleStudent
Tammy
==========================
Enjoy!
TNas11
Starangel:
LISEN PEOPLE. HOW TO CHANGE FORMAT OF DATE IN ACCESS FROM MM/DD/YYYY TO DD/MM/YYYY
ashgerrard:
--- Quote from: Starangel on April 07, 2009, 07:13:53 pm ---LISEN PEOPLE. HOW TO CHANGE FORMAT OF DATE IN ACCESS FROM MM/DD/YYYY TO DD/MM/YYYY
--- End quote ---
Once you import the table, the will ask for the type of the date format and change it from MM/DD/YYYY to DD/MM/YYYY
tnas11:
thx for everyone! :)
Update for the file (uploaded by shoaib)!
some people couldnt download it so i uploaded it again
and i also uploaded a file that helps in EXCEL (thanks to adeel) :)
Also download the other file, it includes the files which u will use in the external (paper 2 & 3)!
Here are the links:
http://www.box.net/shared/lpgljp1d1y
http://www.box.net/shared/i3tf91jst0
http://www.box.net/shared/xth6rcdgvm
Enjoy! TNas11
tnas11:
This is a paper 3 edit and an additional thing by evilzurg and ig boy!!
First of all, here are the files that are gonna be used in the external (paper 2 & 3):
http://www.box.net/shared/lpgljp1d1y
This will also help u in excel, http://www.box.net/shared/i3tf91jst0 (thanks to adeel)
This will help in Paper 2, http://www.box.net/shared/xth6rcdgvm (thanks to shoaib)
-----------------------------------------------------------------------------------------------------
Download the first file, unzip it and open J9style1.css
In front page, they will ask you to:
let the Red and blue components in h1 h2 h3 h4 h5 remain the same, but ensure that there are no green components (The 3rd and 4th numbers in the codes become zero)
so:
h1 { color: #00AAAA; font-family: Arial, sans-serif; font-size: 20pt; text-align: center }
it will become
h1 { color: #0000AA; font-family: Arial, sans-serif; font-size: 20pt; text-align: center }
do this for h1 to h5
Now in the paragraph style, ensure that there is no red component and blue and green component is set to 50%
so:
p { color: #00CCFF; font-family: "Times New Roman", serif; font-size: 12pt; text-align: left }
you change it to:
p { color: rgb(0%, 50%, 50%); font-family: "Times New Roman", serif; font-size: 12pt; text-align: left }
-----------------------------------------------------------------------------------------------------
In power point, you have to:
Indent a bullet list by (how much they tell you, for example 2 cm)
To indent, you must highlight the bullet points you want to indent and go to format then go to placeholder. Press the textbox and write 2 cm internal margin from the left.
-----------------------------------------------------------------------------------------------------
In excel, open J9sheet.csv
The formulas used are:
Sum If
Count If
Value Lookup (from J9code.csv)
Calculate the Minutes & Hours by /60 and *60
so..
Webpage:
=VLOOKUP(B2,J9code.csv!$A$2:$B$12,2,0)
Total:
=SUMIF($B$11:$B$84,B2,$C$11:$C$84)
Hours:
=INT(C2/60)
Minutes:
either
=MOD(C2,60)
or
=C2-(D2*60)
-----------------------------------------------------------------------------------------------------
And they are going to ask for a pie chart (dont really know were exactly), but:
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
-----------------------------------------------------------------------------------------------------
Please someone can u give me paper 2... if u have it?? :)
Enjoy! TNas11
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version