In this scenario, you can check this Excel workbook for the responses in Microsoft Forms and input the records into your database. Once there is an attendance fill in the form in Microsoftįorms, you will see the records in Excel workbook.Īs you mentioned you will be the one who primary mange the database. In SharePoint or OneDrive for business, you can create an Excel file by using “Form for Excel” which this Excel file will be connected with a form you created in Microsoft Forms.

Thank you for your understanding.īut as your employer mentioned about Microsoft Forms, you may consider it as a workaround for recording attendance information since Microsoft Forms can help you collect attendance information and export it as Excel workbook.

Some users also noticed this limitation in Mac and raise an idea boutĪccess for Mac in Access UserVoice, if it is convenient, you can also vote on this idea for the updates. As Scott mentioned, Access application is only available for Windows platform at this moment.

Microsoft access for mac download trial