Are you trying to make a database in Access for end user, mainly for intuitive and user-friendly environment? Well for such task making use of Access macros is the best option. As, Access macros are specifically designed to automate tasks and for adding functionality to your forms, reports, and controls within an Access database.