Microsoft Access 2007 tutorial: Build-in Functions

Build-in Functions

IX. Build-in Functions

IX.1. Numeric Manipulation Functions

They are functions that use with numeric data. Those functions include SQTR(), COS(), SIN(), TAN(), TI(), EXP().

IX.2. Text Manipulation Functions

Text manipulation functions work with text data type. Those functions are:
- Left(String, Length): The function is used to take out a substring from the String argument. The length of substring is specified by the Length argument that you defined.

Ex: You want to cut out three letters from Employee Name from left to right. To do so, you have to write the following function:

FirstName: Left(EmpName,3)

Microsoft Access 2007 Build-in functions

Microsoft Access 2007 Build-in functions

- Right(String, Length): The function is used to cut out a substring from the String argument. The length of substring is specified by the Length argument you defined.

Ex: You want to take out two letter from Employee Name from right to left. To do so you have to write the function below:

LastName:Right(EmpName,2)

- LCASE(String): The function is used to convert a string to small letters.

- UCASE(String): The function is used to convert a string to capital letter.

- Trim(String) : The function is used to cut out space from both sides of a string.

- LTrim(String): The function is used to take out space from left side of a string.

- RTrim(String): The function is used to take space away from right side of a string.

IX.3. Date/Time manipulation functions

The function is used to get year, month, day etc. These function include:

DatePart('Interval', DateArgument): The function is used to get Date/Time data base on Interval.

- DateArgument: Field name that has a data type as Date/Time.

- Interval: The form of data you have to define as Date/Time. The interval form are described in the table below:

Interval	Description
yyyy	Year Interval
q	Quarter Interval
m	Month Interval
d	Day Interval
ww	Week Interval
w	Weekday Interval
h	Hour Interval
n	Minute Interval
s	Second Interval

Posted comments

TL Norman:

WHAT? No multi-dimensional array explanation/examples!

05-23-2013

Patrick:

Good explanations. Thank you :)

03-22-2013

Dara:

Global and local variables declaration example:
http://www.worldbestlearningcenter.com/tips/Global-variables-in-vba.htm

02-23-2013

ann:

thanks for sharing your knowledge it helps me a lot.

02-11-2013

Tamilan:

Pls post some examples for declaring and calling variables (local and global)

02-09-2013

M.somjate:

Thanks for example color code.

02-08-2013

G G Shah:

Heartly Thanks.God bless you.

01-18-2013

sek sam:

I like this website very much.
It has a lot of helpful helpful materials to learn excel programming.

01-01-2013

limocky:

useful ms access examples...
good web site to to learn access from scratch.

01-01-2013

bakery:

Thank for useful VBA example code...

12-27-2012

prasat:

Thank u for useful website..

11-03-2012

zal:

Thank for really helpful posts

10-28-2012

brasha:

Useful VBA examples for Excel. I really need them.

10-25-2012

.........................................................................................................................	Home \| Forum \| About \| Contact
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.
Copyright @ 2011-2013 worldbestlearningcenter. All Rights Reserved.