Microsoft Access

Regarding the Microsoft office my frriend shared me the following instruction. I found it useful. The macro progress the the computer world is doing today is galvanizing. Each day comes something new. If you want to keep the record f the total number of hours each employee worked over a deffinite period of time or hours you may follow the following steps by using SQL to summarize quickly to access the data.

Open the database containing the HoursWorked table for the quarter, then click Queries in the objects list in the database window.
Click New, Design View and OK.
Click Close.
Go to Query | SQL Specific | Data Definition.
Enter the following statement:
SELECT DISTINCTROW [HoursWorked].[Employee ID], SUM([Hours Worked].Hours) AS [Sum of Hours]
FROM [Hours Worked]
GROUP BY [Hours Worked].[Employee ID];
Click Run.
I'm sure you will find it useful