Microsoft Access 2007 Driven Website
I am a school photographer. I need a web site that allows the customer to be able to see and order pictures and pay for them securely on line. I need each customer to only be able to see their own pictures.
I am a photographer of children. I photograph children at day care centers. I am using a Microsoft access 2007 database that I created to manage the bookings and pictures that I have with day care centers in my area. The main Relevant tables that are in use are as follows.
Schools- this table maintains information about the schools that I do business with each school has a unique school id number
Bookings- this table manages the bookings that I have upcoming and past. Each booking has a unique booking id. Each booking is linked to a specific school.
Pictures- this table actually holds embedded copies of the pictures. The pictures are compressed using an active X control called DBPix that makes the file size very small. Each record in this table is linked to a specific booking. In the pictures table two copies of the pictures are there. One is a thumbnail (very small file size) that would be appropriate to place on line. I have a automated batch uploader that uploades the pictures into the database very quickly. This may be appropriate to use again if re-uploading the pictures to the web site is necessary. I hope re-loading pictures is not necessary.
Sittings- This table holds the sitting numbers of all potential sittings. A sitting is defined as a number that groups a series of pictures together. I take approximately 6 pictures of each child.
I use the primary key/auto number settings to give a new number for each child photographed.
Example: Johnnys sitting id is 567. All pictures of johnny in the pictures table have the same sitting id of 567. This indicates that all pictures with the sitting id of 567 are all associated with Johnny as opposed to Suzie. Johhny and Suzie go to the same day care center. They will share the same booking id but not the same sitting id. This is how I tell Johnny and suzie apart.
Orders this table holds information that an order has been made and customer information. It is linked to a specific booking.
Order details This table holds information about what exactly has been ordered. The picture selected and the product (portrait package) selected. This table is linked to a specific order.
Software: windows vistas and Microsoft access 2007, Dbpix
What I need:
I need a website built so that I can sell my portraits to parents. I want parents to be able to go on line and enter the booking id and the sitting id of their child (I will provide parents with this information). I need a web based solution to use my exsisting database information to provide parents with the ability to buy on line. I am willing to move the database to some secure location on line. The database is currently on my computer in my office. I currently have a web location for this project reserved with 1and1.com.
I would like the web site to populate data directly into my exsisting database. I would like to host the exsisting database on a secure server on line somewhere. I only want this option if it can be done cheaply and easily.
Other considerations: I need the data to be encrypted so the customer can enter credit card information securely . I need the information e-mailed to me after the customer makes the order on line. I will process credit card orders by hand. I want to be able to easily control when pictures for a particular booking are available and when they are no longer available through a quiere of available pictures. I will mark them available or unavailable based on the bookings table. I want an error message to pop up if a customer enters the booking id and sitting number of an unavailable picture. I want the error message to say “these pictures may not be available, please call 301-292-8386 for further information”
Other preferences: I have no particular preference for the program that is used to make the site. I need the data driven part only. I will add all of the creative parts (colors and visual effects) to the web site at a later date.
The customer should see the following pages each page should have a next button to go to the following page.
1. A start page-a place to enter the booking id and the sitting id so that the correct child can be viewed. Include a place for an embedded youtube video that I will make to explain what to do.
2. The pictures page-A page that shows all of the pictures (in a specific sitting) and the price list.
Below each picture a place for a parent to use a drop down list to select what portrait package is desired. This area should have the ability to accept several different photo package selections for each individual picture. Simply put you should be able to order several different packages for each image. It should include a delete button to delete an entry.
4. Order info page-this page should include fields from the orders table and should include parent name, address, phone number etc.
5. Review Your order-this page should show what was ordered
6. Payment Page- this page should include payment information using fields from the orders table. The order should not be saved unless every field is filled in.
7. Thank you page- this page should simply thank the customer and tell when pictures will be shipped. It should include a button that allows the customer to print a receipt of the order.
After an order is placed the site should send an e-mail to the customer thanking them for the order.
Included is a copy of the database for your review. It contains limited data