Computers & ICT: Post your doubts here!

[fah3355]

how do we change Y and N to yes no format ?

 

[Raiyan3]

i have problem in this question too ....let me knw if you find ne solution to q 16 in m/j 2011

Hey man so far i know you need to go through the webpage and read through the sections given and then write 1 of 2 points on the given topics

 

[Raiyan3]

how do we change Y and N to yes no format ?

I believe u talking about of june 2011 aswell You need to change format of Avail_1 and other Avails into Yes/No format while your in "Import Text Wizard" from the option "Advanced".. it will comes us -1 or 0 which means ur going right.

And then while making the query, Click on the properties of field Avail_1, from General, click on Format and make it Yes/No. On next to General is Lookup click there, make the Display Control to "Text Box". make it same for others
Screenshot of where u find the General and Lookup.

 

[fah3355]

I believe u talking about of june 2011 aswell You need to change format of Avail_1 and other Avails into Yes/No format while your in "Import Text Wizard" from the option "Advanced".. it will comes us -1 or 0 which means ur going right.

And then while making the query, Click on the properties of field Avail_1, from General, click on Format and make it Yes/No. On next to General is Lookup click there, make the Display Control to "Text Box". make it same for others
Screenshot of where u find the General and Lookup.

thnks man! but in which format do you import ?when i choose to import in yes/no in import text wizard there is error...
did u do the activity in book?

 

[fah3355]

Hey man so far i know you need to go through the webpage and read through the sections given and then write 1 of 2 points on the given topics

did u finish yours...if you did can you give it to me by email or nething at all ?

 

[Raiyan3]

thnks man! but in which format do you import ?when i choose to import in yes/no in import text wizard there is error...
did u do the activity in book?

Reallly? :-O cause im not getting any errors
Anyway tell me the steps how u do it then i think i can help you!

 

[black_berry]

any 1 has source file for 2009 mayjune ppr 2 ict ?

 

[fah3355]

Reallly? :-O cause im not getting any errors
Anyway tell me the steps how u do it then i think i can help you!

i use microsoft access 2007 and i convert my csv to workbook and then import it with import excel file option in access and during import.i change it to use yes/no data type

 

[fah3355]

i use microsoft access 2007 and i convert my csv to workbook and then import it with import excel file option in access and during import.i change it to use yes/no data type

it does not show in 0 or -1 format but it just shows Y and N format i thinkt here is the problem.but i dont how to change the Y and N

 

[Raiyan3]

it does not show in 0 or -1 format but it just shows Y and N format i thinkt here is the problem.but i dont how to change the Y and N

Instead of doing all that, you can click import and from the drop down choose "text file" and then try doing it again !!

 

[Raiyan3]

any 1 has source file for 2009 mayjune ppr 2 ict ?

You mean AS Applied ICT?then yeah

 

[black_berry]

You mean AS Applied ICT?then yeah

t

You mean AS Applied ICT?then yeah

thnx

 

[fah3355]

Instead of doing all that, you can click import and from the drop down choose "text file" and then try doing it again !!

ok but
do you import csv by converting csv into workbook or textfile ?

 

[Parapsycho]

csv files are actually text files, so they are imported as a textfile.
You don't need to convert them.

 

[Xenon]

how do we change Y and N to yes no format ?

I believe u talking about of june 2011 aswell You need to change format of Avail_1 and other Avails into Yes/No format while your in "Import Text Wizard" from the option "Advanced".. it will comes us -1 or 0 which means ur going right.

And then while making the query, Click on the properties of field Avail_1, from General, click on Format and make it Yes/No. On next to General is Lookup click there, make the Display Control to "Text Box". make it same for others
Screenshot of where u find the General and Lookup.

well you can make Yes/No appear in the tables through this way.
Do the step shown in the picture when import the files in access:

and then select as shown:

 

[fah3355]

whenever i close my excel all the formulas goes away its not there anymore....wht should i do so that they do not vanish ?

 

[fah3355]

@xenon -did you give your exam .
could you upload your word part from m/j 2011 question 16 ?

 

[Xenon]

whenever i close my excel all the formulas goes away its not there anymore....wht should i do so that they do not vanish ?

upload one of your file(zip the file first and then upload).. make sure there's no virus in it... a virus caused me fare bit of trouble recently

 

[Student12]

Anyone resource files for AS-level May/June 2011 ?

 

[Parapsycho]

The files that are given to you are .csv files, and they save values only (hence the name, comma separated VALUES)
It's always recommended to you save your file as excel workbook (Save as --> excel workbook).