Topics Search

MS Access Functions

MS Access Functions
Views: 112
Here is a list of the most commonly used functions in Access. This is alphabetical listing of pointers to those articles which explain these functions in more detail.
Sponsored Links:

Similar posts...


Built-In Functions Fundamentals

Built-In Functions Fundamentals Icon
Once again, since Microsoft Access doesn't inherently provide a programming environment, it relies on logical functions to take care of this aspect. The Choose() function is one of those that can test a condition and provide alternatives. The Choose() function works like nested conditions. It tests for a condition and provides different outcomes depending on the result of the test.
Learn: The Switch Function, Arithmetic Functions, String Functions, Date and Time, Series-Based Functions, Domain-Based Functions, Business Functions and Finance Functions.

Use Access 2007 Aggregate Functions

Use Access 2007 Aggregate Functions Icon
The Access 2007 aggregate functions calculate values over a range of data. The totals row is new with Access 2007 and makes it easier to use aggregate functions such as averages, counts, sums and totals. You may still use these functions in queries and Visual Basic Applications as before but the "Totals" row is generally faster. The following tutorial will show how the use the Access 2007 aggregate functions.

Queries-Based Functions

Queries-Based Functions Icon
These functions can also be used in queries and even included in SQL statements. The SQL interpreter of Microsoft Access can recognize these functions as long as you use them appropriately.
Topics: Queries and Built-In Functions, Summary Queries and SQL Aggregate Functions.

Where can I get information on SQL syntax in Access?

Where can I get information on SQL syntax in Access? Icon
I am experienced using SQL in Oracle but have found some difficulty writing reports in Access, not sure if I am making syntax errors or the functions I am using aren't not compliant with Access.

Was wondering if there were some good resources you guys could recommend with Access SQL examples and possibly list of functions that do and do not work. Particularly having trouble withCASE statements, Dense Rank, and some aggregate functions.

Introduction to Built-In Functions

Introduction to Built-In Functions Icon
Before creating a new function that perform a specific task, first find out if that function exists already. The library built in Microsoft Access is very large (one of the largest you will ever see in the industry) and provides functions that cover many subjects, including general topics, algebra, conversion, finance, accounting, date, time, and strings, etc. The available functions are highly reliable so you can safely use them.
Topics: Statistical Functions, Date and Time-Based Functions, The Win32 API.

MS Access Built-in Functions

MS Access Built-in Functions Icon
MS Access comes with lots of built-in functions. You can use the power of these functions while building a query.

How to: Use Aggregate Functions to Work with Values in Access SQL

How to: Use Aggregate Functions to Work with Values in Access SQL Icon
Aggregate functions are used to calculate statistical and summary information from data in tables. Learn how to use aggregate functions in Access SQL.

MS Access 2010 DATE Functions

MS Access 2010 DATE Functions Icon
Access encompass variety of powerful tools, that facilitates user to use dates and date ranges to be specified in a certain criteria. To get by with the complex logic in your database that contains dates, then DATE functions could be very useful for you. This post will elaborate how to use simple DATE functions.

Aggregate Functions in SQL and Microsoft Access

Aggregate Functions in SQL and Microsoft Access Icon
With SQL there are many functions available that allow you to perform or manipulate calculations on your data. These functions can be used as part of the SQL SELECT statement.

Custom Functions for Access and Excel

Custom Functions for Access and Excel Icon
The more I use Excel and Access, the more I expect them to be able to do for me, and it sometimes comes as a surprise that the programs don't know how to do a particular kind of calculation for me. Microsoft provided VBA so that its customers could essentially continue building the programs to suit their own specific needs. The ability to create custom functions (or UDFs - user defined functions) is a perfect illustration of this.