| You are here: | About>Computing & Technology>Databases> Microsoft Access> Access Function Library |
![]() | Databases |
Microsoft Access Function LibraryDetailed 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. |
Las Vegas on a BudgetFind a BargainHotel DealsCheap EatsFree AttractionsEntertainment for Less |
All Topics | Email Article | Print this Page | | ![]() |
| Advertising Info | News & Events | Work at About | SiteMap | Reprints | Help | Our 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. |


