How to Write SQL Statements in Microsoft Access

Access is Microsoft's small-scale database software program. While it is not comparable to mySQL or MSSQL in terms of complexity and scaling abilities, it does allow you to run traditional SQL statements inside the software. This feature makes it easier for database administrators or others who may have more experience with a SQL database environment to interface with Access.

Step

Open Access, then open the database that you want to query.

Step

Click on "Objects" and "Queries."

Step

Select "Create Query," then click "SQL View."

Step

Type in the SQL statement you wish to execute, then click "Run" to execute the statement on the database.