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

Insert Table Formulas in Word – Instructions

Insert Table Formulas in Word - Instructions: A picture of the default formula that Word suggests in the
Insert Table Formulas in Word: Overview             You can insert table formulas in Word tables to perform simple mathematical functions on data. To insert table formulas in Word that add, subtract, multiply, and divide numbers in the table cells, you insert formulas into cells where you want to show the answers to the mathematical operations
Read more
No Comments

Aggregate Function Queries in Access – Tutorial and Instructions

Aggregate Function Queries in Access - Tutorial: A picture of a user selecting an aggregate function to perform within a query in Access 2016.
Aggregate Function Queries in Access: Overview             You can create aggregate function queries in Access that perform a mathematical function on another grouped field in a query. Aggregate function queries in Access are usually shorter queries often used for summary totals in reporting.             For example, if you want to know the sum of sales
Read more
No Comments

Function Compatibility in Excel – Tutorial

Function Compatibility in Excel - Tutorial: A picture of the “Compatibility” functions in Excel 2016.
Function Compatibility in Excel: Overview             Function compatibility in Excel supports older functions that have been replaced by newer versions of those functions. Starting in Excel 2013, some older formula functions have been replaced with new versions. These replacements occur to increase their accuracy and to better reflect their purpose. These new, more accurate statistical
Read more
No Comments

Create Calculated Columns in Power Pivot in Excel 2016 – Tutorial

Create Calculated Columns in Power Pivot in Excel 2016 - Tutorial: A picture of a calculated column created within the data model window of Power Pivot in Excel 2016.
Create Calculated Columns in Power Pivot in Excel 2016: Overview             This lesson shows you how to create calculated columns in Power Pivot in Excel 2016. You can create calculated columns and measures from the tables shown in the Power Pivot data model to create values within a table which you can then add to
Read more
No Comments

Understanding SQL Functions- Standard Query Language for Databases

To view the complete tutorial, click here             Understanding SQL Functions Functions serve a wide range of purposes within SQL. You can use aggregate functions to perform calculations on grouped values within a query. That is one very common use of functions within SQL. However, there are other types of
Read more
No Comments