IGCSE/GCSE/O & A Level/IB/University Student Forum

Qualification => Subject Doubts => GCE AS & A2 Level => Miscellaneous => Topic started by: avin on April 24, 2011, 02:21:45 am

Title: Help in Microsoft Access 2007
Post by: avin on April 24, 2011, 02:21:45 am

Can any one explain what is the meaning of the data type of Number in Microsoft Access 2007?

It has long integer, bytes, Replicate ID, decimal, single and double.

What is this used for?


By the way, the price unit like $ i cannot change it to $ but the Access gives me other unit like Yen when i key in the data in spreadsheet view.

How to change it from Yen to $?


Thanks. It's urgent. I really appreciate your help. Thanks again.

Title: Re: Help in Microsoft Access 2007
Post by: EMO123 on April 24, 2011, 06:40:27 am

Quote from: avin on April 24, 2011, 02:21:45 am

Can any one explain what is the meaning of the data type of Number in Microsoft Access 2007?

It has long integer, bytes, Replicate ID, decimal, single and double.

What is this used for?


By the way, the price unit like $ i cannot change it to $ but the Access gives me other unit like Yen when i key in the data in spreadsheet view.

How to change it from Yen to $?


Thanks. It's urgent. I really appreciate your help. Thanks again.

long integer, bytes, Replicate ID, decimal, single and double.
this all are data types

Title: Re: Help in Microsoft Access 2007
Post by: EMO123 on April 24, 2011, 06:41:43 am

http://www.softwaretrainingtutorials.com/access-2007-ms.php

Title: Re: Help in Microsoft Access 2007
Post by: avin on April 24, 2011, 11:52:21 am

Thanks but i cannot access the video.

Can anyone pls help me what is happening in the video regarding my question?

erm how about the $ sign? How to change from yen to $?


Thanks again.

Title: Re: Help in Microsoft Access 2007
Post by: NotAbod on April 24, 2011, 12:30:31 pm

try changing to language settings to Enlgish- united states

Title: Re: Help in Microsoft Access 2007
Post by: avin on April 24, 2011, 04:45:04 pm

my laptop language is already English--US.

Title: Re: Help in Microsoft Access 2007
Post by: NotAbod on April 24, 2011, 05:36:00 pm

not ur laptop language. MS office language.
Follow the steps:
Start-->all programs-->microsoft office--> microsoft office tools-->microsoft office 2007 language tools.
add english to the enabeld edditing languages.
choose english as primary editing language.
tell me if it does'nt work

Title: Re: Help in Microsoft Access 2007
Post by: avin on April 24, 2011, 06:08:04 pm

AboD, still cannot after i changed it.

How?

Title: Re: Help in Microsoft Access 2007
Post by: NotAbod on April 24, 2011, 06:10:15 pm

try MS access 2003

Title: Re: Help in Microsoft Access 2007
Post by: avin on April 24, 2011, 06:13:26 pm

i oly have Access 2007.

Besides, my coursework is using 2007 too.

Title: Re: Help in Microsoft Access 2007
Post by: NotAbod on April 24, 2011, 06:14:51 pm

sorry cant help much, i use 2003

Title: Re: Help in Microsoft Access 2007
Post by: avin on April 24, 2011, 06:18:39 pm

thanks a lots for putting efforts on my problems

Title: Re: Help in Microsoft Access 2007
Post by: EMO123 on April 26, 2011, 02:54:05 pm

i am sry but i also cant help you as i use MS Office 2010

Title: Re: Help in Microsoft Access 2007
Post by: Dasith on April 30, 2011, 10:51:40 am

usually in  MS office (wat ever da version or year is)
the currency is taken from regional settings in computer
its in Control panel

Control panel >> Regional settings and language options...(or something similar to this)
Change da Yen to $

Hope this helps :D

Title: Re: Help in Microsoft Access 2007
Post by: avin on April 30, 2011, 11:23:25 am

You mean the language?
Change the language?

Title: Re: Help in Microsoft Access 2007
Post by: Dasith on April 30, 2011, 12:39:49 pm

yea, set it to US or brithsh or watever

Title: Re: Help in Microsoft Access 2007
Post by: Dasith on April 30, 2011, 12:41:40 pm

wait you dont hav to change language, go to you could click customise button then >> currency >> then you are able to change only da currency