پروژه اکسس(24905)*

شرح پروژه

سلام وقتتون بخیر  برای پروژه دانشجویی اکسس میخواستم بپرسم، چقدر زمان و هزینه داره؟  
Hotel Management System

The challenge for our final project will be creating the database side of a system to manage hotel bookings.
Here are the core tables (bare minimum to accomplish the task) you must create:

Clients, Room, Employees, Bookings
Beware you may or may not need to create additional tables if the relationship requires. Talking about relationships,
here are the relationships you must address on your database:
• Clients can book rooms to stay for a period of time
• Employees can work on cleaning many rooms based on their schedule
Data
What type of information you should save? Below are some ideas on what to save, but don’t be limited by this, feel free
to include additional information if you feel it’ll help the data relevance.
Clients – client number, first and last name, their contact information and perhaps their address.
Room – room number, room type, price, special comments
Employees - employee number, first and last name, job title, department, etc.
Bookings – aside from all FKs required from the relationship, you should also save: date in which the reservation was
made, the check-in and check-out date (you can consider that the hotel has policy for check-in and check-out time, so
you don’t need to worry about the time, only the date.), total price, payment type, any additional information you
believe it’s important to record about the reservation itself.

You must enter plenty of information on your database so we can have data to use on the queries.

 At least 20 entries for
each table (employees can be half – 10 entries).


Forms
Create one form for each entity that requires updating on your database.
Create a navigation form so database users can easily navigate through the forms
Queries/Reports
All queries will be created and transformed into reports:

• Clients and their reservation information, including room characteristics – Report should display the list grouped
by room type
• Clients that will check-in today – Report should display all guests arriving today to the hotel regardless of when
the database is opened. Booking and Room info should also be displayed
• Same report as the one above; however, for customers checking-out today instead
• A list of today’s employees schedule and which rooms they have cleaned or will clean. Report must display the information grouped by job status (scheduled, canceled, completed, etc.)

Extra Form
• Create a blank form in which you can display the name of all available reports and an option to save it as a PDF

(using report operations – send report to file).
3209*

مهارت ها و تخصص های مورد نیاز

درباره کارفرما

Hamyarprozhe

عضویت سیزده سال پیش

56341 پروژه ثبت شده ،

30 پروژه در حال انجام ،

106 پروژه آماده دریافت پیشنهاد ،

نرخ پذیرش پیشنهاد 16%