Aggregate Function Queries in Access – Instructions

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.            
Read more
No Comments

Buy Access 2019 and 365 Training – Product Release

A picture of TeachUcomp, Inc.’s “Mastering Access Made Easy v.2019 and 365” training interface for digital downloads and DVDs.
Buy Access 2019 and 365 Training – Now Available from TeachUcomp, Inc.             TeachUcomp, Inc. is pleased to announce you can now buy Access 2019 and 365 training with the release of our “Mastering Access Made Easy v.2019 and 365” training tutorial. This tutorial provides training on using the Microsoft Access software program. This comprehensive
Read more
No Comments

Open a Group Calendar or Notebook in Outlook – Instructions

Open a Group Calendar or Notebook in Outlook - Instructions: A picture of a user opening a group calendar in Outlook.
Overview of How to Open a Group Calendar in Outlook             To open a group calendar in Outlook, select the name of the group in the Folder Pane in Outlook. Then click the “Calendar” button in the “Group Name” button group (where “Group Name” is the name of your Group) that appears on the “Home”
Read more
No Comments

Open a Group in Outlook – Instructions

Open a Group in Outlook - Instructions: A picture of a user opening a group in Outlook.
Open a Group in Outlook: Overview             This lesson shows you how to open a group in Outlook. Groups allow you to work with a team of people within your organization. The group shares a group email address, can share files using OneDrive, and share a group calendar. Groups are available with Microsoft 365 (formerly
Read more
No Comments

Buy Microsoft Access Quick Reference Cards

Buy Microsoft Access Quick Reference Cards at TeachUcomp, Inc.             You can buy Microsoft Access quick reference cards with our “Access 2019 Introduction Quick Reference Guide” cheat sheet. Our Microsoft Access quick reference card helps both experienced users and new students by providing quick tips for common, introductory-level activities. This Access quick reference card is
Read more
No Comments

Use Data Entry Forms in Access- Instructions

Use Data Entry Forms in Access- Instructions: A picture of the “New (blank) record” button within a data entry form in Access.
Use Data Entry Forms in Access: Overview             After creating data entry forms, you can use data entry forms in Access to edit, create, and navigate table records. Navigating within a data entry form is exactly like navigating through records in the datasheet view of a table.             You can use the “Tab” key on
Read more
No Comments

Use the Field List in Access – Instructions

Use the Field List in Access - Instructions: A picture of the Field List in Access.
Use the Field List in Access: Overview             You can use the Field List in Access to easily add data fields to a data entry form. Most forms are connected to an underlying table or query from which they display and/or update the table data. In form design view, you can access the list of
Read more
No Comments

The DROP Statement in SQL – Tutorial

The DROP Statement in SQL - Tutorial: A picture of the general syntax of the DROP DATABASE, DROP TABLE, and TRUNCATE TABLE commands in SQL.
The DROP Statement in SQL: Overview             You use the DROP statement in SQL to delete created database objects. You can use the DROP statement in SQL to delete databases, tables and indexes. You can also use the DROP statement in SQL in conjunction with the ALTER TABLE statement to delete fields
Read more
No Comments