IGCSE/GCSE/O & A Level/IB/University Student Forum
Qualification => Subject Doubts => IGCSE/ GCSE => Miscellaneous => Topic started by: LM on April 01, 2010, 11:16:34 am
-
hey guys!
I did the practical paper for June 2008
and I'm stuck at one of the question about label....
here's the question!
Produce labels from all the data which:
• have a page orientation of portrait
• fit two side by side on the page
• show only the records that where Special is Yes and the Notes field is not blank
• show only the fields Code, Product, Price and Notes each on a separate line
• are sorted into ascending order of Product
• include the heading ICTC Special Products centred at the top of each label
• have your name, Centre number and candidate number on the left at the bottom
of each label.
could you please help me?
thanks :)
-
there's another one :
Produce a new report from all the data which:
• shows a summary of only the Country, Product and Stock fields
• performs a count of the number of Products for each Country
• calculates the sum of the number of items in Stock for each Country
• only reports where Products number more than 3
Import the file J8ICTWEB.RTF and place the text as slides in a new presentation.
(The text within the file should appear on six new slides as headings and bulleted lists.
NB if your presentation software cannot import the .rtf file, then open the file and copy
and paste the text into six new slides in your presentation software.)
-
Please post in the correct board.
Topic moved.
-
are these questions about excel or database??
-
database
-
okay...i'll see what i can do...
-
Oh yes, the labels,
i hated that question.
-
I do not understand what is so difficult about the second one there.
You simple have to do it. It is as summary query.
Do you know how to do those?
-
You should produce a simple query!When you are preparing :) a report there is new button and then chose label wizard !DONE XD
-
just like the one i showed u in te diagram
-
personally...i think office 2003 is much easier use..(because i am used to it) :P
If anyone having a problem with 2007...
here....use this software..classic menu for office 2007
http://download.cnet.com/Classic-Menu-for-Office-2007/3000-18483_4-10637184.html
-
hey guys!
I did the practical paper for June 2008
and I'm stuck at one of the question about label....
here's the question!
Produce labels from all the data which:
• have a page orientation of portrait
• fit two side by side on the page
• show only the records that where Special is Yes and the Notes field is not blank
• show only the fields Code, Product, Price and Notes each on a separate line
• are sorted into ascending order of Product
• include the heading ICTC Special Products centred at the top of each label
• have your name, Centre number and candidate number on the left at the bottom
of each label.
could you please help me?
thanks :)
point 1) check the file attached (ans 1) do it during report also (ans 1 alternate)
point 2) check the file attached (ans 2) do it during report
point 3) check the file attached (ans 3 & 4) mostly it's like this..
Point 4) check the box in SHOW during query check the file attached (ans 5)
point 5) when you create a report from a query.. you will see an option enter a field name and make it acceding check the file attached (ans 6)
point 6) add the headings when you are modifying the report..
-
Thanks guys....
after trying to do it for 2 hrs...I finally get it!
ESpecially you "Nobody"
Thank you for everything!
:)
-
how do you add page number in powerpoint?
-
how do you add page number in powerpoint?
go to view > master slide. Make sure it had page number enabled. Then ..
Add slide or page numbers
In the pane that contains the Outline and Slides tabs, click the first slide thumbnail in your presentation.
On the Insert tab, in the Text group, click Slide Number.
In the Header and Footer dialog box, do one of the following:
To add slide numbers, click the Slide tab, and then select the Slide number check box.
To add notes page numbers or handout page numbers, click the Notes and Handouts tab, and then select the Page number check box.
To add page numbers to all of the slides, notes pages, or handouts in your presentation, click Apply to All.
-
Thanks guys....
after trying to do it for 2 hrs...I finally get it!
ESpecially you "Nobody"
Thank you for everything!
:)
oh! thanks.....and about adding a page no....
MaNi_DaDuDe has already done..it!
by the way..what do you use...Ms office 2003 or MS office 2007???
Tell me so that i can put the screenshots which will help you to understand better...
-
one question for frontpage I don't know how to do it.
I've tried it but it failed.
here's the question:
Open the file SPECIMEN5.JPG in a suitable application. Change its width to 40
pixels and its height to 60 pixels. Ensure that the colour depth is 256 colours (8 bit
colour) and save the file as SPECIMEN5.GIF
-
hey , u can change it from picture properties but persoanlly i do all the front page portion first and then i change it :)u should save it after chnaging the picture property to make sure it is saved !:D
-
Create an anchor at the top of the page called TOP
Create a hyperlink so that the menu item Home links to the anchor TOP
HOW about this question?
-
hey guys!
I did the practical paper for June 2008
and I'm stuck at one of the question about label....
here's the question!
Produce labels from all the data which:
• have a page orientation of portrait
• fit two side by side on the page
• show only the records that where Special is Yes and the Notes field is not blank
• show only the fields Code, Product, Price and Notes each on a separate line
• are sorted into ascending order of Product
• include the heading ICTC Special Products centred at the top of each label
• have your name, Centre number and candidate number on the left at the bottom
of each label.
could you please help me?
thanks :)
first make a query n go to its design view and then type yes under special's criteria n den type <>"blank" for it....den click on create n then labels....den select the 2nd option that says 2x2....n then select code(enter), product(enter),price(enter) and notes(enter) n den nxt n finish....n den go in its design view n select a txt box n drag da labels down n insert da heading in it! hpe u get it!
-
Produce a new report from all the data which:
• shows only the records which contain the word decaffeinated in the Notes field
• has a page orientation of portrait
• shows only the fields Code, Product, Price and Stock
• is sorted into descending order of Code
-
type * befor n after decaffeinated..
like *decaffeinated*..
u might no how to set orientation to portrait..n rest of the stuff..
-
Produce a new report from all the data which:
• shows only the records which contain the word decaffeinated in the Notes field
• has a page orientation of portrait
• shows only the fields Code, Product, Price and Stock
• is sorted into descending order of Code
1.Do it while you do the query Check image capture1
2.Do it while you do report Check image capture4 & capture5
3.Do it while you do the query Check image capture2
4.Do it while you do report Check image capture3
-
Thanks again Nobody..
But I stiill don't get it!
I'm using access 2007...
-
Thanks again Nobody..
But I stiill don't get it!
I'm using access 2007...
oh! you use acess 2007!!
I''ll do it again .. ;D ;D ;D No problem...!!!!!! ;) ;)
-
thanks nobody... :)
-
thanks nobody... :)
:D :D :D thanks..? For what.? :D :D
For helping them? :D :D :D ;) ;) ;) ;)
--Happy to Help--
*Vodafone! ;) ;)
-
:D :D :D thanks..? For what.? :D :D
For helping them? :D :D :D ;) ;) ;) ;)
--Happy to Help--
*Vodafone! ;) ;)
haha the classy :D is back again :D :D
-
haha the classy :D is back again :D :D
but :P wins ;D