Front End and Back End Website Work with Scheduling System

I have uploaded the same video that I am attaching to this in case you don't want to download it. The link is [login to view URL] I have attached my notes with 1 additional thing I want below. ## Deliverables The notes below give an idea of what is contained in the video. On the frontend: Hook up the email form on the homepage so that information entered goes into the database Customer Login Area where they can get access to exclusive pictures and stuff. In this area they should be able to create a profile to give us some information about them. (mainly the stuff that there are fields for in the backend area) but would also like to be able to get other info from them if needed. A Tour Calander that shows when and where the website owner is touring to. Should give the website user the ability to request appointment times. There needs to be an admin page that allows website owner to change tour schedule and input notes and more I will explain inthe video Backend - All inside of the password protected area Text Editing page---------- There is an admin page that allows the website owner to change pictures. I need a page that allows the website owenr to change website text without having to get into the coding. On this page I need the ability to have the title and the metatags of the page edited as well. Appointment reminder------- A system that sends a text message to website owner via email that reminds them when a customer needs a call back or when an appointment is upcoming Admin Login Page--------- Need a Place for the administrator to change login password The Customers List Page--------------------- Need to be able to sort columns without the page dropping the filter Need to make the page limited to like 50 results with multiple pages so it isnt a 400 mile long page. In the type column... The type named contact should be named email signups and the leads should be named Contacts Email------------------ Need an unsubscribe feature so people dont have to send the emails to spam or write to have them removed Email History Page------------------- Right now it shows the email addess and the date an email was sent to all on one page. I would like the page to be links to each individual send that also has a cached copy of the email that was sent. Things NOT mentioned in the video that I want done: When adding information to the clients page or scheduling an appointment, I need a way for the website owner to check and make sure they are not duplicating entries. What I have in mind is an ajax type script that pulls in all of the relevant or semi relevant results (already in the database) to the right. So if in the name field John was typed in, all of the people in the database with the name John would show up on the right and have an option to load that customer and same thing for phone number, email , ect.