# Access Data Hacks

**URL:** https://forum.innovativeusers.org/t/access-data-hacks/186
**Category:** IUG Conference 2018
**Created:** [September 10, 2022, 9:36pm UTC](https://forum.innovativeusers.org/t/access-data-hacks/186 "2022-09-10T21:36:38Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![helpdesk](https://forum.innovativeusers.org/letter_avatar_proxy/v4/letter/h/7c8e57/32.png) [@helpdesk](https://forum.innovativeusers.org/u/helpdesk)
#### Post date: [September 10, 2022, 9:36pm UTC](https://forum.innovativeusers.org/t/access-data-hacks/186/1 "2022-09-10T21:36:38Z")

</div>

What do you do with data? Results from standardized reports or a SQL query, always need reworking. Learn how to transform and re-present data for your staff, colleges, or patrons with MS Access – have it do the math for you! Learn how to hack canned reports, track your acquisitions budget, and more by using formulas, joins, crosstab queries and more to let your data tell the story it needs. Then share it in Excel, reports, or SharePoint. You don’t need to know Access or Sierra: this session will show solutions to common data problems.

M03 4/25/2018 3:00pm-4:00-pm Oceans 3

Presenter: Trevor Smith, Douglas College  
smitht7@douglascollege.ca

[IUG2018-AccessDataHacks.pptx](https://forum.innovativeusers.org/uploads/short-url/wCItgQtMib0bCdPaRUZatu1a7vt.pptx) (4.2 MB)