Changing the Inbox View in Outlook – Instructions

Changing the Inbox View in Outlook - Instructions: A picture of the “Manage All Views” dialog box in Outlook.
Changing the Inbox View in Outlook: Overview Changing the Inbox View in Outlook by Selecting a Different, Existing View             By changing the Inbox view in Outlook, you can organize your email to better suits your individual needs. The first step in changing the Inbox view in Outlook is to
Read more
No Comments

Create a Calculated Field in Access – Instructions

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

Hide a Query Field in Access – Instructions

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

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

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

How to Use the ORDER BY Clause in SQL

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

Sort a Query in Access – Instructions

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

Create Input Masks in Access – Instructions

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

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