## 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