Understanding Calculations

Learning Outcomes

  • Discuss the use of calculations in Microsoft Access

Access has a rich set of calculations, functions, and expressions to assist in data analysis.

Expression Builder dialog box. The Expression box is empty. There are boxes to select Expression Elements and Values below.

This library of calculations is easily opened and is fairly intuitive to use. In the example below, if the user is interested in using the DateDiff function, Access lists the necessary arguments for that function in the top window.

Expression Builder dialog box. The Expression box has been filled with the expression "DateDiff(<<interval>>, <<date1>>, <<date2>>, <<firstdayofweek>>, <<firstweekofyear>>)

Practice Question