Microsoft Office Tutorials and References
In Depth Information
Case Problems
4. Save the Teacher table. Click the Yes button when a message appears indicating
some data might be lost.
5. In the datasheet, resize the Takes Beginners column to best fi t, and then specify
that the following teachers can take beginners: Schwartz, Eberle, Norris, Tanaka,
Culbertson, and Mueller.
6. Save and close the Teacher table.
7. Yuka created a table named Student in the Music database that is located in the
Access1\Case1 folder provided with your Data Files. Import the structure of the
Student table in the Music database into a new table named Student in the Pinehill
database. Do not save the import steps.
8. Open the Student table in Datasheet view, and then add the following two fi elds to
the end of the table: BirthDate (Date/Time fi eld) and Gender (Text fi eld).
9. Use the Phone Quick Start selection in the Data Type gallery to add four fi elds
related to phones between the Zip and BirthDate fi elds. ( Hint: Be sure to make the
BirthDate fi eld the active fi eld before adding the new fi elds.)
10. Display the Student table in Design view, delete the BusinessPhone and FaxNumber
fi elds, and then save and close the Student table.
11. Modify the design of the Student table so that it matches the design in Figure 2-47,
including the revised fi eld names and data types.
Figure 2-47
Field properties for the Student table
Field Name
Data Type
Description
Field Size
Other
StudentID
Text
Primary key
7
Caption = Student ID
LastName
Text
25
Caption = Last Name
FirstName
Text
20
Caption = First Name
Address
Text
35
City
Text
25
State
Text
2
Zip
Text
10
HomePhone
Text
14
MobilePhone
Text
14
BirthDate
Date/Time
Format = Short Date
Caption = Birth Date
Gender
Text
F(emale), M(ale)
1
12. Move the LastName fi eld so it follows the FirstName fi eld.
13. Save your changes to the table design, add the records shown in Figure 2-48 to the
Student table, and then close the Student table.
Figure 2-48
Records for the Student table
Student ID
First Name
Last Name
Address
City
State
Zip
Home Phone
Mobile Phone
Birth Date
Gender
APP7509
Sam
Applegate
15675 SW Greens Way
Portland
OR
97224
503-968-2245
503-968-0091
10/10/1996
M
BAR7544
Andrea
Barreau
7660 SW 135th Ave
Beaverton OR
97008
503-579-2227
503-579-8754
11/28/1999
F
14. Yuka exported the student data that she was maintaining in another computer system
to a text fi le, and she asks you to add this data to the Student table. The data you
need to import is contained in the Student text fi le (located in the Access1\Case1
folder provided with your Data Files).
a. Specify the Student text fi le as the source of the data.
b. Select the option for appending the data to the table.
Search JabSto ::




Custom Search