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 DC
      • Lightroom Classic CC 2018
      • Photoshop 2021
      • Photoshop 2020
      • Photoshop CC 2018
      • 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

Sort a Query in Access – Instructions

Friday, August 27 2021 by Joseph Brownell
A picture that shows how to sort a query in Access in datasheet view by using the buttons in the “Sort & Filter” button group on the “Home” tab of the Ribbon.
Overview of Sorting a Query in Access             You can sort a query in Access by any field within the QBE grid when viewing the query in design view. To sort a query in Access when in design view, click into the “Sort” row of the field in the QBE grid by which to sort
accessaccess 2013Access 2016Access 2019Access for Microsoft 365Access for Office 365access query custom sortaccess query sort orderaccess sort querycolumncolumnscoursedatasheet viewdesign querydesign viewfieldfieldshelphow can you sort data in accesshow to sort a query in accesshow to sort alphabetically in access queryhow to sort query in accesshow-toinstructionslearnlessonMicrosoft Accessorder by accessoverviewqueriesqueryquery sortresult setset the sort order in accesssortSort a Query in Accesssort by multiple columns in accesssort columnssort querysortingsorting a query in accesssorting queries in accessteachtrainingtutorialvideo
Read more
  • Published in Access 2013, Access 2016, Access 2019, Access for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
No Comments

Create Input Masks in Access – Instructions

Thursday, August 26 2021 by Joseph Brownell
A picture of the “Input Mask Wizard” in Access you use to create input masks in Access.
Overview of Creating Input Masks in Access             You can create input masks in Access for table fields to dictate a pattern to use for data entry in the fields. You can manually create input masks for most text, date, and number data type fields in Access, except the “Long Text” data type. Access also
accessaccess 2013Access 2016Access 2019Access for Microsoft 365Access for Office 365access input maskapplyapply an input mask in accessclasscoursecreatecreate an input mask in accessCreate Input Masks in Accesscreating input masks in accessdata entrydatabasedatabasesfieldfield propertiesfieldshelphow to apply an input mask in accesshow to create an input mask in accesshow-toinput maskinput mask accessinput mask in accessinput mask property accessinput mask wizard accessinput masksinstructionslearnlessonMicrosoft Accessmicrosoft access input maskms access input maskoverviewpropertytabletablesteachtrainingtutorialvideowhat is input maskwhat is input mask in access
Read more
  • Published in Access 2010, Access 2013, Access 2016, Access 2019, Access for Office 365, Latest, Microsoft, Office 2010, Office 2013, Office 2016, Office 2019, Office 365
No Comments

Select Controls in Access- Instructions

Wednesday, August 25 2021 by Joseph Brownell
Select Controls in Access: A picture of a user selecting multiple controls in Access.
Overview of Selecting Controls in Access             When placing controls into forms and reports in design view, you often need to select the controls. In this lesson, you will look at the ways that you can select controls in Access.             To select a control in Access, click the control you want to select. When
accessaccess 2013Access 2016Access 2019Access for Microsoft 365Access for Office 365controlcontrolscoursede-selectdeselect controls in accessdeselecting controls in accessdesign viewform design viewform layout viewformshelphow to select controls in accesshow-toinstructionslayout viewlearnlessonMicrosoft Accessmultipleoverviewreport design viewreport layout viewreportsselectselect controls in Accessselectingselecting controls in Accessteachtrainingtutorialvideo
Read more
  • Published in Access 2013, Access 2016, Access 2019, Access for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
No Comments

Export Data from Access – Instructions

Tuesday, August 24 2021 by Joseph Brownell
A picture that shows how to export data from Access for Microsoft 365 to Excel.
Overview of Exporting Data from Access             You can easily export data from Access to a wide variety of formats that are available. You can also export other database objects, like forms and reports. However, there are more limitations on the formats to which these types of objects can be exported.             To export data
accessaccess 2013Access 2016Access 2019access exportAccess for Microsoft 365Access for Office 365access to exportdatabaseexportexport accessexport access databaseexport access to excelExport Data from Accessexport data in accessexportingfilefileshelphow to export data from accesshow to export data from access to excelhow to export data in accesshow to export from accesshow to export in accesshow-toinstructionslearnlessonmicrosoftMicrosoft Accessmicrosoft access exportms access exportoverviewtabletablesteachtrainingtutorialvideo
Read more
  • Published in Access 2013, Access 2016, Access 2019, Access for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
