VB Web Database Application using Access

The deliverables should give a good idea of what is needed. Complete and functional code is a MUST in addition to the deliverables listed. For detailed deliverables, please contact the buyer. ## Deliverables CSoftware requirements: Use Visual Studio and Access. [login to view URL] MS Access database that keeps track of signed agents/resellers, deals, and commissions. [login to view URL] members must be able to enter the following information for a deal on a single form in the database. The fields in yellow should be marked as ‘required’ entry fields:Date Rec’d,Customer name, Agent or Reseller?, Agent/Reseller Name,Account Manager,Product,Port Speed,Total MRR(Monthly Recurring Revenue),Local Loop MRR,Total NRC’s,Total Contract Value,Term,Notes(Promo Price, Special Requests etc.),ORB required?,If ORB and approved, PM assigned?,Date Given to Order Entry,Req’d Install Date,Order Entry in Vantive,SVS#,Site ID,Release to Network,Release Date,FOC Date,FOC Complete Date,Actual Install Date,Install complete date,Status 3. The database should be able to generate an excel report or a report in a list format that lists all of the above fields for all deals-to-date in date ascending order with headings. A method should be provided for me to be able to upload this said list from Excel into the Access database and over-write all of the non-required fields for individual deals. [login to view URL] database needs to be able to compute commissions at two levels, and generate reports for: o Account Manager: Paid on month-to-date booked revenue. Percentile of commission will be provided. Automated monthly records of commissions paid once a magic ‘final monthly approval’ button is hit need to be created in a separate table. I should be able to go to this table to see what an account manager was paid in any month/year, and be able to compute group totals. I also need a way to add new employees to the account manager list. Special Requirement: If an ‘install complete date’ has not been populated within 90 days of a deal being marked ‘paid’, then a re-computation needs to occur for the last 3 months to see if the commission tier would have been different, and if different, there needs to be a chargeback reflected on the report. When this occurs, the deal needs to be marked ‘not paid’ and should figure in future month’s commission tiers whenever the ‘install complete date’ is populated. There also needs to be a provision to ‘cancel’ a deal, i.e. hold it in booked MRR numbers, but mark it as not-payable for commission. Agents: All deals marked ‘Agent’ need to be commissioned. A flat percentile rate should be automatically assigned to a deal based on the revenue being billed that month. It is assumed that revenue is being billed if an ‘install complete date’ is present in the deal record. This rate will carry for the term of the deal. A ‘commission paid for the term of the deal’ number should be able to generate at that point. A monthly commission no. should then be generated by adding commissions on individual deals. Deals are only paid for the term: 12, 24, or 36 months. So they should fall off the ‘to-be-paid’ list when the said number of months have been paid. The first ‘payable’ month will start when the ‘install complete date’ field has been populated. A # of months remaining record should also auto-update. Like account manager commissions, an auto-generated record should be created when the magical ‘final monthly approval’ button has been hit that records billed MRR tier, # of deals being paid on, and commission paid this month, and cumulative per agent. Special Requirement: There also needs to be a provision to ‘cancel’ a deal, i.e. hold it in booked MRR numbers, but mark it as not-payable for commission. [login to view URL] database should have password-restricted access at three levels: Administrator,Account Manager, and Agent/Reseller [login to view URL] database should be searchable deal name, agent/reseller name, and account manager name. [login to view URL] project should present the following: Authenticated access to user specific information including deals closed, date closed, MRR, product, term, all ‘non-required’ fields listed above, commission earned/deal and more. ## Deadline information Code must be tested and implemented without any bugs by January 18th, 2002.