The project requires to develop a database application. Using Access development tools. The system should also provide an end user with a friendly user interface. The project should include a cover page, table of contents, an overview of the application, end-user documentation, the database schema, portions of the project code, and good system documentation. A Computerized Management/Accounting Tool for a Courier Company Key Areas: Design Aspects, Statistics, Financial Systems, MIS, Databases The system will be based around a central database containing details on Customers and Drivers, and Vehicles. This information together with data gathered from job sheets will enable the Company to : 1. Keep a detailed record of Customers Accounts, who pays on time, which customers appear to be in growth/decline, etc. 2. Which services are in growth/decline ([url removed, login to view] or Parcel). 3. Incentive/Reward schemes can be considered for both drivers and customers. 4. Accurate financial reports can be used to encourage investment. Also: Tables' design of all tables Tables' optimization Entity relationship diagrams for your DBMS Scenario build-ups for program interaction Reports to provide a history of user interaction with the system Multiple look up queries to permit individuals and managers to search the database information based on simplex or complex queries Multiple DML (Data Manipulation Language) Queries to populate and update the DBMS Data Definition Language (DDL) to create Tables on Demand for outstanding funds that are scheduled but not collected. Ad hoc reports medium for external users to find the occupancy status and calendar for a day, a week and a month within the schedulers. An embedded SQL queries to prevent individuals from being overlooked. The DBMS should be provided with a list of commands that are stored in a table with time factors (granularity down to a second of time) associated for each command or event (group/sequence of multiple commands). The program should run the commands sequentially based on the commands or events found in this table but should take care of simultaneous transactions in case two commands are associated with the same time stamp.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
MS ACCESS 2000 and up