- 1). Open Access 2010 and select a database. Click the "File" tab and select a database from the recently used databases in the File menu.
- 2). Click the "Create" tab and select the "Macro" button. From the drop-down list, select "OpenForm." Select a form to use in the "Form Name" drop-down box.
- 3). Change the "Data Mode" drop-down list to "Add." Save the form by clicking the "Save" icon on the Quick Access Toolbar.
- 4). Run the macro by clicking the "Run" icon on the ribbon. Notice you are prompted with a new form that is ready for data entry. This data will populate the table because the form is based on the table.
Source...