To create a view in SQL Server:
The view will now be created in the database. You will be able to see it under the Views node in the Object Explorer.
You can now use SELECT statements against the view in future queries.
Below are screenshots of the above steps.
To create a stored procedure in SQL Server:
This will add the stored procedure to the database. You can see it under the Stored Procedures node in the Object Explorer.
Below are screenshots and more detail for the above steps.
To create a table in SQL Server using a query:
CREATE TABLE script (example below)Here’s an example:
To use the Query Designer in SQL Server:
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 form in Access 2013 or 2016:
This creates a form based on the table or query that you selected from the navigation pane. You can modify the form as required.
You can also create a blank form (using the Blank Form button) or you can use the Form Wizard to create a form.
To create a query in Access 2013 or 2016:
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.
To create a relationship in Access 2013 or 2016:
This will create the relationship. You will see the tables in the Relationship tab with lines depicting the relationship between the tables.
To add a macro to a form in Access 2013 or 2016:
To export from Access 2013 or 2016 to Excel:
To create a macro in Microsoft Access 2013 or 2016: