TeachUcomp, Inc.

 MY CART
  • VIDEO COURSES
    • All-Access Subscriptions
    • Business Licensing
    • Course List
      • Accounting
      • Adobe
        • Acrobat
        • Lightroom Classic
        • Photoshop
        • Photoshop Elements
      • Crystal Reports
      • Employment Skills
        • Interview Skills
        • Resume Skills
      • For Lawyers
        • Excel for Lawyers
        • Outlook for Lawyers
        • QuickBooks for Lawyers
        • Word for Lawyers
      • HTML
      • JavaScript
      • Microsoft Office
        • Access
        • Excel
        • Microsoft Office Suite
        • OneNote
        • Outlook
        • Outlook on the Web
        • PowerPoint
        • Publisher
        • Word
      • Microsoft Project
      • Microsoft Teams
      • QuickBooks Online
      • QuickBooks Pro
      • Sage
        • Peachtree
        • Sage 50
      • SQL
      • Windows
    • Video Course Options
  • SUBSCRIPTIONS
  • MANUALS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements
    • Crystal Reports
    • For Lawyers
      • Excel for Lawyers
      • Outlook for Lawyers
      • QuickBooks for Lawyers
      • Word for Lawyers
    • HTML
    • JavaScript
    • Microsoft Office
      • Access
      • Excel
      • OneNote
      • Outlook
      • Outlook on the Web
      • PowerPoint
      • Publisher
      • Word
    • Microsoft Project
    • Microsoft Teams
    • QuickBooks Online
    • QuickBooks Pro
    • Sage
      • Peachtree
      • Sage 50
    • SQL
    • Windows
  • REFERENCE CARDS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements 2023
      • Photoshop Elements 2022
      • Photoshop Elements 2021
      • Photoshop Elements 2020
      • Photoshop Elements 2019
      • Photoshop Elements 2018
      • Photoshop Elements 15
    • Google
      • Google Classroom for Teachers
      • Google Docs
      • Google Drive
      • Google Forms
      • Google Sheets
      • Google Slides
    • Mac OS
      • Mac OS Ventura-Mojave Keyboard Shortcuts
    • Microsoft Office
      • Microsoft Office 365
        • Access for Office 365
        • Excel for Office 365
        • Microsoft Office 365
        • Outlook for Office 365
        • PowerPoint for Office 365
        • Publisher for Office 365
        • Word for Office 365
      • Microsoft Office 2021
        • Access 2021
        • Excel 2021
        • Microsoft Office 2021
        • Outlook 2021
        • PowerPoint 2021
        • Publisher 2021
        • Word 2021
      • Microsoft Office 2019
        • Access 2019
        • Excel 2019
        • Microsoft Office 2019
        • Outlook 2019
        • PowerPoint 2019
        • Publisher 2019
        • Word 2019
      • Microsoft Office 2016
        • Access 2016
        • Excel 2016
        • Microsoft Office 2016
        • OneNote 2016
        • Outlook 2016
        • PowerPoint 2016
        • Publisher 2016
        • Word 2016
      • Microsoft Office 2013
        • Excel 2013
        • Microsoft Office 2013
        • OneNote 2013
        • Outlook 2013
        • PowerPoint 2013
        • Word 2013
      • Microsoft Office for iPad
        • Microsoft Office for iPad
    • Microsoft Teams
      • Microsoft Teams
    • QuickBooks Online
      • QuickBooks Online
    • QuickBooks Pro
      • QuickBooks Pro 2023
      • QuickBooks Pro 2022
      • QuickBooks Pro 2021
      • QuickBooks Pro 2020
      • QuickBooks Pro 2019
      • QuickBooks Pro 2018
      • QuickBooks Pro 2017
      • QuickBooks Pro 2016
      • QuickBooks Pro 2015
      • QuickBooks Pro 2014
    • Sage
      • Sage 50 2019
      • Sage 50 2018
    • SQL
      • SQL
    • Windows
      • Windows 11
      • Windows 11 and 10 Keyboard Shortcuts
      • Windows 10
  • STICKERS
    • Chrome OS
      • Chrome OS for Chromebooks
    • Mac OS
      • Mac OS Ventura
      • Mac OS Monterey-Mojave
    • Microsoft Office
      • Word and Excel (Mac) 2022
      • Word and Excel (PC/Windows) 2021-2016 and 365
    • QuickBooks Desktop
      • QuickBooks Desktop (PC/Windows) 2023
      • QuickBooks Desktop (PC/Windows) 2022-2015
    • Windows
      • Windows 11 and 10
  • SUPPORT
    • Company
      • About Us
      • Blog
      • Contact Us
      • Our History
      • Our Philosophy
        • Customer Service
        • Mission
      • Policies
      • Testimonials
    • Contact Us
    • FAQ
    • Help
    • Lost Password
    • Register a Product
  • LOGIN
    • Manage My Account
    • Member Login
    • My Courses
Shop Now

How to Use the ORDER BY Clause in SQL

