Microsoft Office Tutorials and References
In Depth Information
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 (deﬁ 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 ﬁ eld, and then
move the PropertyType ﬁ eld so that it appears between the Sleeps and Description
ﬁ elds. Make sure that the PropertyID ﬁ eld is speciﬁ ed as the table’s primary key.
7. Change the following properties:
a. PropertyID: Change the data type to Text, change the ﬁ 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 modiﬁ ed table and then display it in Datasheet view. Resize all datasheet
columns to their best ﬁ 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.
Design for the Reservation table
Caption = Reservation ID
Caption = Guest ID
Caption = Property ID
Caption = Start Date
Caption = End Date
Number of people in the party
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 ﬁ elds to a custom format that displays dates in
a format similar to 11/23/13. Save and close the Reservation table.
12. Grifﬁ n exported the reservation data that he was maintaining in another computer
system to a text ﬁ 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 ﬁ le (located in the
Access1\Case4 folder provided with your Data Files).
a. Specify the Bookings text ﬁ 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 ﬁ t (as necessary), and
then save and close the table.