Tag: how to

How to Create a New Database Diagram using MySQL Workbench

Posted on by Ian

To create a new database diagram using MySQL Workbench:

  1. Click File > New Model from the menu
  2. Create a new schema by clicking the + icon next to Physical Schemas
  3. Add tables by clicking Add Tables, then add/configure their columns in the bottom pane.
  4. Create relationships and any other configurations by using the various tabs
  5. Create a diagram by clicking Model > Create Diagram from Catalog Objects

The diagram will be created. You can rearrange the tables to a more suitable layout by clicking and dragging.

Continue reading →

How to Check the Server Status in MySQL Workbench using the GUI

Posted on by Ian

To check the status of a MySQL server using the MySQL Workbench GUI:

  1. Click the MySQL connection (as you would normally do when connecting via MySQL Workbench)
  2. 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:

Continue reading →

How to Create a View in SQL Server

Posted on by Ian

To create a view in SQL Server:

  1. Open a new query by clicking the New Query button in the SSMS toolbar
  2. Type or paste a CREATE VIEW statement (example below)
  3. 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.

Continue reading →

How to Create a Stored Procedure in SQL Server

Posted on by Ian

To create a stored procedure in SQL Server:

  1. Click New Query on the SSMS toolbar
  2. Type (or paste) a CREATE PROCEDURE statement (example below)
  3. 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.

Continue reading →

How to Create a Table in SQL Server using a Query

Posted on by Ian

To create a table in SQL Server using a query:

  1. In the SQL Server Management Studio, click the New Query button on the toolbar
  2. Type or paste a CREATE TABLE script (example below)
  3. Click the ! Execute button on the toolbar

Here’s an example:

Screenshot of SSMS with the New Query button highlighted.
Clicking the “New Query” button on the SSMS toolbar opens a new query. Clicking “Execute” runs the query.

Continue reading →

How to Use the Query Designer in SQL Server

Posted on by Ian

To use the Query Designer in SQL Server:

  1. Open a new query by clicking New Query on the toolbar
  2. Open the Query Designer by selecting Query > Design Query in Editor... from the top menu
  3. Add the tables you want to run the query against
  4. 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.

Continue reading →

How to Create a Form in Access

Posted on by Ian

To create a form in Access 2013 or 2016:

  1. On the left navigation pane, click the table or query that contains the data for your form
  2. 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.

Continue reading →