You can use MySQL Workbench to view current connections in MySQL either by query or by GUI.
- By Query: Run SHOW PROCESSLIST; in a query tab.
- By GUI: Click on Client Connections in the Management tab of the left navigation pane.
To check the status of a MySQL server using the MySQL Workbench GUI:
- Click the MySQL connection (as you would normally do when connecting via MySQL Workbench)
- Click Server Status from the Management tab in the left navigation pane
The Server Status window will appear, displaying the server’s status and related information:
To create a table in SQL Server using a query:
- In the SQL Server Management Studio, click the New Query button on the toolbar
- Type or paste a
CREATE TABLE script (example below)
- Click the ! Execute button on the toolbar
Here’s an example:
Clicking the “New Query” button on the SSMS toolbar opens a new query. Clicking “Execute” runs the query.
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 view in SQL Server:
- Open a new query by clicking the New Query button in the SSMS toolbar
- Type or paste a CREATE VIEW statement (example below)
- Run the script
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:
- Click New Query on the SSMS toolbar
- Type (or paste) a CREATE PROCEDURE statement (example below)
- Click the Execute button on the toolbar
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 form in Access 2013 or 2016:
- On the left navigation pane, click the table or query that contains the data for your form
- From the Create tab on the Ribbon, click Form
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:
- 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.
To create a relationship in Access 2013 or 2016:
- While viewing a table in Design view, and ensuring that the DESIGN tab is selected, click Relationships from the Ribbon
- A Show Table dialog will appear with a list of tables and queries. Select the tables (and/or queries) that you wish to create a relationship between, and close the dialog
- The Relationships tab will appear with the selected tables. Click and drag a field on top of a field in another table to initiate a relationship.
- The Edit Relationships dialog will pop up containing both fields. Make any adjustments and click OK
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:
- Create a macro
- Now, open the form in Design view
- Click the Button icon in the Ribbon (from the DESIGN tab)
- In the Form Detail area, click and drag the cursor so that it forms a square or rectangle (i.e. shape of a button). The Command Button Wizard will pop up. Select Miscellaneous > Run Macro and click Next
- Select the name of the macro you want to run and click Next
- Choose whether to display text or an image on the button and click Next
- Give the button a name and click Finish