• We need your support!

    We are currently struggling to cover the operational costs of Xtremepapers, as a result we might have to shut this website down. Please donate if we have helped you and help make a difference in other students' lives!
    Click here to Donate Now (View Announcement)

ICT Practical Past Paper Video Solutions

svenas

svenas

Messages
822
Reaction score
136
Points
53
E.H Jane said:
yeah sure :)
keep checking regularly and subscribe =)
Click to expand...
I want to ask u a question ....in access when dey say produce a report or produce report from all da data....wat is the difference here?
 
E

E.H Jane

Messages
948
Reaction score
7,265
Points
503
svenas said:
I want to ask u a question ....in access when dey say produce a report or produce report from all da data....wat is the difference here?
Click to expand...


When they say 'Produce a new report from all the data', it means you have to create a report using all the information you have relevnt to what they asked for.
For eg: 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
In this case use the information 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

When they say 'Produce a report',it means you have to create a report using ONLY the information required.
The required information will be given.
For eg:
Produce a report which:

• contains a new field called Cost which is calculated at run-time. This field will
calculate the Price multiplied by the Reorder quantity
• has the Cost field set as Currency with 2 decimal places
• shows only the records where the Stock is 50 or less and the product is not a
Special order
• shows only the fields Category, Country, Code, Product, Stock, Price and Cost
and their labels in full
• fits on a single page
• has a page orientation of landscape
• sorts the data into ascending order of Code (with 7 at the top)
• calculates the total cost of the order below the Cost column
• has the total cost formatted to currency with 2 decimal places
• has the label Total Cost of Order for the total
• includes the heading Reorder List at the top of the page
• has your name, Centre number and candidate number on the right in the footer.

In this case the report must have the following in it:

• contains a new field called Cost which is calculated at run-time. This field will
calculate the Price multiplied by the Reorder quantity
• has the Cost field set as Currency with 2 decimal places
• shows only the records where the Stock is 50 or less and the product is not a
Special order
• shows only the fields Category, Country, Code, Product, Stock, Price and Cost
and their labels in full
• fits on a single page
• has a page orientation of landscape
• sorts the data into ascending order of Code (with 7 at the top)
• calculates the total cost of the order below the Cost column
• has the total cost formatted to currency with 2 decimal places
• has the label Total Cost of Order for the total
• includes the heading Reorder List at the top of the page
• has your name, Centre number and candidate number on the right in the footer.



Hope it helps.
 
svenas

svenas

Messages
822
Reaction score
136
Points
53
E.H Jane said:
When they say 'Produce a new report from all the data', it means you have to create a report using all the information you have relevnt to what they asked for.
For eg: 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
In this case use the information 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

When they say 'Produce a report',it means you have to create a report using ONLY the information required.
The required information will be given.
For eg:
Produce a report which:

• contains a new field called Cost which is calculated at run-time. This field will
calculate the Price multiplied by the Reorder quantity
• has the Cost field set as Currency with 2 decimal places
• shows only the records where the Stock is 50 or less and the product is not a
Special order
• shows only the fields Category, Country, Code, Product, Stock, Price and Cost
and their labels in full
• fits on a single page
• has a page orientation of landscape
• sorts the data into ascending order of Code (with 7 at the top)
• calculates the total cost of the order below the Cost column
• has the total cost formatted to currency with 2 decimal places
• has the label Total Cost of Order for the total
• includes the heading Reorder List at the top of the page
• has your name, Centre number and candidate number on the right in the footer.

In this case the report must have the following in it:

• contains a new field called Cost which is calculated at run-time. This field will
calculate the Price multiplied by the Reorder quantity
• has the Cost field set as Currency with 2 decimal places
• shows only the records where the Stock is 50 or less and the product is not a
Special order
• shows only the fields Category, Country, Code, Product, Stock, Price and Cost
and their labels in full
• fits on a single page
• has a page orientation of landscape
• sorts the data into ascending order of Code (with 7 at the top)
• calculates the total cost of the order below the Cost column
• has the total cost formatted to currency with 2 decimal places
• has the label Total Cost of Order for the total
• includes the heading Reorder List at the top of the page
• has your name, Centre number and candidate number on the right in the footer.



Hope it helps.
Click to expand...
yeah thx it rlly helped ....but y when dey say produce report from all data we produce it using querry wizard not report wizard?
 
E

E.H Jane

Messages
948
Reaction score
7,265
Points
503
svenas said:
yea but why we don't produce it from the report wizard??
Click to expand...
With report wizard, you can create reports using one free table or one table or view in a database. You can use this wizard to quickly create and save for future reuse, reports that you can run at any time. Whenever you run the saved report it will display or print the then-current information from a table or view.​

With the Query wizard, you can select a group of records based on some rules you specify, For example, if you have tables that contain large amounts of information in one or more tables, you can use a carefully designed query to collect or display just a few records that satisfy some numeric or logical value.​
 
svenas

svenas

Messages
822
Reaction score
136
Points
53
E.H Jane said:
With report wizard, you can create reports using one free table or one table or view in a database. You can use this wizard to quickly create and save for future reuse, reports that you can run at any time. Whenever you run the saved report it will display or print the then-current information from a table or view.​

With the Query wizard, you can select a group of records based on some rules you specify, For example, if you have tables that contain large amounts of information in one or more tables, you can use a carefully designed query to collect or display just a few records that satisfy some numeric or logical value.​
Click to expand...
ya I got it thx alot!
But I need from u a big help...I want u to upload a new video solving power point part (37-48) in m/j 2012 paper2 ..I'll gv u the link to papers files and ms...
http://www.mediafire.com/?mm7sbuurfkuuu#n1xq7lon7w4c7
plz try to help me out ASAP...as I'm preparing to do ict in cming o/n session so plz help me out and thx!
 
svenas

svenas

Messages
822
Reaction score
136
Points
53
E.H Jane said:
Okay, I will upload 2 videos for 2 variants.:)
Click to expand...
Also if u don't mind solve paper 3 v1 2012 m/j front page...cauz when I attach stylesheet, instead of the image background....only a solid blue background appears...dunno y?
 
E

E.H Jane

Messages
948
Reaction score
7,265
Points
503
svenas said:
Also if u don't mind solve paper 3 v1 2012 m/j front page...cauz when I attach stylesheet, instead of the image background....only a solid blue background appears...dunno y?
Click to expand...
Okay, I will solve it!
Will inbox you once ready :)
 
You must log in or register to reply here.
Top