Maybe build your own from Microsoft Access. Microsoft has a free db template for asset tracking. Patient management is a common topic so might find some examples.

Only need one install of full Access for development. Split db with backend on LAN server. Distribute frontend to each user computer. Install Access Runtime (it's free) on each user machine.