5242 Product cost database

I need a Microsoft access 2000 Wizard to implement a sales control database which will base upon supplier contacts, product controls and 2 pricing structures (item true cost & sells tools). Attached is a breakdown of database details for your reference. I will also provide an example database so you can see the flow of product. The database will have three system passwords for 4 different levels of usage. The password should only be changeable thru the system administrator & are not changeable thru any other location. Attached is a database guideline for reference. I have a sample database that has the exact same flow that I can send you as reference as well. 1. Security Levels A) Administrator- full control of database (passwords are only changeable thru this area) B) Manager – Access to Add, Edit, View, System Costing (true cost & sell tools) and all reports. C) Sales – Access to View items & reports D) User – Access to View products & run price list report only. 1. Database Switch Boards A) New Products (Security A & B) B) Edit Products (Security A & B) C) View Products (Security all) D) Append Product Cost (Secutiry A) E) UPC View (Security A & B) F) 12 Reports-same format as example given (Various Security Levels) 11 of the 12 reports have duplicate info & look but each has a different control source. You will most like copy the same report & just change the control source. The last report is a simple excel report of all products. 2. Supplier – include system generated supplier number. 3. Product Controls A) Product Details (First Section or Tab) B) Product Production (Second Section or Tab) C) Product True Cost D) Sales Cost 4. View Products – Product information will be stored from the add & edit fields (Security A & B) will be the only users to view these fields. To View a product will depend on the checked fields below. The Admin or Mgr will be able to click one of these fields below and this will allocate what area the product may be viewed. A) View Product Line B) View GS Products C) View WIP D) View Closeout Items E) Exclusive Items There are several key points that I need to make clear before bid can be accepted. There are several functions that I’m not sure if this is a Microsoft function or if this is a programming function. But we need to make sure the database has these function up front. 1. User can press esc before you exit the item to clear all fields. 2. Product input fill tab in the same order of attached input details. 3. All database properties will be changeable later to the admin. 4. Ability to search content in any product field. 5. Pricing formulas will calculate regardless of missing information. 6. Sorting and grouping options on the report (with & without saving changes. Lastly, this project is very time sensitive. Once you give me a completion date you are expected to stay within that date. Project payments will be in three installments. First one third escrow payment (and released) will be issued once database demo is given on products (advise completion date before bid is considered). Second escrow payment (and release) will be issued after product reports demo is complete (advise completion date before bid is considered). Last escrow payment will be made once project is delivered. The final payment will be release once database has been tested.

Taidot: kaikki käy, Microsoft Access

Näytä lisää: what is database programming, what is cost flow, sell thru report, sell thru, secutiry, search structures, programming in access database, programming control structures, programming access database, product supplier database, product-manager, product costing format in excel, product costing format excel, points that are on the same line, on line supplier, microsoft excel formulas, microsoft access programming, location of escrow, give me your password, give me a new password, flow section, flow of cost, flow cost, excel and access programming, excel add in programming

Tietoa työnantajasta:
( 3 arvostelua )

Projektin tunnus: #1756112