Using Microsoft Access
Microsoft Access is usually used interactively to create and manage databases and to interact and manipulate data, and Access features a Query Designer which can be used to build a SQL statement interactively. A frequently overlooked feature of this Query Designer is that it also lets you specify SQL for direct execution. This enables you to use Access to send SQL statements to any ODBC Data Source, although it is best suited for executing SQL against an open database. To use this feature, do the following:
1. | Launch Microsoft Access. You will be prompted to open (or create) a database. Open the database that you want to use. |
2. | Select Queries in the Database window. Then click on the New button and select Design View. ... |
Get Sams Teach Yourself SQL in 10 Minutes, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
