- 1). Open Microsoft Access.
- 2). Select a database. Open the "Northwind 2007" database for demo purposes.
- 3). Open Query Design. Click "Create," click "Query Design" in the Other group.
- 4). Select the tables or queries that will be included in your new query design. From the "Show Table" panel, highlight the table and click "Add." Once you have selected the tables to use for your query, click "Close."
- 5). Open Query Builder. Click "View" from the Results group.
- 6). Create a simple SQL query. A simple SQL query would be displayed as:
SELECT Customers. Company, Customers.[Last Name], Customers.[First Name]
FROM Customers; - 7). Run the SQL query. Click "Run" from the Results group.
SHARE