Hotel Management System Ms Access Database Project

Want to develop a hotel management system ms access database project ?

Or need ms access project help from me ? If yes then you are at right place. I am here to help you in ms access database projects.

Management systems word is quite common now a days and every knows how its works and what is the purpose for developing these types of softwares or web application.

Without these types of softwares we can not imagine our system to run successfully, because storing database in a file with the help of pen is a very old thing. Thats why there are so many systems available in the market which can be buy or person have option to develop a customised software/web application according to their requirements.

Which Kind of database help I provide-

Need ms access project help, ms access assignment help, ms access homework help or best ms access project ideas or database project ideas ? Please fill the contact form and get instant help from me.

  • Drop files here or

    This post is regarding Hotel Management System ms access database project, after reading this post you will get a lot of idea regarding ms access database and you can create ms access database project easily if you will give some effort.

    Hotel Management System ms access database project details

    I have attached the complete screenshots of hotel management system ms access database project, here in this project I have implemented all possible operations and modules which must have to be in management system project.

    Here you can see, how I performed relational database operations to connect tables logically, and a beautiful and fully professional UI is there.

    What is Hotel Management system ?

    If we are going through only sentence that is Hotel Management System, every thing is looks clear means a system which manage all the things in the hotel. Now my topic is Hotel management system database project so now it is more clear that here I am talking about managing the database of a hotel.

    It can be customer record, employee record, manager record, customer history, customer booking and so many things which are related to database.

    What is database management system ?

    Database management system means managing data with computer software and interaction with users, systems and database to analyse the data.

    This is very broad  field and any organisation will be incomplete without these types of system.

    Hotel management System database project will also having a lot of functions to manage the data and I am going to explain all important scenario regarding Hotel Management System ms access database project .


    What the important things created in the ms access database project.


    1- Tables

    2- Queries

    3- Forms

    4- Reports

    Tables which I added in Hotel Management System Database project using ms access

    1- CheckIn/CheckOut table

    In this table you can see all checkout and checkin details of customer with their particular id’s that is checkin and checkout id with number of days stayed by in the hotel.

    2- Customer Record Table

    In customer record table, first column comes with the customer id that is unique id, by making these types of id’s recognising customer becomes very easy, like just enter the customer id and you will get all the history of the customer.

    In this table you can add all the details of the customer like Name, gender, contact number, address and other important information.

    3- Rooms Record/Detail Table

    Room Record table will store the record of rooms like room Id, Room No., category of the room that can be Deluxe/Normal or any other category which you can add, you can add price and description of the rooms, like if the room is Deluxe then which type of facility you are giving.

    4-Switch Board Table

    In switchboard table you can add a list of all the details in the table like Main SwitchBoard, Customer List, Room  Availability, Check In/Check Out, Password Change potion with there proper arguments.

    switchboardtable copy

    5- Users Table

    Users table is defining the category of users and their types with there proper authentication password. here You can list the name of the users with there password so they can access the system according to their authority.

    For example you see the below table where user Andrew has the username Andrew and his type is admin so his category belongs to admin and he had a password by which he can access the system.

    Note- Dividing the users of the any system is the very-2 important task because of the system is depends on the users so which user have which type of authority, its matter so much for the system.

    Now the table part is completed and I had shown all the possible table which I added in Hotel Management System Database Project Using ms access.

    You can add more tables here according to your need, like if you creating any big database so you need to add more tables here.

    One important thing I want to say here, creating tables in any database in not a hard task because you just have to create the columns and fill the values, but task becomes hard while managing the table, making joins between the tables creating keys and relation between the tables.

    So try to store the data in easy manner so accessing data will be also easy and you can make database very simple.

    Now I am coming in the next part of this ms access database project that is queries part.

    Here I will show my added queries in this project but before entering in this part firstly we have to know what is a query ?

    I know all of you know aware about the query and if you are going to work with database then you must know about the queries because without the queries we can not imagine a database system or any kind of database management system project.

    What is a query in database?

    Queries are a type of mechanism which are used to retrieve the information from any database system.

    Example select em_id from em_table;

    This is a sql database query. Working with queries in ms access is more easy if we compare it with other database technologies.

    To set queries in ms access database you just have to click in the particular table and then go on the menu and you will see the create option click there, after clicking there you will get many options, for creating the queries in ms access just click on query design option from there you can set queries easily according to your requirements.

    Here I had added three queries first one is for Bill second one is for MaxCheckIn and last one is for UserExtended.

    Now we completed with the query part of this project and coming with the very important portion of the ms access database project, that is form creation part.

    From which I added in Hotel management System database project 

    I had added so many forms here and tried my best to give the attractive look to them, because GUI should be attractive and its gives the best experience to the user to use the application.

    So before creating the forms, you just have to do some very basic research like GUI should be related to your project title and it should have to give the feel of the project.

    Color combination and image formation should be taken care of while creating the forms because its matter a lot. By choosing a good color and image formation you can make your form more and more attractive.

    Main Screen of the application/Switchboard

    This is the main switchboard of the system, from this screen we can enter in the system to complete our task.

    You can see options here

    1- Customer List

    2- Room Availability

    3- Check In

    4- Check Out

    5- Change Password

    6-Exit

    Other options are also there you can see for logout and for selecting users, while clicking in the users you will see a list of user with there proper username and type of user.



    Login Form

     


    This is the screenshot of login form which I created, from this board a user can enter their particular user name and password to enter in the system. When a user enters the username and password it will check the values in the table and after authentication it will allow user to enter in the system or in the database.

    You can create your own login form and make it more attractive.

    Screen For changing the password



    This screen will allow user to change their password if they want, for doing this they just have to enter their current password, then new password after that they have to confirm their new password, while doing this password will be updated in the database a user can login with their new password.

    This is not a very complex task, it can be completed very easily. You can put some more conditions for changing the password but be sure long form makes system complex.

    Customer Details From


    This screen will store the customer details like their name, gender, mobile number and all the personal information of a customer.

    Here you can see a button save and exit, from this button you can save the entered record in customer record table. Here you can also see the option of notes where you can write any extra thing regarding the customer or any special notes you want to add here.

    Customer CheckIn Form


    This form is for customer checkin details, whenever a new customer will arrive at the hotel, creating checkIn id is very essential . Here you can give the options to select the name of the customer and choose room number which you want to allot to the particular customer after that system will show room information like type of the room and price of the room.

    Now you have to enter number of person who are going to stay in the room, date of checkin and date of checkout.

    CheckOut From

     

    This form will print the checkout details of the customer, it will include customer name, room details, number of person stayed in the room, check in check out dates along with charges,

    Once you review the form there is button named bill, while clicking on that you can see the final bill.

    It will show the summary of room history with all the required details and total stay charges along with tax and other details which you want to add.

    Room Availability Screen

     This screen is for checking the room availability, from here you select the room type after that you will see particular room is available or not with the price of the room.

    While making this form you can add description about room, so it will be easy to check the specification about the room and explaining it to the customer will becomes very easy.

    User Details screen

    This screen will allow to create a new user, from here you can create a admin or a new user with entering the details of the user, i.e. first name, last name, user name, password and also the category of the user.

    From here you can define an user is normal user or an admin.

    After that click on save and new button so record will be saved in the database and new user will be created.

    I am not sharing all screenshots of this ms access project because there is a very long list of it.

    If you want any type of help in ms access project or any other database project, I am excited to help you, just fill this contact form I will contact you within few minutes.

    Leave a Reply