Microsoft Office Tutorials and References
In Depth Information
Session 2.2
Location: Mallorca
Country: Spain
NightlyRate: 2500
Bedrooms: 4
Sleeps: 8
PropertyType: Villa
Description: Private estate; multiple terraces; beautiful sea views; pool
c. Delete the record for PropertyID 3503.
7. Print the Property table datasheet, and then save and close the table.
8. Create a new table named Reservation , based on the data shown in Figure 2-41 and
according to the following steps:
Explore
Figure 2-41
ReservationID
GuestID
PropertyID
StartDate
EndDate
People
RentalRate
510
220
3107
5/1/07
5/15/07
6
$1000
503
209
3488
6/12/07
6/19/07
12
$2000
511
201
3142
8/20/07
8/27/07
7
$700
a. Select the Datasheet View option in the New Table dialog box.
b. Enter the three records shown in Figure 2-41. (Do not enter the field names at
this point.)
c. Switch to Design view, supply the table name, and then answer “No” if asked if
you want to create a primary key.
d. Enter the field names and properties for the seven fields, as shown in Figure 2-42.
Figure 2-42
Field Name
Data Type
Description
Field Size
Caption
Other Properties
ReservationID
Number
Primary key
Long Integer
Reservation ID
Format: (blank)
Decimal Places: 0
GuestID
Number
Foreign key
Integer
Guest ID
Format: (blank)
Decimal Places: 0
PropertyID
Number
Foreign key
Long Integer
Property ID
Format: (blank)
Decimal Places: 0
StartDate
Date/Time
Start Date
Format: Short Date
EndDate
Date/Time
End Date
Format: Short Date
People
Number
Number of people
Byte
Format: (blank)
in the party
Decimal Places: 0
RentalRate
Currency
Rate per day;
Rental Rate
Format: Currency
includes any
Decimal Places: 0
discounts or
promotions
9. Specify ReservationID as the primary key, and then save the changes to the table
structure.
10. Switch to Datasheet view, and then resize all datasheet columns to their best fit.
11. Emma created a database named Reserve that contains a table with reservation data
named ReserveInfo. The Reservation table you created has the same format as the
ReserveInfo table. Copy all the records from the ReserveInfo table in the Reserve data-
base (located in the Brief\Case4 folder provided with your Data Files) to the end of the
Reservation table in the GEM database.
 
Search JabSto ::




Custom Search