write the names of any 4 built -in functions used in access
Answers
Answered by
2

MS Access - Built-In Functions
Previous Page
Next Page
In this chapter, we will be working with Built-in Functions. In Access, there are close to a hundred built-in functions and it is almost impossible to cover every single one of them. In this chapter, we will cover the basic structure, syntax, and use some of the more popular functions, and also the pitfalls, so that you can go exploring some of the other functions on your own.
Functions
A function is a VBA procedure that performs a task, or calculation, and returns a result. Functions can generally be used in queries, but there are other places that you can use functions.
You can use functions in table properties, for example, if you want to specify a default value for a date/time field, you can use the date or the Now function to call up the current date/time information from your system, and input that value automatically.
You can also use functions in an expression when you create a calculated field, or use the functions inside form or report controls. You can use functions even in macro arguments.
Functions can be quite simple, requiring no other information to be called, or, simply reference one field from a table or query.
On the other hand, they can also get quite complicated, with multiple arguments, field references, and even other functions nested inside another function.
Let us now look into some examples of using built-in functions.
Date & Time Functions
Let us now understand the Date and Time functions −
The Date() function is designed to return the current system date. This function does not require any function arguments or additional information. All you have to do is write the name of the function and those open and close parentheses.
There are two very similar built-in functions Time() and Now().
The Time() Function returns the current system time only and the Now() Function returns both the current system date and time.
Depending on the data that you want to track, or store, or query, you have three built-in, easy-to-use functions to help with that task.
Let us now open your database and create a new query using query design and add tblProjects and tblTasks.

Add ProjectName from tblProjects and TaskTitle, StartDate and DueDate from tblTasks and run your query.

You can now see all the different tasks from all projects. If you want to view the project tasks that are in progress as on today’s date, then we have to specify a criterion using a Date() Function to look at projects that start on or after today's date.
Let us now specify the criteria underneath the StartDate.
MS Access - Built-In Functions
Previous Page
Next Page
In this chapter, we will be working with Built-in Functions. In Access, there are close to a hundred built-in functions and it is almost impossible to cover every single one of them. In this chapter, we will cover the basic structure, syntax, and use some of the more popular functions, and also the pitfalls, so that you can go exploring some of the other functions on your own.
Functions
A function is a VBA procedure that performs a task, or calculation, and returns a result. Functions can generally be used in queries, but there are other places that you can use functions.
You can use functions in table properties, for example, if you want to specify a default value for a date/time field, you can use the date or the Now function to call up the current date/time information from your system, and input that value automatically.
You can also use functions in an expression when you create a calculated field, or use the functions inside form or report controls. You can use functions even in macro arguments.
Functions can be quite simple, requiring no other information to be called, or, simply reference one field from a table or query.
On the other hand, they can also get quite complicated, with multiple arguments, field references, and even other functions nested inside another function.
Let us now look into some examples of using built-in functions.
Date & Time Functions
Let us now understand the Date and Time functions −
The Date() function is designed to return the current system date. This function does not require any function arguments or additional information. All you have to do is write the name of the function and those open and close parentheses.
There are two very similar built-in functions Time() and Now().
The Time() Function returns the current system time only and the Now() Function returns both the current system date and time.
Depending on the data that you want to track, or store, or query, you have three built-in, easy-to-use functions to help with that task.
Let us now open your database and create a new query using query design and add tblProjects and tblTasks.

Add ProjectName from tblProjects and TaskTitle, StartDate and DueDate from tblTasks and run your query.

You can now see all the different tasks from all projects. If you want to view the project tasks that are in progress as on today’s date, then we have to specify a criterion using a Date() Function to look at projects that start on or after today's date.
Let us now specify the criteria underneath the StartDate.
Similar questions