Skip to main content
Business LibreTexts

14.16: Understanding Calculations

  • Page ID
    46666
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    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.

    image>, <<date1>>, <<date2>>, <<firstdayofweek>>, <<firstweekofyear>>)” width=”695″ height=”620″>

    Contributors and Attributions

    CC licensed content, Original
    • Understanding Calculations. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution

    14.16: Understanding Calculations is shared under a CC BY license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?