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

Delete a Table Field in Access- Tutorial

Delete a Table Field in Access: Overview             You can delete a table field that you do not use from a table in an Access database. Once again, as when changing a field name, make sure that there are not any queries, forms, reports or macros that refer to the field or use data contained
Read more
No Comments

The UNION Operator in SQL- Tutorial

The UNION Operator in SQL- Tutorial: A picture from the video lesson for
The UNION Operator in SQL: Overview             The UNION operator in SQL allows you to combine the result sets of two or more individual SELECT statements into a single result set. Note that the UNION operator in SQL is not a JOIN, but rather a way to combine the data within two result sets into
Read more
No Comments

The DELETE Statement in SQL- Tutorial

The DELETE Statement in SQL- Tutorial: A picture from the video lesson
The DELETE Statement in SQL: Overview             The DELETE statement in SQL is used to remove specified records from a table. Like the UPDATE statement, it includes a WHERE clause that you should ensure is correct before executing the DELETE statement in SQL. If you do not specify a WHERE clause within the DELETE statement
Read more
No Comments

DROP USER and DROP ROLE Statements in SQL

DROP USER and DROP ROLE Statements in SQL: A picture from the video lesson titled
DROP USER and DROP ROLE Statements in SQL: Overview             This blog post discusses using the DROP USER and DROP ROLE statements in SQL. You can use the DROP USER statement in SQL to delete a user from the database. Note that this statement is technically classified as Data Definition Language (DDL), as it defines
Read more
No Comments

Microsoft Office 365 vs. Microsoft Office 2013 Training

A picture of the web page for
Microsoft Office 365 vs. Microsoft Office 2013             As a software training center, we have noticed that there still seems to be some confusion between Microsoft Office 365 vs. Microsoft Office 2013 and what that entails for the related Microsoft Office training. This article will attempt to clarify the differences between the two. The major
Read more
No Comments

Find Office Tips with the Microsoft Office 2013 Basics Quick Reference Guide

              A Reference Guide Full of Office Tips             Many users who are already familiar with using the products contained in the Microsoft Office 2013 suite of products may only need a quick tip on how to perform common tasks. You can find many common
Read more
No Comments