stillthailand.blogg.se - Microsoft access database ideas

This is the idea behind a relational database. To take care of this, we will create a table for When a room has been rented, its occupancy status must beĬhanged to occupied. When a room is not rented, it has the status ofĪvailable. The hoteil has different rooms that are rented orįreed some time to time. Using the Properties window, set its Record Source as BedTypes.To create a form, on the Ribbon, click Create and, in the Forms.In the top section of the window, click under BedType and type Notes.In the lower section of the window, set the Field Size to 25.Right-click BedType and click Primary Key.

Click under Field Type and type BedType and press Tab.

To create a new table, in the Tables section, click the Table Design.

Practical Learning: Creating the Types of Beds Of course, conference rooms do not have a bed. Some customers wants a single room but with different beds. Another category of room uses a king size, which is larger and wider than the queen. The most common bed has a queen size that can serve one or two people. To serve such customers, bedroom have different types of bed. Most of the business of Ceil Inn hotel is based on rooms the customers rent, and most customer rent a room to spend the night.

Using the Properties window, set its Record Source as RoomTypes.

To close and save the table, double-click the Table1 icon.

Press Tab and type m and make sure Memo is selected.

In the top section of the window, click under RoomType and type.

Click under Field Type and type RoomType.

The cabinetsĬontain spoons, forks, knives, and plates.įor our database, we will need a table named Room Has a stove, a refrigerator, a dish washer, and cabinets. To sleep, the room has a telephone (analogue line), a kitchen area that Sofa or recliner, two chairs, a closet, and an iron. A regular bedroom is equipped with one or two beds, one table, one The Ceil Inn hotel offers different categories of

To close and save the table, right-click its title bar and click.

In the top section of the window, click under AccountNumber.

Click under Field Type and type AccountNumber.

This means that, forĪccounting purposes, we will need a unique account number for each renting If the same customer comes to rent a roomĪnother time, a new accuont will be created. When a customer comes to rent a room, an account willīe created for him or her. For ourĭatabase, we will just need each customer's name, the telephone number,Īnd information about a person to contact in case of emergency. Like employees, customers have to be identified.

The customers are the people who rent the rooms that Save the form and switch it to Form View.Design the form approximately as follows:.Using the Properties window, set its Record Source as Employees.To create a form for the room types table, on the Ribbon, clickĬreate and, in the Forms section, click Form Design.When asked whether you want to save the table, click Yes.To close and save the table, right-click Table1 and click Close.Complete the list of fields as follows:.In the top section of the window, click under EmployeeNumber.In the lower section of the window, set the Field Size to.Still selected, in the Tools section of the Ribbon, click the Press Tab and accept its Data Type as Text.Click under Field Type and type EmployeeNumber.To create a new table, in the Tables section, click the Table.Practical Learning: Creating the Employees The person who is creating the record for a new hire. To uniquely identity an employee,Įach one will have an employee number. To keep our implication simple, we will need the In most databases, they are identified with as much Windows), then re-start it and open the CeilInn1 databaseĮmployees are people who will manage all aspects of Have to, but the screen shots in this lesson will use overlapping If you want, close Microsoft Access (you don't really Click Remove Personal Information From File Properties On Save.In the opening window, change the File Name to CeilInn1.We are asked to create a database application that would help the employees of Ceil Inn to manage their business. Depending on the type of room and the bed(s), a certain rate is charged to occupy or use a room. Rooms have different types of bed (queen, double, or king).

The company provides various types rooms (bedrooms, suites, and conference rooms).