You are here:About>Computing & Technology>Databases> Microsoft Access> Access Function Library
About.comDatabases

Microsoft Access Function Library

Detailed descriptions of functions available within Microsoft Access. Each entry contains the function's purpose, usage, return values, examples and special cases.
Microsoft Access Function Library: ABS()
The ABS() function returns the absolute value of any numeric expression provided to it as an argument.
Microsoft Access Function Library: Array()
The Array() function is used to create an array from a comma-delimited list of elements.
Microsoft Access Function Library: Asc()
The Asc() function is used to obtain the integer value of the first character in a string.
Microsoft Access Function Library: Atn()
The Atn() function is used to obtain the arctangent value of a number.
Microsoft Access Function Library: CallByName()
The CallByName() function is used to manipulate objects by either executing a method or setting the value of a property.
Microsoft Access Function Library: Choose()
The Choose() function is used to select an item from a list of arguments.
Microsoft Access Function Library: Chr()
The Chr() function returns a string containing a character value.
Microsoft Access Function Library: CurDir()
The CurDir() function returns a string containing the current working directory.
Microsoft Access Function Library: CVErr()
The CVErr() function allows the creation of user-defined errors.
Microsoft Access Function Library: Date()
The Date() function provides the current system timestamp.
Microsoft Access Function Library: DateAdd()
The DateAdd() function allows you to increment a date by a chosen interval.
Microsoft Access Function Library: DateDiff()
The DateDiff() function returns the difference between two dates.
Microsoft Access Function Library: DatePart()
The DatePart() function returns the requested piece of a date.
Microsoft Access Function Library: DateValue()
The DateValue() function returns a date variant containing the date corresponding to the input.
Microsoft Access Function Library: Day()
The Day() function returns an integer corresponding to the day of the month (1-31) corresponding to the input date.
Microsoft Access Function Library: DDB()
The DDB() function returns a double value containing the periodic depreciation of an asset using the double-declining balance method (or other method, as specified).
Microsoft Access Function Library: EuroConvert()
The DateValue() function returns a date variant containing the date corresponding to the input.
Microsoft Access Function Library: Exp()
The DateValue() function returns a date variant containing the date corresponding to the input.
Microsoft Access Function Library: FV()
The FV() function returns the future value of an annuity.
 All Topics | Email Article | Print this Page | |
Advertising Info | News & Events | Work at About | SiteMap | Reprints | HelpOur Story | Be a Guide
User Agreement | Ethics Policy | Patent Info. | Privacy Policy©2008 About, Inc., A part of The New York Times Company. All rights reserved.