validation rules abbriviations

[Guest]

hello,
i am doing my ecdl and am finding difficulty wiht knowing what the
abbreviations in the buildt in functions are and what they stand for,(asc,
chr, chr$, format, format$,GUIDformstring, inStr,LCase,LCase$, Left, Left$
ect..) can somwone please clarify for me? this would really help me in my
exam as i am doing ot on my own..i did not find the help section
veryhelpful...tks very very much

 

['69 Camaro]

Hi, Karl.

i am doing my ecdl and am finding difficulty wiht knowing what the
abbreviations in the buildt in functions are

The only abbreviations used in the built-in functions are the names of the
functions themselves. There's no shortcut there. You need to study what
each one does. For example:

ASC( ) = ASCII code associated with a character
CHR( ) = Character associated with an ASCII code
.. . . et cetera.

Whenever you see a function name followed by a dollar sign, it means that
it's the version of the function that returns a string value instead of a
variant. For example, LEFT$( ) will return a string value of the left side
of an input string, while LEFT( ) will return a variant value of the left
side of an input string. When there's a choice of using the string version
or the variant version, remember that the string version of the functions
runs a little faster than the variant version.

i did not find the help section
veryhelpful.

That's a common complaint. Open Access and press the <ALT><F11> keys to
open the VB Editor. Type the built-in function name in the VB Editor's Help
window, and you'll get a much better list of possible matches to choose from
in the search results than you would from the Access window's Help.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.