This article lists the SQL
SELECT syntax, as implemented by various database management systems (DBMSs). The syntax is listed exactly as each vendor has listed it on their website. Click on the applicable link to view more detail about the syntax for a particular vendor.
The DBMSs covered are MySQL, SQL Server, PostgreSQL, and Oracle Database.
This article is Part 3 of the Microsoft Access tutorial.
Here’s what’s included in this article:
- Create a query (so you can “search the database”).
- Create a form for data entry.
- Create a macro (so that a multi-step task can be done automatically – at the click of a button).
To use the Query Designer in SQL Server:
- Open a new query by clicking New Query on the toolbar
- Open the Query Designer by selecting Query > Design Query in Editor... from the top menu
- Add the tables you want to run the query against
- Build the criteria for your query then click OK
The query will appear in the query window. To run the query, click ! Execute or press F5
Below are screenshots for the above steps.
To create a query in Access 2013 or 2016:
- Click the CREATE > Query Design button on the Ribbon.
- Choose the tables to include in the query
- Choose the fields to include, and adjust the criteria
- Click the Run button (or just switch to Datasheet view)
The results of the query will be displayed.
You also have the option of saving your query. To save the query, right-click on the query tab. click Save, and name it at the prompt.