Past Meetup

Learn More Excel and Access Techniques

This Meetup is past

7 people went

Location visible to members


Hi Everyone,

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