Changing the Inbox View in Outlook – Instructions

Changing the Inbox View in Outlook - Instructions: A picture of the “Manage All Views” dialog box in Outlook.
Changing the Inbox View in Outlook: Overview Changing the Inbox View in Outlook by Selecting a Different, Existing View             By changing the Inbox view in Outlook, you can organize your email to better suits your individual needs. The first step in changing the Inbox view in Outlook is to
Read more
No Comments

SQL View in Access- Instructions

A picture showing a query in SQL view in Access.
Overview of SQL View in Access             SQL view in Access lets you see the SQL code of Access queries. When you are visually creating the query in the query design view in Access, what you are really doing is visually constructing SQL code. SQL stands for Structured Query Language. SQL is a multi-platform language
Read more
No Comments

Buy Introductory SQL Quick Reference Cards

Buy Introductory SQL Quick Reference Cards at TeachUcomp, Inc. with Our New Product Release, the “Introductory SQL Quick Reference Guide!”             You can now buy Introductory SQL quick reference cards with our new “Introductory SQL Quick Reference Guide” product. This Introductory SQL quick reference card is a great reference tool for both database pros and
Read more
No Comments

The DROP Statement in SQL – Tutorial

The DROP Statement in SQL - Tutorial: A picture of the general syntax of the DROP DATABASE, DROP TABLE, and TRUNCATE TABLE commands in SQL.
The DROP Statement in SQL: Overview             You use the DROP statement in SQL to delete created database objects. You can use the DROP statement in SQL to delete databases, tables and indexes. You can also use the DROP statement in SQL in conjunction with the ALTER TABLE statement to delete fields
Read more
No Comments

NULL Values in SQL – Tutorial

NULL Values in SQL - Tutorial: A picture of the main bullet points of the lesson on NULL values in SQL.
NULL Values in SQL: Overview             When creating tables in SQL, you will need to deal with NULL values in SQL. A NULL value is a value that is unknown. These values can occur within database tables when a user who is performing data entry skips entering a value into a field. When a value
Read more
No Comments

The UPDATE Statement in SQL- Tutorial

The UPDATE Statement in SQL- Tutorial: A picture of the core SQL of the UPDATE statement in SQL.
The UPDATE Statement in SQL: Overview             After you have data within the tables in your database, you will often need to update those records. SQL uses the UPDATE statement to update field data within specified records in a table. The core SQL of the UPDATE statement is shown below. Note that the “table_name” parameter
Read more
No Comments

The SELECT Statement in SQL- Tutorial

The SELECT Statement in SQL- Tutorial: A picture of the SELECT statement syntax in SQL.
The SELECT Statement in SQL: Overview             You use the SELECT statement in SQL to choose specific records to view from a table, or from related tables, within a temporary table called a result set. We will start the examination of the SELECT statement by looking at the SELECT statement in its simplest form when
Read more
No Comments

CREATE DATABASE Statement- Tutorial

CREATE DATABASE Statement: Overview             Within many relational database management systems, the CREATE DATABASE statement is used to create the database. The core SQL of the statement is shown below. CREATE DATABASE database_name             In this statement, the “database_name” parameter is the name you want to give to the database. Note that while most versions
Read more
No Comments