Bd Hotel 2.mdb

Affiliates: 1,72 $ — how to earn
Pay with:
i agree with "Terms for Customers"
Buy this item cheaper:
Sold: 11
Refunds: 0

Uploaded: 09.07.2016
Content: Гостиница 2003.rar (209,22 kB)

Description

Bd Hotel 2.mdb Bd Hotel 2.mdb

Bd Hotel 2.mdb

Download the report on the database screen forms for free http://access.avorut.ru/1/251_gostinica/251_otchjot_bd_gostinica.doc

Note: If the yellow Message Bar appears when you open a file, you must click on "Enable Content" button.

Additional information

Task for the database "Hotel" in access. (version 2)

Description of the subject area
You work in a hotel. Your task is to monitor the financial side of the hotel. Your activity is organized as follows: the hotel provides rooms to customers for a certain period. Each room is characterized by capacity, comfort (luxury, junior suite, ordinary) and price. Your clients are different persons about whom you collect certain information (name, first name, middle name and some comment). The delivery of the number to the client is made in the presence of available seats in the rooms, suitable for the client according to the above parameters. When settling, the settlement date is fixed. When leaving the hotel, the release date is memorized for each place.
Tables
Clients (Customer code, Last name, First name, Patronymic, Passport data, Comment).
Rooms (Room code, Number, Number of people, Comfort, Price).
Settlement (Settlement code, Customer code, Number code, Date of settlement, Date of release, Note).
The development of the formulation of the problem
It is necessary to store information not only on the fact of putting the number to the client, but also to book the rooms. In addition, for regular customers, as well as for certain categories of customers, a system of discounts is provided. Discounts can be added up. Add changes to the table structure that take into account this fact, and modify existing queries. Add new queries.

2. Hotel
Description of the subject area
You work in a hotel. Your task is to track the financial side of its work. Your activity is organized as follows: the hotel provides rooms to customers for a certain period. Each room is characterized by capacity, comfort (luxury, junior suite, ordinary) and price. Your clients are various persons about whom you collect certain information (name, first name, patronymic and some commentary). The delivery of the number to the client is made in the presence of available seats in the rooms, suitable for the client according to the above parameters. When settling, the settlement date is fixed. When leaving the hotel, the release date is memorized for each place.
Task for creating a database in a Microsoft Access environment
The order of the work:
• Selection of the subject area in accordance with the student´s serial number in the journal;
• Analysis of the textual description of the subject area;
• Selection of table structures and their creation;
• Filling data into tables (at least 5 lines in each table);
• Development of user interface. Creating forms;
• Creation of calculated queries;
• Creating output reports.

Feedback

0
No feedback yet.
Period
1 month 3 months 12 months
0 0 0
0 0 0
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.market the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)