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
    • 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 10
  • STICKERS
    • Chrome OS
      • Chrome OS for Chromebooks
    • Mac OS
      • Mac OS Monterey-Mojave
    • 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

Rename a Field in a Table in Access – Instructions and Video Lesson

Friday, September 17 2021 by Joseph Brownell
A picture that shows how to rename a field in a table in Access.
Overview of Renaming Table Fields in Access             You can rename a field in a table in Access that you have already created to change the field’s name. You should be extremely careful when you do this! This is because any changes you make to field names are not necessarily updated in all the previously
accessaccess 2010access 2013Access 2016Access 2019access change field nameAccess for Microsoft 365Access for Office 365access rename fieldchange field name in accesschange the field name in accessclasscoursefieldfieldshelphow to change a field name in accesshow to change field name in accesshow to rename a field in accesshow-toinstructionslearnlessonMicrosoft AccessoverviewrenameRename a Field in a Table in Accessrenamingrenaming table fieldstabletablesteachtrainingtutorialvideo
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

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

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

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 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

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
  • 1
  • 2

 

Recent Posts

  • A picture showing how to cut, copy, and paste files and folders in Windows 11 by dragging and dropping them between File Explorer windows.

    How to Cut, Copy, and Paste Files and Folders in Windows 11 – Instructions

    Overview of How to Cut, Copy, and Paste Files a...
  • A picture showing how to rename files and folders in Windows 11 using File Explorer.

    How to Rename Files and Folders in Windows 11 – Instructions

    Overview of How to Rename Files and Folders in ...
  • A picture showing how to open a file in Windows 11 using File Explorer.

    How to Open a File in Windows 11 – Instructions

    Overview of How to Open a File in Windows 11:  ...

Categories

Archives

  • GET SOCIAL

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

TOP
Sale! $49 All-Access 0 Days 12 Hours 36 Minutes 14 Seconds      $199 $49 Entire Library!
See Deal