Microsoft Office Tutorials and References
In Depth Information
Review Assignments
Review Assignments
Practice the skills
you learned in
the tutorial using
the same case
scenario.
Data Files needed for the Review Assignments: Supplier.accdb ( cont. from Tutorial 1 )
and Goods.xlsx
In addition to tracking information about the suppliers Belmont Landscapes works with,
Oren also wants to track information about their products. He asks you to create a new
table in the Supplier database by completing the following steps:
1. Open the Supplier database, which you created and stored in the Access1\Review
folder in Tutorial 1.
2. Open the Company table in Design view, and set the fi eld properties as shown in
Figure 2-43.
Figure 2-43
Field properties for the Company table
Field Name
Data Type
Description
Field Size
Other
CompanyID
Text
Primary key
6
Caption = Company ID
Company
Text
50
Caption = Company Name
Product
Text
40
Caption = Product Type
Address
Text
35
City
Text
25
State
Text
2
Zip
Text
10
Phone
Text
14
ContactFirst
Text
20
Caption = Contact First Name
ContactLast
Text
25
Caption = Contact Last Name
InitialContact
Date/Time
Format = Short Date
Caption = Initial Contact Date
3. Save and close the Company table. Click the Yes button when a message appears
indicating some data might be lost. Switch to Datasheet view and resize columns, as
necessary, to their best fi t. Then save and close the Company table.
4. Create a new table in Design view, using the table design shown in Figure 2-44.
Figure 2-44
Design for the Product table
Field Name
Data Type
Description
Field Size
Other
ProductID
Text
Primary key
4
Caption = Product ID
CompanyID
Text
Foreign key
6
Caption = Company ID
ProductType
Text
35
Caption = Product Type
Price
Currency
Format = Standard
Decimal Places = 2
Color
Text
15
Size
Text
15
Material
Text
30
Weight
Number
Single
Caption = Weight in Lbs
Discount
Yes/No
Caption = Discount Offered
Format = Yes/No
5. Specify ProductID as the primary key, and then save the table as Product .
6. Modify the table structure by adding a new fi eld named Unit (data type: Text, fi eld
size: ) between the Price and Color fi elds. Move the Size fi eld so that it follows the 15
Material fi eld.
7. Enter the records shown in Figure 2-45 in the Product table. When fi nished, close
the Product table.
 
Search JabSto ::




Custom Search