Designing an employee work activity timesheet and saving information to database on server

[Huzderu]

Hello all,



I would like to implement a way for our employees to record their activity ( date, project worked on, department, activity category, time spent etc.) and save it to a database on our sever. We have been using PowerAutomate on a Sharepoint website for our flow and saving the information to the Sharepoint server. Unfortunately we have been having a lot of issues with it lately and have decided to move on to something else, for example Odoo or Microsoft Access. I was wondering, how would one go on about implementing something like this in Microsoft Access and is it even possible?

Thank you very much for taking your time to read this and I appreciate any reply!

[Welshgasman]

Crossposted http://https://www.access-programmers.co.uk/forums/threads/designing-an-employee-work-activity-timesheet-and-saving-information-to-database-on-server.319668/#post-1786774

[MikeyLovesAccess]

It’s possible. Depends on your coding skills, you could create it in vba. If you’re not comfortable with vba, you can have linked sql table hooked up to your access app. Then, create a continuous form to edit the data.