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

Create a Calculated Field in Access – Instructions

Tuesday, September 21 2021 by Joseph Brownell
A picture that shows how to create a calculated field in Access in query design view.
Overview of Creating a Calculated Field in Access             You can easily create a calculated field in Access queries. A calculated field is a field that derives its value by performing a function on values from other table fields. It can also calculate values entered by hand. The field’s data only appears for the duration
aboutaccessaccess 2013Access 2016Access 2019access add calculated field to queryaccess calculated fieldaccess calculated field in queryaccess databaseAccess for Microsoft 365Access for Office 365access formulas in queriesaccess query calculated fieldaddadd a calculated field in accessaddingcalculated fieldcalculated field accesscalculated field access querycalculated field in accesscalculated field in access querycalculated fieldscalculationcalculationscolumncolumnscoursecreateCreate a Calculated Field in Accesscreate calculated field in access querycreatingdesign viewfieldformulaformulasfunctionfunctionshelphow to add a calculated field in accesshow to add a calculated field in access queryhow to add a calculated field to a query in accesshow to add calculated field in accesshow to add calculated field in access queryhow to create a calculated field in a query in accesshow to create a calculated field in accesshow to create a calculated field in access queryhow-toinfoinformationinsertinsertinginstructionslearnlessonMicrosoft Accessms access calculated fieldms access query calculated fieldoverviewqueriesqueryself studyteachtrainingtutorialvideo
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

Hide a Query Field in Access – Instructions

Monday, September 20 2021 by Joseph Brownell
A picture showing how to hide a query field in Access.
Overview of How to Hide a Query Field in Access             You can easily hide a query field in Access. Sometimes when you create queries, you need to add a field to the QBE grid for criteria purposes only. In this case, you don’t want the field itself to appear in the result set. Having
accessaccess 2013Access 2016Access 2019Access for Microsoft 365Access for Office 365designing queriesdisplayfieldfieldshelphidehide a field in query design viewHide a Query Field in Accesshow to hide a field in access queryhow to hide a field in query design viewhow to hide a query field in accesshow-toinstructionslearnlessonMicrosoft Accessms accessoverviewQBEqueriesqueryresult setshowteachtrainingtutorialvideowhich row in the query design view is used to hide a column from displaying in the query results
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

Run a Query in Access – Instructions and Video Lesson

Thursday, September 16 2021 by Joseph Brownell
A picture showing how to run a query in Access when it is opened in query design view.
Overview of How to Run a Query in Access             You can run a query in Access when using query design view. To do this, click the “Query Design” contextual tab in the Ribbon. In older versions of Access, this tab is called the “Design” tab of the “Query Tools” contextual tab in the Ribbon,
accessaccess 2013Access 2016Access 2019access execute queryAccess for Microsoft 365Access for Office 365access how to run a queryaccess run querycoursedesign viewhelphow do you run a query in accesshow to run a query in accesshow to run query in accesshow to run query in ms accesshow-toinstructionslearnlessonMicrosoft Accessmicrosoft access run queryms access run querynavigation paneopenoverviewqueriesqueryrunRun a Query in AccessRun a Query in Access 2013run query accessrun query in accessteachtrainingtutorialvideoview
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

SQL View in Access- Instructions

Wednesday, September 01 2021 by Joseph Brownell
A picture showing a query in SQL view in Access.
Overview of SQL View in Access             SQL view in Access lets you see the SQL code of Access queries. When you are visually creating the query in the query design view in Access, what you are really doing is visually constructing SQL code. SQL stands for Structured Query Language. SQL is a multi-platform language
accessaccess 2010access 2013Access 2016Access 2019Access for Microsoft 365Access for Office 365access sqlaccess sql viewcreate sql in accessedit sql in accesshelphow to change the sql in accesshow to see sql in accesshow to show sql in accesshow to view sql in accesshow-toinstructionslearnlessonMicrosoft Accessms accessoverviewQBEqueriesquerysave sql in accesssee sql for access queryshow sql for access queryshow sql in accessSQLSQL viewsql view in accessteachtrainingtutorialusevideowrite sql 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

Wildcard Characters in Access- Instructions

Tuesday, August 31 2021 by Joseph Brownell
A picture showing how to use wildcard characters within query criteria in Access.
Overview of Wildcard Characters in Access             Wildcard characters in Access add flexibility to query criteria. Wildcard characters in Access represent unknown values. The asterisk “*” and the question mark “?” are the two main wildcard characters in Access you need to know. The asterisk represents multiple unknown characters. For example, the criteria “N*” would
accessaccess 2010access 2013Access 2016Access 2019Access for Microsoft 365Access for Office 365access wild cardaccess wildcardaccess wildcard charactersaccess wildcardsaddasteriskcriteriadesigndesign querydesign viewfind unknown charactershelphow-toinsertinstructionslearnlessonMicrosoft Accessms accessoverviewQBEqueriesqueryquery builderquestion markteachtrainingtutorialtwo wildcard characters in accessusevideowild card in accesswildcardwildcard accesswildcard character in accesswildcard characterswildcard characters exampleWildcard Characters in Accesswildcard in accesswildcards
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

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

Aggregate Function Queries in Access – Instructions

Monday, August 16 2021 by Joseph Brownell
A picture of a user creating an aggregate function query in Access.
Overview of Aggregate Function Queries in Access             Aggregate function queries in Access let you create summary queries that perform a mathematical function, called an “aggregate function,” on a field, based on groups of values found in another grouped query field or grouped query fields. These are usually shorter queries, often used for reporting.            
accessaccess 2013Access 2016Access 2019access aggregate functionAccess for Microsoft 365Access for Office 365access group byaccess group by queryaccess query group byaccess query sum group byaccess sum functionaccess sum queryaggregateaggregate accessaggregate function accessaggregate function in accessAggregate Function Queries in Accessaggregate functionsaggregate functions accessaggregate queryaggregation querycoursedesign querydesign viewexpression aggregate query accessfunctionfunctionsgroupgroup bygroup by accessgroup by in accessgroupinghelphow-toinstructionslearnlessonMicrosoft Accessms accessms access aggregate functionsoverviewqueriesqueryself studysum aggregate query accesssummarizesummaryteachtotaltrainingtutorialvideowhat is aggregate accesswhere aggregate query access
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
  • 1
  • 2

 

Recent Posts

  • A picture showing how to change item prices in QuickBooks Desktop Pro by using the “Change Item Prices” window.

    Change Item Prices in QuickBooks Desktop Pro – Instructions

    Overview of How to Change Item Prices in QuickB...
  • A picture showing how to create a clipping mask in Photoshop Elements.

    Create a Clipping Mask in Photoshop Elements – Instructions and Video

    Overview of How to Create a Clipping Mask in Ph...
  • 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...

Categories

Archives

  • GET SOCIAL

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

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