Access Functions (by category) - Access.
The Microsoft Access database engine selects the records that meet the conditions listed in the WHERE clause. If you do not specify a WHERE clause, your query returns all rows from the table. If you specify more than one table in your query and you have not included a WHERE clause or a JOIN clause, your query generates a Cartesian product of the tables.
The DateSerial() function evaluates the expressions in the input parameters before it returns the resultant date value. This example query returns the last day in the month of February for the year 2003. The last input parameter for the day with the value of 1 is decremented by 1. The result is that the month parameter is evaluated to 2.
Writing Your Own Functions In VBA. This page describes how to write your own worksheet functions in VBA. While Excel provides a plethora of built-in functions, especially so if you include functions in the Analysis Took Pack (in Excel 2007, the functions that used to be in the ATP are now native Excel functions) you may find it useful to create your own custom function for things that Excel.
I know it is possible to create a Stored Procedure directly in access but it isn't pretty to do. Your best options from here would be to: Simulate a Stored Procedured using a function. I found a tutorial here.But I haven't tried this approach. Another Popular approach seems to be to import an SQLServer Stored Procedure and Import it in Acess. Try this link if you like this approach.
Using string functions in your Access SQL queries: When writing our SQL queries in Access there may be times when we want to manipulate the data that is contained in the columns rather than just returning the whole column value. In this article we outline some useful functions that can be used in our SQL queries to manipulate string values and give some real world examples of them in use.
Access can create and save Import Specification Files for importing external text files into tables. These can work well with comma separated lists or regular fixed width lists of data. A string of text (the source file) can be chopped up (i.e. parsed) in order to populate a number of different fields within a record (in the destination table).
How to trap and log the errors reported while a Microsoft Access database is in use. (Access 95 and onwards.).