MS Access Data Bases: Creating and Using Macros. MS Access macros automate routine and repetitive steps in running a database. Macros require no special programming (i.e. Visual Basic) and can take the database user a step beyond the simple built-in macro functions to the button functions. slide 1 of 7.