TeachUcomp, Inc.

P: 877-925-8080

  • HOME
  • COURSES
    • Course List
    • For Lawyers
    • My Courses
    • Online Learning
      • Member Login
      • Online Learning FAQ
      • Subscribe
    • Training Options
  • FOR BUSINESS
    • Business Licensing
    • Request a Quote
  • MANUALS
  • REFERENCE CARDS
    • Adobe
      • Acrobat DC
      • Lightroom Classic CC 2018
      • Photoshop 2020
      • Photoshop CC 2018
      • Photoshop Elements 2021
      • Photoshop Elements 2020
      • Photoshop Elements 2019
      • Photoshop Elements 2018
      • Photoshop Elements 15
    • Google
      • Google Classroom for Teachers
    • Microsoft Office
      • Microsoft Office 365
        • Excel for Office 365
        • Microsoft Office 365
        • OneNote for Windows 10
        • Outlook for Office 365
        • PowerPoint for Office 365
        • Word for Office 365
      • 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 Pro
      • 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
    • Windows
      • Windows 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
  • MEMBER LOGIN
    • Manage My Account
    • Member Login
    • My Courses
  • MY CART
Shop Now

Create a Calculated Field in Access – Instructions

Monday, May 21 2018 by Joseph Brownell
Create a Calculated Field in Access - Instructions: A picture of a calculated field in an Access query.
Create a Calculated Field in Access: Overview             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 of
aboutaccessaccess 2013Access 2016access databaseaddaddingcalculated fieldcalculated fieldscalculationcalculationscolumncolumnscoursecreateCreate a Calculated Field in Accesscreatingdesign viewfieldformulaformulasfunctionfunctionshelphow-toinfoinformationinsertinsertinginstructionslearnlessonMicrosoft Accessoverviewqueriesqueryself studyteachtrainingtutorialvideo
Read more
  • Published in Access 2013, Access 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365
No Comments

Hide a Query Field in Access – Instructions

Thursday, August 03 2017 by Joseph Brownell
Hide a Query Field in Access - Instructions: A picture of a hidden field in a query, shown within the query design view in Access.
Hide a Query Field in Access: Overview             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 additional fields appear
accessaccess 2013Access 2016designing queriesdisplayfieldfieldshelphideHide a Query Field in Accesshow-toinstructionslearnlessonMicrosoft Accessms accessoverviewQBEqueriesqueryresult setshowteachtrainingtutorialvideo
Read more
  • Published in Access 2013, Access 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365
No Comments

Sort a Query in Access – Tutorial

Friday, June 23 2017 by Joseph Brownell
Sort a Query in Access - Tutorial: A picture of a user sorting a query result set using the buttons in the “Sort & Filter” button group on the “Home” tab in the Ribbon.
Sort a Query in Access: Overview             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, select the field in the QBE Grid by which to sort the result set. Then click into
accessaccess 2013Access 2016columncolumnscoursedatasheet viewdesign querydesign viewfieldfieldshelphow-toinstructionslearnlessonMicrosoft Accessoverviewqueriesqueryresult setsortSort a Query in Accesssort columnssortingteachtrainingtutorialvideo
Read more
  • Published in Access 2013, Access 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365
No Comments

Run a Query in Access – Instructions and Video Lesson

Tuesday, February 21 2017 by Joseph Brownell
Run a Query in Access - Instructions: A picture of a query opened in “Design View” in Access.
Run a Query in Access: Overview             You can run a query in Access when using query design view. To do this, click the “Design” tab of the “Query Tools” contextual tab within the Ribbon. Then click the “Run” button in the “Results” button group.             If the results are not what you expected, you
accessaccess 2013Access 2016coursedesign viewhelphow-toinstructionslearnlessonMicrosoft Accessnavigation paneopenoverviewqueriesqueryrunRun a Query in AccessRun a Query in Access 2013teachtrainingtutorialvideoview
Read more
  • Published in Access 2013, Access 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365
No Comments

Wildcard Characters in Access- Tutorial

Thursday, January 26 2017 by Joseph Brownell
Wildcard Characters in Access: A picture showing wildcard characters used for query criteria in Access.
Wildcard Characters in Access: Overview             You can use wildcard characters in Access to add an additional level of flexibility to your query criteria. Wildcard characters within query criteria in Access represent unknown values. The asterisk “*” and the question mark “?” are the two main wildcard characters in Access
accessaccess 2010access 2013Access 2016addasteriskcriteriadesigndesign querydesign viewfind unknown charactershelphow-toinsertinstructionslearnlessonMicrosoft Accessms accessoverviewQBEqueriesqueryquery builderquestion markteachtrainingtutorialusevideowildcard charactersWildcard Characters in Access
Read more
  • Published in Access 2010, Access 2013, Access 2016, Latest, Microsoft, Office 2010, Office 2013, Office 2016, Office 365
No Comments

Aggregate Function Queries in Access – Tutorial and Instructions

Tuesday, November 08 2016 by Joseph Brownell
Aggregate Function Queries in Access - Tutorial: A picture of a user selecting an aggregate function to perform within a query in Access 2016.
Aggregate Function Queries in Access: Overview             You can create aggregate function queries in Access that perform a mathematical function on another grouped field in a query. Aggregate function queries in Access are usually shorter queries often used for summary totals in reporting.             For example, if you want to know the sum of sales
accessaccess 2013Access 2016aggregateAggregate Function Queries in Accessaggregate functionscoursedesign querydesign viewfunctionfunctionsgroupgroup bygroupinghelphow-toinstructionslearnlessonMicrosoft Accessms accessoverviewqueriesqueryself studysummarizesummaryteachtotaltrainingtutorialvideo
Read more
  • Published in Access 2013, Access 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365
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

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

Recent Posts

  • Void a Check in QuickBooks Desktop Pro - Instructions and Video Lesson: A picture of a user voiding a check in QuickBooks Desktop Pro.

    Void a Check in QuickBooks Desktop Pro- Instructions and Video Lesson

    How to Void a Check in QuickBooks Desktop Pro: ...
  • Rename List Items in QuickBooks Desktop Pro - Instructions: A picture of a user renaming a list item in the “Item List” in QuickBooks Desktop Pro by using the “Edit Item” window and also merging it with another, existing list item.

    Rename List Items in QuickBooks Desktop Pro – Instructions

    Rename List Items in QuickBooks Desktop Pro: Ov...
  • A picture of a user joining a meeting in Microsoft Teams via a previous meeting chat.

    Join a Meeting in Teams – Overview and Instructions

    Overview There are a few different ways to join...

Categories

Archives

  • GET SOCIAL

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

TOP
Today-Only Coupon! 0 Days 2 Hours 6 Minutes 47 Seconds      Unlock A Better Price!
Ask For Coupon