New IACA Class Posted: Webinar: Access Series 2018-5 Expressions, Functions, and Calculations: – in Online

This session shows how to create new data based on existing data through the use of expressions. Examples include concatenation, calculation, and the wide variety of functions that Access supports. Students will learn how to use functions to clean data…

This session shows how to create new data based on existing data through the use of expressions. Examples include concatenation, calculation, and the wide variety of functions that Access supports. Students will learn how to use functions to clean data, concatenate fields, extract parts of dates and times, convert textual dates to actual dates, and perform a variety of other common crime analysis functions. Example of the use of expressions are offered for calculated fields in tables, queries, forms, and reports, including using update and append queries to make permanent changes to data. Audience: Users with a good working knowledge of Access. This is the fifth session in a year-long series of webinars designed to help analysts grow their skills in Microsoft Access. Members may pick and choose which topics are most applicable to them or enroll in the entire series. Citrix invites will be sent out roughly 1 week before the webinar. Certificates of attendance are provided to those who participate roughly 1 week after the session is over.

from http://www.iaca.net/training.asp