Create Tables in Access – Instructions

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

Create Relationships in Access – Instructions

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

Create a Query in Access – Instructions

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

Update an Index in Word – Instructions

A picture of a user updating an index in a Word document.
Overview of Updating an Index in Word             You can easily update an index in Word. You can update an index in Word after altering content in a document that contains an index. Doing this then lets you refresh its display, versus recreating the entire index.             An index in Microsoft Word is simply a
Read more
No Comments

Create a Database in Access – Instructions

A picture of the window that appears after you create a new blank database in Access.
Overview             You can easily create a database in Access. When Access opens, it shows the “Home” window, which lets you either create a new database file or access a previously opened database. An Access database file is a container that holds all the tables, forms, reports, queries, macros, and modules required by the database.
Read more
No Comments

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

Track Meeting Attendance in Outlook- Instructions

A picture of a meeting organizer tracking meeting attendance in Outlook.
Overview of How to Track Meeting Attendance in Outlook             You can track meeting attendance in Outlook if you are the person who created the meeting request. Since you are the meeting organizer, the meeting automatically appears in your Calendar. To check the status of the meeting’s attendees in Outlook, double-click the meeting in your
Read more
No Comments