Microsoft Office Tutorials and References
In Depth Information
Case Problems
c. Select the option button to import tables, queries, forms, reports, macros, and
modules into the current database, and then click the OK button.
d. In the Import Objects dialog box, click Rentals, click the Options button, and
then make sure that the correct option is selected to import the table’s data and
structure (defi nition).
e. Do not save your import steps.
5. Right-click the Rentals table in the Navigation Pane, click Rename on the shortcut
menu, and then enter Property as the new name for this table.
6. Open the Property table in Design view, delete the VIP Program fi eld, and then
move the PropertyType fi eld so that it appears between the Sleeps and Description
fi elds. Make sure that the PropertyID fi eld is specifi ed as the table’s primary key.
7. Change the following properties:
a. PropertyID: Change the data type to Text, change the fi eld size to , and enter 4
Property ID for the caption.
b. PropertyName: Enter Property Name for the caption.
c. NightlyRate: Enter Nightly Rate for the caption.
d. PropertyType: Enter Property Type for the caption.
8. Save the modifi ed table and then display it in Datasheet view. Resize all datasheet
columns to their best fi t, and then save and close the table.
9. Use Design view to create a table using the table design shown in Figure 2-57.
Figure 2-57
Design for the Reservation table
Field Name
Data Type
Description
Field Size
Other
ReservationID
Text
Primary key
3
Caption = Reservation ID
GuestID
Text
Foreign key
3
Caption = Guest ID
PropertyID
Text
Foreign key
4
Caption = Property ID
StartDate
Date/Time
Caption = Start Date
EndDate
Date/Time
Caption = End Date
People
Number
Number of people in the party
Integer
Rate
Currency
Rate per day; includes any discounts or promotions
Format = Currency
Decimal Places = 0
Caption = Rental Rate
10. Specify ReservationID as the primary key, and then save the table as Reservation .
11. Refer back to Figure 2-14 to review the custom date formats. Change the Format
property of the StartDate and EndDate fi elds to a custom format that displays dates in
a format similar to 11/23/13. Save and close the Reservation table.
12. Griffi n exported the reservation data that he was maintaining in another computer
system to a text fi le, and he asks you to add this data to the Reservation table.
The data you need to import is contained in the Bookings text fi le (located in the
Access1\Case4 folder provided with your Data Files).
a. Specify the Bookings text fi le as the source of the data.
b. Select the option for appending the data to the table.
c. Select Reservation as the table.
d. In the Import Text Wizard dialog boxes, choose the option to import delimited
data, to use a comma delimiter, and to import the data into the Reservation table.
e. Do not save the import steps.
13. Resize columns in the Reservation table datasheet to their best fi t (as necessary), and
then save and close the table.
Search JabSto ::




Custom Search