How to Create a SQL Query in Access 2003

To create a SQL (Structured Query Language) query in Access 2003, you'll need enough information to create a SQL statement. Fortunately, the program will create the statement for you, so it's not necessary to write it.

Things You'll Need

• Computer
• Access 2003

Instructions

Creating a SQL Query

1. Open up a blank database in Access, by choosing "File" from the menu, and then "New."

2. Click on "Queries" in the database window.

3. Click "Create New Database in Design View."

4. Click "Close" when a "Show Table" box appears.

5. Go up to the toolbar, and select "Query."

6. Scroll down to "SQL Specific," and choose "Union."

7. Enter the SQL statements in the box.

8. Click "View," the very first icon on the toolbar (it resembles a graph), to see the results of the query.

Tips & Warnings

• You can also do a pass-through query, a data-definition query or create a subquery from the menu in Step 6.

• There is a "SQL Query Wizard" option available. If it does not work, you may not have the proper software installed to run the Wizard.