| Excel Spreadsheet Form Set Creation (01 September 2010) |
| Data Entry, Editing, Modification, Printing, MS Access, Excel, Form |
Phase 1 1. Using Microsoft 2010 Excel, replicate a ten page hard copy set of State sales tax forms. Two of the hard copy pages are instructional and have no calculations, but need to be viewable in the same relative location as shown on the hard copy forms. 2. This spreadsheet must look exactly like the official sales tax forms. 3. The Excel system must allow the entry of all tax data in cells that represent the fields on the hard copy forms. There is no requirement (in this Phase 1) to create formulas to perform calculations. 4. All text areas of the spreadsheet must be protected so that I do not accidentally alter the form. 5. I have identified one company that has a website showing a similar product. Their product is for the creation of the US Income Tax forms and not my specific sales tax data. http://www.dotxls.com/excel-financial-analysis-software/free-2008-excel-tax-forms-for-april-2009-filing 6. The following State site has a copy of my sales tax book and the specific forms (pages 29 - 38) : http://www.sctax.org/NR/rdonlyres/33D08103-4AD7-46CA-9CFD-5F42DB91E5E2/0/SalesBk.pdf 7. When I complete data entry in the spreadsheet forms, I must be able to print the Excel pages and produce the exact appearance of the State forms. 8. My State forms are printed on both sides to reduce paperwork and handling. Please advise me of how I can best print this computerized set of forms and get them to print front and back. 9. Developer will create a tutorial explaining how the spreadsheet was created and how I can make minor modifications. Phase 2 1. Develop a front end system that allows for the entry, deletion, and edit of detailed sales data. This front end system should be a Microsoft 2010 Access system with the appropriate interface of data to the Excel Spreadsheet. This involves understanding the various tables of tax values and sales tax locations related to South Carolina zip codes. 2. The appropriate totals and detail created in the front end system will then populate the data fields in the Excel spreadsheet developed in Phase 1. 3. The spreadsheet created in Phase 1 will now require the development of the formulas to complete the automation of my sales tax calculations and subsequent printing of the completed State forms. Notes: A. Developer may bid on an individual Phase or both. B. Please show me examples of similar development. |
| Vision Marketing Database (01 September 2010) |
| MS Access, Research, Database, Marketing |
1. Design and Create a Microsoft 2010 Access database. 2. Populate it with the names and related detail of all US organizations, schools, and State agencies that support or are involved with services for low vision and blind people in the US. 3. Populate this same database with names and detailed data for all teachers and counselors for the blind and low vision in US schools (grammar schools through college). 4. The winning bidder will have to research and find all sources for this data. 5. Tell me how you will complete this project. |
| Ms Access Integration To Existing Sharepoint Portal (28 August 2010) |
| Integration, Portal, MS Access, Access, Microsoft Access |
We have an intranet sharepoint portal where in we use to store diffrent projects information in that site.My requirement is to create a local Microsoft Access Database which captures all the information entered in a form . Here is breif description about my requirement. 1) User (Adminstrator) is provided with a form on sharepoint portal which has few fields to store information about a project. Such as Project Name,Description,Resources assigned to that project, Timelines etc. 2) I dont know how and where this data is stored currently now. 3) I need a MS Access Database to be created on a local machine(Administrator's Desktop).When adminstrator enters data into that form and click on save .The data would stored in sharepoint server portal. I want the same copy of that data to be stored.on local MS Access database. 4) Adminstrator would then use that local database to query and generate some reports. Before we pick the winner we will requiere a POC which should include estimated cost and time required for each milestone. To make sure that you read this completely. Include ACCESSHARE keyword while you bid. I will only consider bids which has this keyword. |
| Pick Box Inventory (11 August 2010) |
| MS Access |
Stone Edge Order Manager currently reduces warehouse inventory for each sale. I need to have a pick box inventory( quantity) that is also reduced with each sale so a pick box replenish report can be made. And pick box quantities also manually changed. |
| Simple Poker Application For W 2 (09 August 2010) |
| MS Access, Visual Basic, Programming, Flash, Application |
i need an application much similar to this one on the web: www.cardplayer.com/poker-tools/odds-calculator/texas-holdem this can be a flash or even on MS excel don't mine. am not looking for something fancy .. just plan cards are fine. It's important that the cards are displayed by manual imputing .eg type KH,1S, 8C ect.. kh = king of hearts 1s= ace of spades 8c=8 of clubs |