Need a program to create bar code labels for inventory being received. More specifically, need:
1. MS Access 2003 database to hold basic info to be included on bar code label (SKU plus 2 lines of label info). Will need to be able to import data from Excel, ability to add, modify and delete entries and ability to search for entries.
2. Currently have MS Access report generated when inventory is received, but need to modify this report to capture SKU and quantity received and write this info to a file rather than printing a report. Current report includes one record for each SKU being received, so if 2 are being received, there are two records. Need report to only have SKU and total quantity received. Remainder of data for labels to come from database described in step 1.
3. Starting with info from step 2, look up info from database in #1 above and create file that has basic label info and number of labels to print for each SKU. If any label info is missing, need to be able to notify user and get that info added before next step.
4. Format info from step 3 to be imported into Avery Design Pro software (free label printing software) to print labels.
## Deliverables
See more detailed specs in file attached