If you don't have any HealthKit data to work with, or just want to play with some example data we've created a few files that you can use as examples. Download the included files to get a sense of how QS Access data tables are formatted.
Each time you create a table, you can chose to work with either hourly or daily values. QS Access does some processing to HealthKit data so that it can be accessed in convenient “chunks” for analysis. These won't be appropriate for all uses, but many interesting questions can be asked of data that is presented as a time series using hourly and/or daily values.
The following applications were connected to HealthKit. Each bulleted item was set to “write” to HealthKit.
Withings
iSmoothRun
Misfit (intermittent)
MyFitnessPal (only one data entry)
SleepCycle
Strava