If you collect data using REDCap instruments, you will need to query it in Access for monitoring, reporting, and export. In Lecture 3, Josh describes how to move data from REDCap to Access. I recommend starting at 34 minutes and watching until the end. Starting at about 43 minutes, Josh demonstrates his RedWrap utility for importing data from REDCap into Access. I use RedWrap and think you should too.
None of this year's assignments involved moving data from REDCap to Access. Next year, we will have an assignment in which students move data from the FLiPCUP REDCap Project into Access. For more on FLiPCUP, see the video demonstration with the Final Project assignment information on the CLE.