TeachUcomp, Inc.

P: 877-925-8080

  • HOME
  • VIDEO COURSES
    • All-Access Subscriptions
    • Business Licensing
    • Course List
      • 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 DC
      • Lightroom Classic CC 2018
      • Photoshop 2021
      • Photoshop 2020
      • Photoshop CC 2018
      • 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
    • 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 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 10
  • STICKERS
    • Chrome OS
      • Chrome OS for Chromebooks
    • Mac OS
      • Mac OS Monterey-Mojave
    • Microsoft Office
      • Excel and Word 2021-2016 and 365
    • QuickBooks Desktop
      • QuickBooks Desktop 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
  • CART
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

The Format Property for Yes/No Fields in Access – Tutorial

Wednesday, February 03 2016 by Joseph Brownell
The Format Property for Yes/No Fields in Access - Tutorial: A picture of a user setting the
The Format Property for Yes/No Fields in Access: Overview             You can set the Format property for Yes/No fields in Access to change the way that they will display in forms and reports. The following formats are available for logical fields in Access. To set the Format property for Yes/No fields in Access, simply select
accessaccess 2010access 2013designdesign viewfieldfield propertiesfieldsformathelphow-toinstructionslearnlessonlogical fieldsoverviewpropertytabletablesteachThe Format Property for Yes/No Fields in Accesstrainingtutorialvideoyes/no fields
Read more
  • Published in Access 2010, Access 2013, Latest, Microsoft, Office 2010, Office 2013
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

Delete a Table Field in Access- Tutorial

Monday, August 17 2015 by Joseph Brownell
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
accessaccess 2010access 2013coursedeleteDelete a Table Field in Accessdesign viewfieldhelphow-toinstructionslearnlessonMicrosoft Accessoverviewtableteachtrainingtutorialvideo
Read more
  • Published in Access 2010, Access 2013, Latest, Microsoft, Office 2010, Office 2013
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

The DELETE Statement in SQL- Tutorial

Tuesday, December 16 2014 by Joseph Brownell
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
access 2013how-tolearnlessonmySQLoverviewSQLSQL Server 2012syntaxteachThe DELETE StatementThe DELETE Statement in SQLtrainingtutorialvideo
Read more
  • Published in Access 2013, Latest, Microsoft, Office 2013, SQL
No Comments

DROP USER and DROP ROLE Statements in SQL

Thursday, November 20 2014 by Joseph Brownell
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
access 2013DCLDDLDROP USER and DROP ROLE Statements in SQLhelphow-tolearnlessonmySQLSQLSQL Serverstatementssyntaxteachtrainingtutorialvideo
Read more
  • Published in Access 2013, Latest, Microsoft, SQL
No Comments
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6

 

Recent Posts

  • A picture showing how to use comments in HTML code.

    Comments in HTML – Instructions

    Overview of How to Add Comments in HTML        ...
  • A picture showing how to use the Pre tag in HTML.

    Pre Tag in HTML – Instructions

    Overview of How to Use the Pre Tag in HTML     ...
  • A picture showing the Start Personalization settings that let you customize the Start menu in Windows 11.

    How to Customize the Start Menu in Windows 11 – Instructions

    Overview of How to Customize the Start Menu in ...

Categories

Archives

  • GET SOCIAL

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

TOP
$199 $49 Entire Library! -1 Days 22 Hours 10 Minutes 0 Seconds      Get a better price
Ask For Coupon