Supplier Data Collection.ppt

Supplier Data Collection SDC SDC SDC 1. Background I have worked in SQE Dept for more than 8 years, find the things are quite similar. I tried to summary what I have done in the past, the software can help the small team To share update the information between each other. However, Current revision still not add in a system to include all SQE works, only List a few tables. System Requirements: 1.Microsoft .Net Framework 2.0 () 2.Creat folder at D:\data\, copy SDCdata.mdb to that folder Basic Knowledge: The search/add function was completed through SQL command, then you can’t use ‘ or “, such as “He get Lee’s book on 23’Jun’2007” are not acceptable. SDC 2. Overview Menu Items Background image Weather Forecast Time Zone SDC 3. Setting 1. Click “About” menu, then click “Setting” at the dropdown menu, can display the setting option The software will link to the nearest site (Suzhou) for update, Then also make same update to Far site (Singapore) Gadget is used to display Weather Forecast, Time Zone Can set Main Form’s background image SDC 4. Table Structure 20. Project *Critical lookup table *Vendor Code is the critical parameter that used to link other tables *DCC Folder is the absolute link *Pic1,Pic2,Pic3 is the relative link, can used to display the photos *Attachment1,Attachment 2 is the relative link, can put any type documents Photos/Attachment will copy to foldadd SDC 5. How to Add a record in those tables Click “Add” Menu, then click the tables which you want to update, will display the Add record Form Key in these black border textbox, will lookup Table 7 to avoid mis-type Left double click these black border box, Will display the file/folder browser After key in necessary info, click “Add” Button to add the record SDC 6. How to Search a record in those tables Click “Search” Menu, then click the tables which you want to update, will display the Search record Form Key in these black border textbox, will lookup Table 7 to avoid mis-type Left double cl