Going beyond the classical concepts of database management systems, Microsoft Office Access allows you to automate many user actions. You can even create full-fledged applications with it. One of the automation tools in Access is macros.
Necessary
Microsoft Office Access
Instructions
Step 1
Open an existing or create a new database in Microsoft Office Access. To create a database, press Ctrl + N or select "New …" in the "File" menu. In the panel "Create a file" that appears on the side, click on the link "New database …". Select the name and directory for storing the database file in the "New Database File" dialog. Click the "New" button. To load an existing database press Ctrl + O or select "Open …" in the "File" section of the main menu. Go to the required directory, select the base file, click the "Open" button
Step 2
Switch to the macro management section of the database window. To do this, expand the "Objects" tab on the left panel and click on the appropriate item or select the "Macros" item of the "Database Objects" section of the "View" menu
Step 3
Create a macro. Select the "Macro" item in the "Insert" section of the main menu or click the "Create" button in the toolbar of the database window. The Macro Designer window will open
Step 4
Define a list of actions to be performed by the macro. Select the type of actions in the drop-down lists of items in the "Macro" column of the designer window. Set options for these actions in the controls that appear in the Action Arguments panel
Step 5
Save the created macro. Press Ctrl + S or select "Save …" from the menu. Enter a name for the macro in the dialog that appears. Click OK
Step 6
Start developing scripts in Visual Basic if the functionality of the created macro is not sufficient for solving the tasks at hand. Press Alt + F11 or choose Tools, Macro, Visual Basic Editor from the menus. A development environment window will open
Step 7
Create a new module in the current database project loaded in Visual Basic. Select Insert and Module from the menu
Step 8
Implement the required functionality. Add the required code to the window with the text of the created module
Step 9
Save the module. Press Ctrl + S or choose Save from the File menu. Close the Visual Basic Editor. If necessary, call the module functions from the macro.
