Database Development

Select one of these radio buttons to work with a table of the Northwind database.

(Default is the Customers table)

You must click the load button to display the table in the window above

before you can perform a search on the database table.

Click this window to close it.

This field is where you select the column of the table that you want to work with.

If you do not select a column below to sort by, the results will be sorted by this column.

You must select one of these radio buttons for the database query to work.

Click this window to close it.

You can enter search text in the input field in which to limit your query as: like 'mexico'

Wildcards like: '%a' find any record that ends with 'a'.

Wildcards like: 'a%' find any record that starts with 'a'.

Wildcards like: '%a%' find any record with 'a' in any position.

Wildcards like: '_a' find a two-letter word with 'a' in the second position.

Wildcards like: '_a%' find a word of any length with an 'a' in the second position.

Click this window to close it.

It is not required to select one of these radio buttons for the query to work.

To sort any result of the query, select either the ascending or descending radio button.

The Ascending radio button will sort from (A to Z) or (1 to 9).

The Descending radio button will sort (Z to A) or (9 to 1).

If you chose 'mexico' in the input field above, this will sort those results by this column.

Click this window to close it.

This field is where you select the column of the table that you want to work with.

If you do not select a column below to sort by, the results will be sorted by this column.

You must select one of these radio buttons for the database query to work.

Click this window to close it.

You can enter search text in the input field in which to limit your query as: like 'mexico'

Wildcards like: '%a' find any record that ends with 'a'.

Wildcards like: 'a%' find any record that starts with 'a'.

Wildcards like: '%a%' find any record with 'a' in any position.

Wildcards like: '_a' find a two-letter word with 'a' in the second position.

Wildcards like: '_a%' find a word of any length with an 'a' in the second position.

Click this window to close it.

It is not required to select one of these radio buttons for the query to work.

To sort any result of the query, select either the ascending or descending radio button.

The Ascending radio button will sort from (A to Z) or (1 to 9).

The Descending radio button will sort (Z to A) or (9 to 1).

If you chose 'mexico' in the input field above, this will sort those results by this column.

Click this window to close it.

This field is where you select the column of the table that you want to work with.

If you do not select a column below to sort by, the results will be sorted by this column.

You must select one of these radio buttons for the database query to work.

Click this window to close it.

You can enter search text in the input field in which to limit your query as: like 'mexico'

Wildcards like: '%a' find any record that ends with 'a'.

Wildcards like: 'a%' find any record that starts with 'a'.

Wildcards like: '%a%' find any record with 'a' in any position.

Wildcards like: '_a' find a two-letter word with 'a' in the second position.

Wildcards like: '_a%' find a word of any length with an 'a' in the second position.

Click this window to close it.

It is not required to select one of these radio buttons for the query to work.

To sort any result of the query, select either the ascending or descending radio button.

The Ascending radio button will sort from (A to Z) or (1 to 9).

The Descending radio button will sort (Z to A) or (9 to 1).

If you chose 'mexico' in the input field above, this will sort those results by this column.

Click this window to close it.

This field is where you select the column of the table that you want to work with.

If you do not select a column below to sort by, the results will be sorted by this column.

You must select one of these radio buttons for the database query to work.

Click this window to close it.

You can enter search text in the input field in which to limit your query as: like 'mexico'

Wildcards like: '%a' find any record that ends with 'a'.

Wildcards like: 'a%' find any record that starts with 'a'.

Wildcards like: '%a%' find any record with 'a' in any position.

Wildcards like: '_a' find a two-letter word with 'a' in the second position.

Wildcards like: '_a%' find a word of any length with an 'a' in the second position.

Click this window to close it.

It is not required to select one of these radio buttons for the query to work.

To sort any result of the query, select either the ascending or descending radio button.

The Ascending radio button will sort from (A to Z) or (1 to 9).

The Descending radio button will sort (Z to A) or (9 to 1).

If you chose 'mexico' in the input field above, this will sort those results by this column.

Click this window to close it.

This field is where you select the column of the table that you want to work with.

If you do not select a column below to sort by, the results will be sorted by this column.

You must select one of these radio buttons for the database query to work.

Click this window to close it.

You can enter search text in the input field in which to limit your query as: like 'mexico'

Wildcards like: '%a' find any record that ends with 'a'.

Wildcards like: 'a%' find any record that starts with 'a'.

Wildcards like: '%a%' find any record with 'a' in any position.

Wildcards like: '_a' find a two-letter word with 'a' in the second position.

Wildcards like: '_a%' find a word of any length with an 'a' in the second position.

Click this window to close it.

It is not required to select one of these radio buttons for the query to work.

To sort any result of the query, select either the ascending or descending radio button.

The Ascending radio button will sort from (A to Z) or (1 to 9).

The Descending radio button will sort (Z to A) or (9 to 1).

If you chose 'mexico' in the input field above, this will sort those results by this column.

Click this window to close it.

This field is where you select the column of the table that you want to work with.

If you do not select a column below to sort by, the results will be sorted by this column.

You must select one of these radio buttons for the database query to work.

Click this window to close it.

You can enter search text in the input field in which to limit your query as: like 'mexico'

Wildcards like: '%a' find any record that ends with 'a'.

Wildcards like: 'a%' find any record that starts with 'a'.

Wildcards like: '%a%' find any record with 'a' in any position.

Wildcards like: '_a' find a two-letter word with 'a' in the second position.

Wildcards like: '_a%' find a word of any length with an 'a' in the second position.

Click this window to close it.

It is not required to select one of these radio buttons for the query to work.

To sort any result of the query, select either the ascending or descending radio button.

The Ascending radio button will sort from (A to Z) or (1 to 9).

The Descending radio button will sort (Z to A) or (9 to 1).

If you chose 'mexico' in the input field above, this will sort those results by this column.

Click this window to close it.

This field is where you select the column of the table that you want to work with.

If you do not select a column below to sort by, the results will be sorted by this column.

You must select one of these radio buttons for the database query to work.

Click this window to close it.

You can enter search text in the input field in which to limit your query as: like 'mexico'

Wildcards like: '%a' find any record that ends with 'a'.

Wildcards like: 'a%' find any record that starts with 'a'.

Wildcards like: '%a%' find any record with 'a' in any position.

Wildcards like: '_a' find a two-letter word with 'a' in the second position.

Wildcards like: '_a%' find a word of any length with an 'a' in the second position.

Click this window to close it.

It is not required to select one of these radio buttons for the query to work.

To sort any result of the query, select either the ascending or descending radio button.

The Ascending radio button will sort from (A to Z) or (1 to 9).

The Descending radio button will sort (Z to A) or (9 to 1).

If you chose 'mexico' in the input field above, this will sort those results by this column.

Click this window to close it.

This field is where you select the column of the table that you want to work with.

If you do not select a column below to sort by, the results will be sorted by this column.

You must select one of these radio buttons for the database query to work.

Click this window to close it.

You can enter search text in the input field in which to limit your query as: like 'mexico'

Wildcards like: '%a' find any record that ends with 'a'.

Wildcards like: 'a%' find any record that starts with 'a'.

Wildcards like: '%a%' find any record with 'a' in any position.

Wildcards like: '_a' find a two-letter word with 'a' in the second position.

Wildcards like: '_a%' find a word of any length with an 'a' in the second position.

Click this window to close it.

It is not required to select one of these radio buttons for the query to work.

To sort any result of the query, select either the ascending or descending radio button.

The Ascending radio button will sort from (A to Z) or (1 to 9).

The Descending radio button will sort (Z to A) or (9 to 1).

If you chose 'mexico' in the input field above, this will sort those results by this column.

Click this window to close it.