Location visible to members
For our next meetup we will be using a real world example brought to us by member William.
William has a spreadsheet that tracks the intake of patients into Psychiatric Emergency Services. He's running a daily tally of patients admitted, their names and the program they are in.
We took the data out of excel, put it into Access and then used Microsoft Query to generate the totals by Team for several years. This data is pulled dynamically into excel and then used for a pivot chart.
We'll use VBA in Excel to make the chart update dynamic (button push) and we'll explain how to transfer data from excel into an access table and set up a simple form to enter the data.
See you there!
Don't forget to visit our website at http://www.free-excel-access-data-clinic.com/free-excelaccess-lessons/