Monday, August 30 2021 by Joseph Brownell
A picture that shows how to use the ORDER BY clause in SQL within an Access query.
Overview of the ORDER BY Clause in SQL             This blog post shows you how to use the ORDER BY clause in SQL to sort the result set of a query. When viewing the result set of a SELECT statement in SQL, the records appear in the order that they were selected from the table.
accessaccess 2013Access 2016Access 2019Access for Microsoft 365Access for Office 365coursefieldfieldshelphow to sort a select statement in sqlhow to sort in sqlhow to sort queries in sqlHow to Use the ORDER BY Clause in SQLhow-toinstructionslearnlessonMicrosoft Accessorder by accessorder by in accessorder by in microsoft azureorder by in mysqlorder by in SQLorder by in sql serverorder by in t-sqloverviewqueriesqueryquery sortresult setsortsort a select statement in sqlsort columnssort in sqlsort queries in sqlsort querysortingteachthe order by clause in sqltrainingtutorialvideo
Read more
  • Published in Access 2019, Access for Office 365, Latest, Microsoft, Office 2019, Office 365, SQL
No Comments

Buy Introductory SQL Quick Reference Cards

Friday, July 09 2021 by Joseph Brownell
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
buyBuy Introductory SQL Quick Reference Cardscheat sheetcheat sheetshelphow-toinstructionsintroductory SQLlearnnew productnewsproduct releasequick reference cardquick reference cardsreference guideshopSQLSQL cheat sheetSQL cheat sheetsSQL quick reference cardSQL quick reference cardsteachwhat's new
Read more
  • Published in Latest, Marketing, News, SQL, What's New at TeachUcomp?
No Comments

The DROP Statement in SQL – Tutorial

Thursday, July 14 2016 by Joseph Brownell
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
accessaccess 2013ALTER TABLEcommandcommandscourseDROP DATABASEDROP INDEXDROP statementDROP TABLEhelphow-tolearnlessonMicrosoft AccessmySQLoverviewSQLSQL ServerSQL Server 2012statementstatementssyntaxteachThe DROP Statement in SQLtrainingTRUNCATE TABLEtutorialuseusingvideowrite
Read more
  • Published in Access 2013, Latest, Microsoft, Office 2013, SQL
No Comments

NULL Values in SQL – Tutorial

Tuesday, April 12 2016 by Joseph Brownell
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
accessaccess 2013allowcoursedisallowexamplefieldfieldsfindhelphow-toIS NOT NULLIS NULLlearnlessonMicrosoft AccessNOT NULLNULLNULL Values in SQLoverviewqueryselectself studySQLstatementsyntaxtabletablesteachtrainingtutorialvaluevaluesvideo
Read more
  • Published in Access 2013, Latest, Microsoft, Office 2013, SQL
No Comments

The UPDATE Statement in SQL- Tutorial

Wednesday, October 28 2015 by Joseph Brownell
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
access 2013classcoursehelphow-tointroductory SQLlearnmySQLoverviewSQLSQL Server 2012statementsyntaxteachThe UPDATE Statement in SQLtrainingtutorialupdate
Read more
  • Published in Access 2013, Latest, Microsoft, Office 2013, SQL
No Comments

The SELECT Statement in SQL- Tutorial

Monday, September 21 2015 by Joseph Brownell
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
courseexampleexampleshelphow-tointroductory SQLlearnlessonmySQLoverviewselectSELECT statementsSQLSQL ServerSQL Server 2012statementssyntaxteachThe SELECT Statement in SQLtrainingtutorialvideo
Read more
  • Published in Access 2010, Access 2013, Latest, Microsoft, Office 2010, Office 2013, SQL
No Comments

CREATE DATABASE Statement- Tutorial

Friday, June 26 2015 by Joseph Brownell
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
clausescommandscoursecreate databaseCREATE DATABASE Statementhelphow-tolearnlessonoverviewparametersSQLstatementstatementssyntaxteachtrainingtutorialvideo
Read more
  • Published in Latest, SQL
No Comments

The UNION Operator in SQL- Tutorial

Wednesday, February 11 2015 by Joseph Brownell
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
accessclausecoursehelphow-toinstructionsintroductory SQLJOINlearnlessonmySQLoperationoverviewSELECT statementsSQL ServerstatementsyntaxteachThe UNION Operator in SQLtrainingtutorialUNIONvideo
Read more
  • Published in Access 2013, Latest, Office 2013, SQL
No Comments
  • 1
  • 2

 

Recent Posts

  • A picture of the “Add/Edit Multiple List Entries” window that lets you copy and paste list data from Excel into QuickBooks Pro.

    Copy and Paste List Data from Excel into QuickBooks Pro- Instructions

    Overview of How to Copy and Paste List Data fro...
  • A picture showing how to duplicate a layer in Photoshop Elements using the “Duplicate Layer” dialog box.

    Duplicate a Layer in Photoshop Elements – Instructions

    Overview of How to Duplicate a Layer in Photosh...
  • A picture of the “New Item” window when you create payment items in QuickBooks Desktop Pro.

    Create Payment Items in QuickBooks Desktop Pro – Instructions

    Overview of How to Create Payment Items in Quic...

Categories

Archives

  • GET SOCIAL

© 2001-2023 Copyright TeachUcomp, Inc. All rights reserved.

TOP
Sale! $49 All-Access 0 Days 19 Hours 52 Minutes 44 Seconds      $199 $49 Entire Library!
See Deal