Counting and summing with Access

  • Event: 2015 CAR Conference
  • Speaker: Andrea Fuller of The Wall Street Journal
  • Date/Time: Thursday, Mar. 5 at 2:10pm
  • Location: M105
  • Audio file: No audio file available.

If you know how to write a basic SELECT statement in SQL through Microsoft Access but are looking to make calculations, then this is the session for you. Learn to count how many times certain records appear in a database and sum totals across records. These skills can come in handy whether you're covering campaign finance or boating licenses.

This session will be most useful if: You took 'getting started with Access' or are familiar with 'SELECT' and 'WHERE' statements in SQL.

Speaker Bios

  • Andrea Fuller is a reporter for The Wall Street Journal in New York City who specializes in data analysis. She uses spreadsheets, databases, and computer code to find stories. Ms. Fuller joined the Journal in April 2014. She previously was a data journalist at Gannett Digital, The Center for Public Integrity, and The Chronicle of Higher Education. 

Related Tipsheets

No tipsheets have yet been uploaded for this event.