- 1). Open Access 2007. Click the "Office" button and click "Open." Click on your database and select "Open." The database opens.
- 2). Click the "Create" tab and select "Macro" twice. In the "Action" drop-down list select "OpenQuery." Select the query in the Function Argument's "Query Name" field. Save the query by clicking the "Save" icon on the Quick Access Toolbar.
- 3). Click the "Database Tools" tab and select the "Switchboard Manager." Access will prompt you to create a new switchboard. Click "Yes." Select "Edit" when the Switchboard Manager dialog box opens.
- 4). Select "New." Type a name for the query that you are opening. The name will indicate the action that will be performed when this button is pressed. In the Command drop-down list, select "Run Macro." In the Action drop-down list, select the macro that opens your query. Click "OK." Click "Close" two times.
SHARE
