SQL Training: Using SQL in Access 2013
Using SQL in Access 2013:
The SQL training “Mastering Introductory SQL Made Easy™ v.1.0” discusses SQL in Access 2013. Access 2013 is a RDBMS that creates self-contained databases and provides visual tools to allow users to make relational databases without the need for SQL. As such, there are few places to use SQL in Access. You can enter SQL into the “SQL View” of a query when creating a query in Access. You can also enter SQL into modules you design or into any “Code Builder” attached to form objects within a database. Note, however, that Access may not interpret these SQL statements in Access 2013, unless you enable ANSI-92 compliance within the current database file.
To do this, create a new database file within which you want to enter SQL statements in Access 2013. Click the “File” tab within the Ribbon and then click the “Options” button at the left side of the backstage view to open the “Access Options” window. Click the “Object Designers” category at the left side of the “Access Options” window to display the category options to the right. Under the “Query design” header, check the checkbox for “This database” under the “SQL Server Compatible Syntax (ANSI 92)” section. Then click the “OK” button within the “Access Options” window. Access will display a message onscreen telling you it will need to close, convert, and re-open the current database to apply this change. Click the “OK” button within the message to continue and convert the database.
You can then enter the SQL commands within this tutorial within the “SQL View” of the query design window as well as within modules or any “Code Builder” areas associated with form objects that you create. You can also use the database to connect to external data within SQL Server to execute SQL statements by using SQL within the Access database.
Here is a video that corresponds to the information shown above: