Microsoft Office Tutorials and References
In Depth Information
Session 2.2
Case Problem 4
Data Files needed for this Case Problem: GEM.mdb ( cont. from Tutorial 1 ), Property.xls,
and Reserve.mdb
GEM Ultimate Vacations Griffin and Emma MacElroy use the GEM database to track the
data about the services they provide to the clients who book luxury vacations through
their agency. You’ll help them maintain this database by completing the following:
Challenge
Explore two new ways to
create tables containing
property rental informa-
tion—by importing an
Excel worksheet and by
entering records first in
Datasheet view.
1. Open the GEM database located in the Brief\Case4 folder provided with your Data Files.
2. Use the Import Spreadsheet Wizard to create a new table named Property . The data
you need to import is contained in the Property workbook, which is a Microsoft
Excel file located in the Brief\Case4 folder provided with your Data Files.
a. Select the Import Table option in the New Table dialog box.
b. Change the entry in the Files of type list box to display the list of Excel workbook
files in the Brief\Case4 folder.
c. Select the Property file and then click the Import button.
d. In the Import Spreadsheet Wizard dialog boxes, choose the Sheet1 worksheet;
choose the option for using column headings as field names; select the option for
choosing your own primary key; specify PropertyID as the primary key; and enter
the table name ( Property ). Otherwise, accept the wizard’s choices for all other
options for the imported data.
3. Open the Property table and resize all datasheet columns to their best fit.
4. Modify the structure of the Property table by completing the following:
a. For the PropertyID field, enter a Description property of “Primary key”, change the
Field Size property to Long Integer, set the Decimal Places property to 0, and set
the Caption property to Property ID.
b. For the PropertyName field, change the Field Size property to 45, and set the
Caption property to Property Name.
c. For the Location field, enter a Description property of “Province, city, county”, and
change the Field Size property to 35.
d. For the Country field, change the Field Size property to 15.
e. For the NightlyRate field, change the Data Type to Currency, set the Format property
to Currency, set the Decimal Places property to 0, and set the Caption property to
Nightly Rate.
f. For the Bedrooms field, enter a Description property of “Number of bedrooms”,
change the Field Size property to Integer, and set the Decimal Places property to 0.
g. For the Sleeps field, enter a Description property of “Number of people who can
be accommodated”, change the Field Size property to Integer, and set the Decimal
Places property to 0.
h. For the PropertyType field, change the Field Size property to 20, and set the
Caption property to Property Type.
i. For the Description field, change the Data Type to Memo.
j. Save the table structure. If you receive any warning messages about lost data or
integrity rules, click the Yes button.
5. Switch to Datasheet view, and then resize all datasheet columns to their best fit (if
necessary).
6. Use the Property datasheet to update the database as follows:
a. For PropertyID 3395, change the NightlyRate value to $750.
b. Add a new record to the Property table with the following field values:
PropertyID:
Explore
3675
PropertyName:
Casa de Las Palmas
 
Search JabSto ::




Custom Search