Lesson 4th create database design with SQL Language in Ms.Access 2003

1.  Open your Ms.Access and create database: hotel.mdb
2.  Create the 1st table with SQL language in SQL Query: Room
Select Query below The Tables
Double click and right click then select SQL VIEW
3. Then You can write the SQL language to make the Room table
The SQL Statement Is:

4. Fill the Table with this

The SQL Statement Is:
Then click Yes.
Repeat for the 2nd record
5. Then add 1 filed :
The SQL Statement Is:


6. Update all the facility with ="AC" like this
The SQL Statement Is:



6. Update all the facility with ="AC, Double Bed" for the 2nd record
The SQL Statement Is: