Access writes daily statistics 200 yuan

by canddy on 2007-02-25 16:41:17

Task Description: Daily Statistics Compilation in Access

**Reward Amount:** 200.00 CNY

**Start Time:** January 29, 2007, 00:00:00

**End Time:** February 8, 2007, 00:00:00

**Task Requirements:**

1. **Piecework Statistics for Workers:**

- Calculate the piecework statistics for 3 types of workers. Each type of worker has a different payment method, and each product has a different unit price.

2. **Daily Cash Flow Statistics:**

- Record and calculate the daily cash flow.

3. **User Authorization and Registration:**

- Implement a user authorization system with different permissions for managers and operators.

4. **Automatic Data Backup:**

- Ensure that the data can be automatically backed up.

5. **Daily Mandatory Registration:**

- Require daily registration. Without registration, users will not have permission to proceed with other operations.

6. **Various Statistical Categories:**

- Labor usage statistics

- Time usage statistics

- Cumulative product statistics

- Product classification statistics

- Inventory statistics for product inflow and outflow

- Statistics by different time periods (e.g., morning, afternoon, evening)

- Financial statistics including loans and borrowings

**Development Requirement:** The program must be written using Microsoft Access.