With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

Appendix D. Data Analyst's Function Reference

The list outlined here is designed to provide a solid reference to the functions that are most relevant to the realm of data analysis. Several of these functions have been covered in detail throughout the chapters in this book.

Tip

You can learn more about the functions that have not been covered here by using the Access help system.

Abs

 Abs is a math function that returns a value that represents the absolute value of the number. That is, the magnitude of the number without the positive or negative sign. For example, Abs(-5) would return 5. Syntax Abs(number) Argument Number (required) This is the numeric expression you are evaluating. In a query environment, you can use the name of a field to specify that you are evaluating all the row values of that field.

Asc

 Asc is a conversion function used to convert a string to its Ascii code. For example, Asc("A") would return 65 because 65 is the Ascii code for the uppercase letter A. If you pass a whole word to the Asc function, it will only return the Ascii code for the first letter of the word. Syntax Asc(String) Argument String (required) This is the string you are evaluating. If the string you are passing to the function contains no characters, the function will fail and produce a runtime error.

Atn

 Atn is a math function that allows you to calculate the arctangent of a number. Syntax Atn(number) Argument Number (required) This is the numeric expression you are evaluating.

Choose

 The Choose function is a program ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required