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
      • Excel Keyboard Shortcuts
      • 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

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

Microsoft Access 2013 Training: How to Use the Report Wizard

Thursday, May 01 2014 by Keeley Byrnes
To view the complete tutorial with video lessons, click here!                 Using the Report Wizard You use reports to further calculate and then display the results from a query. You can also use them to calculate statistical results on tables or queries for summary reports. They are simply
2013accessclasscoursedatabasehelphowhow-tomanualmicrosoftms accessprogramprogrammingqueryreportreportstrainingtutorialwizard
Read more
  • Published in Access 2013, Latest
No Comments

Understanding SQL Functions- Standard Query Language for Databases

Tuesday, April 15 2014 by Keeley Byrnes
To view the complete tutorial, click here             Understanding SQL Functions Functions serve a wide range of purposes within SQL. You can use aggregate functions to perform calculations on grouped values within a query. That is one very common use of functions within SQL. However, there are other types of
accessclasscoursedatabasedesign queryebookfunctionguidehelphowhow-tolanguagemanualmySQLqueryreferenceSQLSQLitestructuredtrainingtutorial
Read more
  • Published in Latest, SQL
No Comments

Delete, Crosstab, Find Duplicates, and Find Unmatched Queries in Microsoft Access 2013

Wednesday, March 19 2014 by Keeley Byrnes
For the complete tutorial, click here.             Delete Queries You can use a delete query to delete records in a table based on specified criteria. Deleting unnecessary records will speed up the performance of queries, reduce redundancies, and make for more smoothly operating databases. When you run a delete query,
2013accessclasscoursecrosstabdeleteduplicatesfindfind duplicateshelphow-tomicrosoftqueriesqueryrun querytrainingtutorialunmatched
Read more
  • Published in Access 2013, Latest
No Comments

Advanced Queries in Microsoft Access 2010

Tuesday, February 18 2014 by Keeley Byrnes
Make Table Queries Have you ever run a query and wished that you could save the result set of the query as a permanent table? In Access, that is exactly what the “Make Table” queries do. A “Make Table” query creates a new table as the output of a query, instead of simply displaying a
20102013accessaccess 2010access 2013classcoursedatabasehelphow-tomicrosoftqueiresqueryrelationaltrainingtutorial
Read more
  • Published in Access 2010, Latest
No Comments

Designing Queries in Microsoft Access 2010

Monday, December 02 2013 by Keeley Byrnes
Using the Simple Query Wizard You use a query to answer a question that you have about the information stored in the database tables. You can then further analyze the results that the queries pull to produce even more information than the query itself displays. Reports are often based on query results, upon which they
2010accessdatabasedesigndesigning querieshelphow-tomicrosoftqueriesquerytrainingtutorial
Read more
  • Published in Access 2010, Latest
No Comments

How to Use the Simple Query Wizard in Microsoft Access 2013

Thursday, September 19 2013 by Keeley Byrnes
Click here for the complete tutorial             A query is a way to retrieve in formation in a database. In Microsoft Access, you use a query to answer a question that you have about the information stored in the database tables. You can then further analyze the results that the
2013accessbusinessemployeegrouphelphow-tomicrosoftMicrosoft Officeofficequerysimpletrainingtutorialwizard
Read more
  • Published in Access 2013, Latest
No Comments
  • 1
  • 2

 

Recent Posts

  • A picture showing how to import files to the Organizer in Photoshop Elements by using the “Get Photos and Videos from Files and Folders” dialog box.

    Import Files to the Organizer in Photoshop Elements – Instructions

    Overview of How to Import Files to the Organize...
  • A picture showing how to create keyword tags in Photoshop Elements by using the “Create Keyword Tag” dialog box.

    Create Keyword Tags in Photoshop Elements – Instructions

    Overview of How to Create Keyword Tags in Photo...
  • A picture of a user applying Haze Removal in Photoshop Elements.

    Haze Removal in Photoshop Elements – Instructions

    Overview of How to Use Haze Removal in Photosho...

Categories

Archives

  • GET SOCIAL

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

TOP
Sale! $49 All-Access 0 Days 4 Hours 46 Minutes 42 Seconds      $199 $49 Entire Library!
See Deal