Computers & ICT: Post your doubts here!

[Enes]

AAnsarii,Student of the year thank you for your interest in helping me.

 

[AAnsarii]

in both n12out & n12home the fields are all London (ie into & out of are already London)
so have to worry only about date......

matlab u dont hv 2 act 2 smart? i ws doing dat

 

[AAnsarii]

AAnsarii,Student of the year thank you for your interest in helping me.

no no itz r duty...wt if v had sm doubts n nobody solved dem?

 

[Student of the year]

AAnsarii,Student of the year thank you for your interest in helping me.

no no itz r duty...wt if v had sm doubts n nobody solved dem?

exactly...
and knowledge increases with sharing......
and all the best.....
Pray for us too......

 

[Student of the year]

idk bt q15 ws 5n n q16 is problematic...hw 2 mk d graph?

whats the problem, sis?? its quite simple....

i)export the q15 final query to excel
ii)select the data & insert a column chart
iii)then do the required changes & formatting

 

[AAnsarii]

Hey Friends,
Steps:
i)select query wizard, select the query of q14
ii)select only the fields--country,branchname & jobcode
iii)then in summary option, tick the side box saying-count the records
iv) in design view, add the criteia for country as Spain or Germany
v)only show the branchname, & cont of N12EMPLOYEE fields, untick the others
vi)save this & make a report as per the ques demmands.
..
Hope this benefits you`ll.....
Sorry once again...

so no crosstab?

 

[Tkp]

cn any 1 help me in oct nov 08-23.stuck in this prblm

 

[Student of the year]

so no crosstab?

why to unnecessary include crosstab...??

you think a lot..... dont think like a smarty...... think normally
start from basic then advance.....

 

[Tkp]

whats the problem, sis?? its quite simple....

i)export the q15 final query to excel
ii)select the data & insert a column chart
iii)then do the required changes & formatting

hey can u attach ur o/n 12 database.

 

[Tkp]

why to unnecessary include crosstab...??

you think a lot..... dont think like a smarty...... think normally
start from basic then advance.....

i also thought about crosstab

 

[Student of the year]

cn any 1 help me in oct nov 08-23.stuck in this prblm

whats the problem??
it simply says to keep the secondary axis scaled acc to the values it represents...
you cant have the axis ...with a scale of 100s to show a point for 4..

in the graph by default the axis are aptly scaled...
and incase not then select the axis values--right click--fotmat axis--axisa options ---(set the values for mim & max acc)

 

[syed1995]

IN M/J 09 ( s09_qp_2 ) .. While importing data from the J09Out.csv into the table is giving me some conversion errors .. and all the data is not getting copied..

So what should i set my date format to?

EDIT: Ah got a fix for it .. changed the region to UK and viola it worked without any problems!

Thanks

 

[Tkp]

IN M/J 09 ( s09_qp_2 ) .. While importing data from the J09Out.csv into the table is giving me some conversion errors .. and all the data is not getting copied..

So what should i set my date format to?

EDIT: Ah got a fix for it .. changed the region to UK and viola it worked without any problems!

Thanks

text

 

[Student of the year]

hey can u attach ur o/n 12 database.

sure...but i`ve not done the formatting in any ques...like header/footer,etc

 

[Student of the year]

IN M/J 09 ( s09_qp_2 ) .. While importing data from the J09Out.csv into the table is giving me some conversion errors .. and all the data is not getting copied..

So what should i set my date format to?

EDIT: Ah got a fix for it .. changed the region to UK and viola it worked without any problems!

Thanks

while importing always make sure to make dates as text, telephone no as text, and y/n(etc) as yes/no.......
this wont give errors......

 

[syed1995]

while importing always make sure to make dates as text, telephone no as text, and y/n(etc) as yes/no.......
this wont give errors......

text

Ah!

And once the table has been created .. go to design view to do the formatting and setting the field types!

Thanks mate.

Also having trouble with the question 10 .. can ya help? http://papers.xtremepapers.com/CIE/...unication Technology (9713)/9713_s09_qp_2.pdf

 

[Tkp]

Ah!

And once the table has been created .. go to design view to do the formatting and setting the field types!

Thanks mate.

Also having trouble with the question 10 .. can ya help? http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_s09_qp_2.pdf

yup.

 

[Tkp]

Ah!

And once the table has been created .. go to design view to do the formatting and setting the field types!

Thanks mate.

Also having trouble with the question 10 .. can ya help? http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_s09_qp_2.pdf

select query wizard and then select cust ref,Forename, Surname,cost.now enter cust ref>1 as they want the customers who booked more than 1 holiday.and then select total and then select count ref as count and cost as avg.then create a report and in report they also want an average.so click summary options then click avg and details with summary

 

[AAnsarii]

cn any 1 help me in oct nov 08-23.stuck in this prblm

select d data dat is small n cannot b made out on d graph n go 2 layout. in there, farthest left--Format Selection. select in window Secondary axis radio button.
then label all: axes and chart. mk sure graph is selected n go 2 print preview. Page Setup-->Header/Footer, Custom Header. Save. Print

 

[maryam96abdelhady]

From November 2012 Paper 2 Question 3 PLEASE SOMEONE HELP ME
When you import the N1STORES.TXT into access, do we have to change the names of the 2nd, 3rd, 4th and 5th field and if we do what do we change it to,
this is the link of the exam paper
http://aslevelappliedict.wikispaces.com/file/view/9713_w12_qp_2.pdf
and this is the marking scheme
http://papers.xtremepapers.com/CIE/...unication Technology (9713)/9713_w12_ms_2.pdf