Microsoft Office Tutorials and References
In Depth Information
Session 2.2
15. Switch to Datasheet view, and then resize all columns in the datasheet to fit the data.
16. Delete the record with the StudentID value DRI9901 from the Student table.
17. Save, print, and then close the Student datasheet.
18. Close the Recruits database.
Case Problem 1
Data Files needed for this Case Problem: Videos.mdb ( cont. from Tutorial 1 ) and
Events.mdb
Lim’s Video Photography Youngho Lim uses the Videos database to maintain information
about the clients, contracts, and events for his video photography business. Youngho asks
you to help him maintain the database by completing the following:
Apply
Using what you learned
in the tutorial, create
and modify two new
tables containing data
about video photogra-
phy events.
1. Open the Videos database located in the Brief\Case1 folder provided with your
Data Files.
2. Use Design view to create a table using the table design shown in Figure 2-38.
Figure 2-38
Field Name
Data Type
Description
Field Size
Caption
Other Properties
ShootID
Number
Primary key
Long Integer Shoot ID
Decimal Places: 0
Default Value: (blank)
ShootType
Text
2
Shoot Type
ShootTime
Date/Time
Shoot Time
Format: Medium Time
Duration
Number
# of hours
Single
Default Value: (blank)
Contact
Text
person who
booked shoot
30
Location
Text
30
ShootDate
Date/Time
Shoot Date
Format: mm/dd/yyyy
ContractID
Number
Foreign key
Integer
Contract ID
Decimal Places: 0
Default Value: (blank)
3. Specify ShootID as the primary key, and then save the table as Shoot .
4. Add the records shown in Figure 2-39 to the Shoot table.
Figure 2-39
ShootID
ShootType
ShootTime
Duration
Contact
Location
ShootDate
ContractID
927032
AP
4:00 PM
3.5
Ellen Quirk
Elm Lodge
9/27/2006
2412
103031
HP
9:00 AM
3.5
Tom Bradbury
Client’s home
10/30/2006
2611
5. Youngho created a database named Events that contains a table with shoot data
named ShootEvents. The Shoot table you created has the same format as the
ShootEvents table. Copy all the records from the ShootEvents table in the Events
database (located in the Brief\Case1 folder provided with your Data Files) to the end
of the Shoot table in the Videos database.
6. Modify the structure of the Shoot table by completing the following:
a. Delete the Contact field.
b. Move the ShootDate field so that it appears between the ShootType and
ShootTime fields.
 
Search JabSto ::




Custom Search