How Do You Write SQL Queries In Microsoft Access 2003?
Most people who use Microsoft office Access do not realize you can write most SQL queries in Access in order to query the Access data base. It is not straight forward so unless you know it was possible and knew the steps in how to do so, it is unlikely you would have discovered how by accident. Access is part of Microsoft Office Suite. It is a lightweight database that is design for small business as well as home users. sometimes it is easier to use a SQL query to find the fields i the database you are looking for. Fortunately Microsoft Access has that capability. Open you access database and select Queries in the Object column. Then double click ‘Create Query In design View’. Close the ‘Show Table box that come up on top of the query window. On the Tool bar, a SQL button with a down arrow appears in bold. When you press this button, the SQL query comes up and you are able to write your SQL query. To use the query, save as then select the name to save it. To run the query, simply doubl
