The author of this tutorial narrates about setting up athe database to create a tour calendar. The author creates a simple database with all necessary field in it. These data could be customized. Using the stored procedures the users could retrieve the data. The main objective of this article is to show how to generate a tour calendar which could give all tour dates for a particular date. This article touches up with an additional information about Show Date and Show Time fields also. This article is much useful for those who conducts scheduled events and trips.