In MS Access, functions like Exp() and Count() play vital roles in data manipulation and analysis. The Exp() function is used for mathematical computations, specifically to calculate the exponential value of a number, where e (approximately 2.718) is raised to a specified power.

In this article, We will learn about the Exp() and Count() Functions in MS Access with the help of various examples.

MS Access Exp() Function

• In MS Access, the Exp() function returns e (the base of natural logarithms) power raised to a number.
  
• In this function, a number will be passed as a parameter and will return e raised to the power of a specified number.
  
• e is a constant whose value is equal to 2.718281. It is the base of natural logarithms.

Syntax

Exp(number)

Parameters:

• number: The exponent to which e is raised. It can be a literal number, a column containing numeric values, or an expression that evaluates to a numeric value.

Examples of MS Access Exp() Function

Let's take a look at some of the basic examples of Exp() Function in MS Access.

Example 1:

SELECT Exp(6) AS ExpNum;

Output:

Example 2:

SELECT Exp(1) AS ExpNum;

Output:

MS Access Count() Function

• In MS Access, The Count() function returns the total number of eligible records of a query.
  
• When a query expression is performed with the help of count function then it will count total records and return that total count number.

Note: Null values will not be included in the count.

Syntax

Count(expression)

Parameters:

• expression: The expression to be counted. This can be a column name or an asterisk (*) to count all rows.

Examples of MS Access Count() Function

Consider an example for Demo Database given below with the Table name, "Stu_Details".

CREATE TABLE TestResults (
    TEST_ID INT,
    USER_ID VARCHAR(10),
    MARKS INT
);

INSERT INTO TestResults (TEST_ID, USER_ID, MARKS) VALUES
(101, 'GFG_1', 67),
(102, 'GFG_2', 89),
(103, 'GFG_3', 35);

Created Table:

Example 1:

SELECT Count(*) AS TOTAL FROM Stu_Details;

Output:

Example 2:

Output:

SELECT Count(*) AS TOTAL FROM Stu_Details
WHERE MARKS>50;

Output:

Exp() vs Count() functions in MS Access

Conclusion

The Exp() and Count() functions in MS Access serve different purposes but are both crucial for data analysis. The Exp() function helps with complex mathematical computations, while the Count() function is invaluable for statistical summaries of database records. Understanding how to use these functions effectively can significantly enhance your ability to manage and analyze data in MS Access.

vipinyadav15799

Follow

Improve

Article Tags :

• SQL
• Databases
• DBMS-SQL