In this article we dig deep into Domain Aggregate Functions of MS Access and check how they can be used in real life scenarios.
Functions which are exclusive to MS Access are called Domain Aggregate Functions, these are exclusive because they help in retrieving data from Access tables. One of the greatest advantage of using these functions is the ease and versatility they come with. Almost any practical criteria for retrieving data from tables can be applied to these functions, and they will continue to deliver efficiently. The syntax used by these functions is similar across application. ‘Expressions’ refers to a field present in a query or table, ‘Domain’ is the name of the query or table itself, and ‘Criteria’ is the comparison which indicates which record should be chosen to retrieve values from. Domain and Expressions both are usually surrounded by quotes, a few commonly used domain aggregate functions are listed below.
- The DLookup Function – This is the function that is brought to use when you wish to use only a single query or table for the purpose of retrieving a value. This function will make use of the criteria mentioned by you, and use it to fetch the value that is derived from the first record identifying with the criteria. If you are comparing data that is stored in numeric form, you do not need to make use of quotes.
- The DCount Function – If you want to keep a count of all the records present in a query or table that are matching the criteria you entered, this is the function you should be making use of.
- The DMax/ DMin Functions – These are the functions which should be used for returning the contrasting, highest and the lowest values present in the domain. The results of this function are also based on the criteria that has been entered by the user.
Although these functions are of great use and can make working across MS Access seem like a breeze, there are certain tips you should always keep in mind while using these functions. This will not only allow you to make better use of the, but will also help you understand them better.
- The Dmax function that is used for delivering the highest/maximum value is typically utilized to generate a sequential system of numbers that can be dependent on some other given value.
- While building or adding criteria to get the desired values, make sure you are adding the correct information. If the information added is incorrect, the results delivered will also be incorrect.
These are certainly the functions which are of great use to Access users, but this is not the only advantage Access users are limited to. There is a lot more in this application that you can make use of, and make operations faster as well as more secure. A few of those features include Referential integrity, snaking columns, for printing Access reports and more. And now with the coming of support for Access services on SharePoint, you have all the more reason to switch to MS Access for not only managing your company databases, but also for building applications for distribution.
While deploying Access application in your office it is prudent to keep an Access damage repair tool around to deal with possible contingencies.
Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including corrupt sql and excel recovery software products. For more information visit www.datanumen.com