« previous next »
Pages: [1] 2   Go Down

Author Topic: ICT practical  (Read 6687 times)

Offline LM

  • SF Immigrant
  • **
  • Posts: 91
  • Reputation: 171
  • Gender: Female
ICT practical
« 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 :)
Logged
Having you in my dreams its like having my worst nightmares.

Offline LM

  • SF Immigrant
  • **
  • Posts: 91
  • Reputation: 171
  • Gender: Female
Re: ICT practical
« Reply #1 on: April 01, 2010, 11:33:23 am »
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.)
Logged
Having you in my dreams its like having my worst nightmares.

Monica

  • Guest
Re: ICT practical
« Reply #2 on: April 01, 2010, 03:13:27 pm »
Please post in the correct board.

Topic moved.
Logged

Offline Nobody

  • Global Moderator
  • SF V.I.P
  • *****
  • Posts: 5351
  • Reputation: 65535
  • Gender: Male
Re: ICT practical
« Reply #3 on: April 03, 2010, 07:55:11 am »
are these questions about excel or database??
Logged
The most beautiful thing is to see a person smiling!
And even more beautiful is, knowing that you are the reason behind it.

Offline LM

  • SF Immigrant
  • **
  • Posts: 91
  • Reputation: 171
  • Gender: Female
Re: ICT practical
« Reply #4 on: April 03, 2010, 06:07:31 pm »
database
Logged
Having you in my dreams its like having my worst nightmares.

Offline Nobody

  • Global Moderator
  • SF V.I.P
  • *****
  • Posts: 5351
  • Reputation: 65535
  • Gender: Male
Re: ICT practical
« Reply #5 on: April 03, 2010, 07:10:55 pm »
okay...i'll see what i can do...
Logged
The most beautiful thing is to see a person smiling!
And even more beautiful is, knowing that you are the reason behind it.

Offline Saladin

  • The Samurai
  • Honorary Member
  • SF V.I.P
  • *****
  • Posts: 6530
  • Reputation: 59719
  • Gender: Male
  • I believe in those who believe in me
    • Student Tech
Re: ICT practical
« Reply #6 on: April 03, 2010, 08:46:58 pm »
Oh yes, the labels,

i hated that question.
Logged

Offline Saladin

  • The Samurai
  • Honorary Member
  • SF V.I.P
  • *****
  • Posts: 6530
  • Reputation: 59719
  • Gender: Male
  • I believe in those who believe in me
    • Student Tech
Re: ICT practical
« Reply #7 on: April 03, 2010, 08:47:57 pm »
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?
Logged

Offline -Cornea

  • Klamata
  • SF Immigrant
  • **
  • Posts: 116
  • Reputation: 49541
Re: ICT practical
« Reply #8 on: April 03, 2010, 09:17:40 pm »
You should produce a simple query!When you are preparing :) a report there is new button and then chose label wizard !DONE XD
Logged
Laughter is the shock absorber that eases the blow of life ! =)

Offline Saladin

  • The Samurai
  • Honorary Member
  • SF V.I.P
  • *****
  • Posts: 6530
  • Reputation: 59719
  • Gender: Male
  • I believe in those who believe in me
    • Student Tech
Re: ICT practical
« Reply #9 on: April 03, 2010, 09:20:10 pm »
just like the one i showed u in te diagram
Logged

Offline Nobody

  • Global Moderator
  • SF V.I.P
  • *****
  • Posts: 5351
  • Reputation: 65535
  • Gender: Male
Re: ICT practical
« Reply #10 on: April 04, 2010, 07:33:45 am »
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
Logged
The most beautiful thing is to see a person smiling!
And even more beautiful is, knowing that you are the reason behind it.

Offline Nobody

  • Global Moderator
  • SF V.I.P
  • *****
  • Posts: 5351
  • Reputation: 65535
  • Gender: Male
Re: ICT practical
« Reply #11 on: April 04, 2010, 08:34:12 am »
Quote from: 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 :)

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..
Logged
The most beautiful thing is to see a person smiling!
And even more beautiful is, knowing that you are the reason behind it.

Offline LM

  • SF Immigrant
  • **
  • Posts: 91
  • Reputation: 171
  • Gender: Female
Re: ICT practical
« Reply #12 on: April 04, 2010, 07:24:33 pm »
Thanks guys....
after trying to do it for 2 hrs...I finally get it!
ESpecially you "Nobody"
Thank you for everything!
:)
Logged
Having you in my dreams its like having my worst nightmares.

Offline LM

  • SF Immigrant
  • **
  • Posts: 91
  • Reputation: 171
  • Gender: Female
Re: ICT practical
« Reply #13 on: April 06, 2010, 03:20:01 am »
how do you add page number in powerpoint?
Logged
Having you in my dreams its like having my worst nightmares.

Offline MaNi_DaDuDe

  • Don't use profanity, it makes you seem uneducated.
  • SF Farseer
  • *******
  • Posts: 3383
  • Reputation: 65510
  • Gender: Male
  • uh, ef you?
    • Team siCk
Re: ICT practical
« Reply #14 on: April 06, 2010, 05:43:52 am »
Quote from: LM on April 06, 2010, 03:20:01 am
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.
Logged
Pages: [1] 2   Go Up
« previous next »