No Comments

Create Tables in Access – Instructions

Monday, August 23 2021 by Joseph Brownell
A picture of a user creating a new table in table design view in Access.
Overview of How to Create Tables in Access             This lesson shows you how to create tables in Access. A table is an organized structure that holds information. It consists of fields of information into which you enter the records of the table. A field is a single column within a table, consisting of one
accessAccess 2019Access for Microsoft 365Access for Office 365addblankcolumnscoursecreate tables in Accesscreate tables in design viewcreating tablesdata typedata typesdatabasedatabase filedatabase filesdesign viewfieldfieldshelphow to create a table in accesshow to create tables in accesshow-toinstructionslearnlessonmakeMicrosoft Accessms accessnewoverviewprimary keyrecordsrowssaveself studytabletablesteachtrainingtutorialvideo
Read more
  • Published in Access 2019, Access for Office 365, Latest, Microsoft, Office 2019, Office 365
No Comments

Create Relationships in Access – Instructions

Friday, August 20 2021 by Joseph Brownell
A picture of a user creating a relationship, or table join, between two database tables in the Relationships window in Access.
Overview of Creating Relationships in Access Opening the Relationships Windows in Access             You create relationships in Access between database tables in the Relationships window. As you create tables in Access, you want to relate the tables to access information from them through the “shared” or “common” fields by which they are joined. Relationships in
accessAccess 2019Access for Microsoft 365Access for Office 365adding tables to the relationships window in accesscourseCreate Relationships in AccessCreating Relationships in Accesscreating relationships in the relationships windowcreating table joins in accessenforce referential integrity in accesshelphow to add tables to the relationships window in accesshow to create a relationship in accesshow to create a table join in accesshow to create table joins in accesshow to enforce referential integrity in accesshow to join tables in accesshow to open the relationships window in accesshow to relate tables in accesshow to save changes to relationships in accesshow-toinstructionslearnlessonMicrosoft Accessms accessoverviewself studyteachthe relationships window in accesstotaltrainingtutorialvideo
Read more
  • Published in Access 2019, Access for Office 365, Latest, Microsoft, Office 2019, Office 365
No Comments

Create a Query in Access – Instructions

Thursday, August 19 2021 by Joseph Brownell
Create a Query in Access- Instructions and Video: A picture of a user creating a new query in Access in query design view.
Overview of Creating a Query in Access Creating a New Query in Access             To create a query in Access in query design view, click the “Create” tab in the Ribbon. Then click the “Query Design” button in the “Queries” button group. Doing this then creates a new query in query design view in Access.
accessAccess 2019Access for Microsoft 365Access for Office 365add fields to a query in accessadd table to a query in accessadding fields to a query in accessadding tables to a query in accesscourseCreate a Query in Accesscreating a query in accessdelete a field from a query in accessdeleting query fields in accessdesign a query in accessdesign querydesigning querieshelphow to add fields to a query in accesshow to add tables to a query in accesshow to create a query in accesshow to delete a field from a query in accesshow to make a query in accesshow to move a query field in accesshow to reorganize query fields in accesshow to save a query in accesshow-toinstructionslearnlessonmake a query in accessMicrosoft Accessmove a query field in accessms accessoverviewquery design viewquery design view in accessreordering query fields in accessrun a query in query design view in accesssave a query in accesssaving a query in accessself studyteachtotaltrainingtutorialvideo
Read more
  • Published in Access 2019, Access for Office 365, Latest, Microsoft, Office 2019, Office 365
No Comments
  • 1
  • 2
  • 3
  • 4

 

Recent Posts

  • A picture that shows how to create moving elements in Photoshop Elements.

    Moving Elements in Photoshop Elements – Instructions

    Overview of How to Create Moving Elements in Ph...
  • Layer Types in Photoshop Elements: A picture of a user simplifying a Smart Object layer in Photoshop elements.

    Layer Types in Photoshop Elements- Instructions

    Overview of the Layer Types in Photoshop Elemen...
  • A picture of the training interface for the digital download or DVD versions of our Photoshop Elements training, titled “Mastering Photoshop Elements Made Easy™ v.2023.”

    Photoshop Elements Training

    Photoshop Elements Training for Photoshop Eleme...

Categories

Archives

  • GET SOCIAL

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

TOP
Sale! $49 All-Access 1 Days 18 Hours 47 Minutes 44 Seconds      $199 $49 Entire Library!
See Deal