Sort a Table in Excel – Instructions and Video Lesson

Sort a Table in Excel - Instructions: A picture of the “Sort” dialog box within Excel for Office 365.
Sort a Table in Excel: Overview             You can sort a table in Excel using any of the fields available. Sorting is one of the main reasons that you create tables in Microsoft Excel. It allows you to easily organize information in the table records. By default, Excel can sort alphabetically or numerically in either
Read more
No Comments

Create a Calculated Field in Access – Instructions

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

Changing the Inbox View in Outlook – Instructions

Changing the Inbox View in Outlook - Instructions: A picture of the “Advanced View Settings” 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

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

Rename a Field in a Table in Access - Instructions: A picture of a user renaming a table field in Access.
Rename a Field in a Table in Access: Overview             You can rename a field in a table in Access that you have already created. 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 created objects. This
Read more
No Comments

Hide a Query Field in Access – Instructions

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

Sort a Query in Access – Tutorial

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

Create Input Masks in Access – Tutorial

Create Input Masks in Access - Tutorial: A picture of the “Input Mask Wizard” in Access.
Create Input Masks in Access: Overview             You can create input masks in Access to dictate a pattern used for data entry in selected fields. Access provides an easy step-by-step routine called the “Input Mask Wizard” to do this. The “Input Mask Wizard” helps you apply input masks to selected “text” and “date/time” fields.            
Read more
No Comments