I would like someone to build a database using MS-Access 2003 that shall have the following functionality.
The functionality is as following
1- Link from Excel sheet to take the codes of handsets and accessories into the access database.
a. This shall only take new codes and add them into the database and should not duplicate existing handsets
b. The Excel sheet might have much information, upon which only the needed information should be extracted and linked.
2- The Access database screen shall have the following interfaces
a. Handset Data Entry: Where we can enter the data, however, from point 1 above, the database should look for an Excel sheet to update the codes of the item; other information should be entered manual.
i. Item Code
ii. Item brand name (Combo box with a list of brand name of phone manufacturer)
iii. Item description: max of 6 lines
1. This shall be selected from a future check list and then automatically entered as text into the description field.
iv. Handset pricing: should be allocated from the Excel sheet
v. Handset picture: should allow the link the item to the picture in an allocated directory for handset pictures.
b. Printing button, where it should print to the default/selected printer with a specific sized paper (paper is not A4 size, it is a customized sized paper, plush it has some margins and graphical layout, by which all the above information in 2.a point should be printed.
c. Check list of selecting a group of handsets/item to be selected for batch printing.
d. Reporting mechanism, which shall show
i. Exciting models in stock
ii. Comparing models by features.
25 freelancers are bidding on average $665 for this job
Hi I am a software professional with more than 6 years of experience and during this time developed many Access database like this. I can do this for you. Thanks
Hi !! I have done similar kind of work for several cellular service provider franchisee in my city. Please check your Private Message for more details from my explanation. Thanks & Regards fuchsiasoft
InfogateSoftware is the only ISO 9001 certified company listed here. We are in the field since 1998. We had done 200+ projects in past 6 months. We had gone through your requirements and can do it quite comfortably.