I have a specific project that may require a couple of different skills.
Approximately 3 web pages need to be designed to add to an existing site that need to be accessed through a secure customer login. The first page is a page where my customers can basically design and save the products I sell. There will be five drop-down boxes and each box has approximately 8 options. When the first box is selected, a specific picture will be selected from a database and shown beneath. The second and third boxes do the same. When an option in the fourth and fifth boxes is selected, it will change the font and font color of text on top of the picture created below. This information needs to be saved to a database or added to a shopping cart.
The next page is basically a search page for the jobs designed on the previous page, with a couple of different was to sort and search.
The last page is a pretty traditional shopping cart. The main caveat is that there has to be a way to either show the prices or not, depending on if the customer is present or not.
Create art (VBA)
The next need is to take the few parameters from the order created above and create the art. This is actually pretty simple since the art is already created and must simply be retrieved and the text changed. The art is in CorelDraw (which uses VBA) and a particular file will be opened and the text in the file replaced with text from the order (usually just initials). This is then saved as a .jpeg. This is basically the same thing being done in the web application, just higher res with more precision.
Printer Interface (xml order processing)
My printer has customers that send orders automatically through xml order processing. I don't know much about this but the printer says it's pretty straight forward.
Ideally, a file would be created that could be uploaded to Quickbooks to place in Quickbooks all of the orders placed each day, or more frequently. This doesn't need to be too fancy but I don't know how.
Access and SQL
Perhaps the jobs created from the Web interface can go to a SQL database (doesn't have to be, am open to ideas). So, I would need a pretty simple Visual Basic front end application to see the orders in house and do some rudimentary tracking.
I have a little more detail if you need it but that is a pretty detailed version of what I need. If you can do parts of this but not all (especially the Quickbooks stuff since that isn't that well known), I would be happy to entertain that since there are various skills required here. I'm looking to start this asap. Thanks.