Assignment 5

1 Create the following input form for the Playerinfo table. Create a combo box for the position field. Type wing, centre, defence, and goalie in as the options. Save the form as PlayerInfo. When finished, add the 4 records shown below the form.

Record #17 FIRSTNAME Tony LASTNAME Sandusky SHIRTNUMBER 73 POSITION defence ADDRESS 1495, Lajoie St. CITY Quebec City POSTALCODE H7Z 3R8 PHONE 418-345-6542 DATEOFBIRTH 12/12/1972 DATEHIRED 9/3/1994 AMOUNT 245.54 NOTE needs to improve his shooting skills	Record #18 FIRSTNAME Conrad LASTNAME Porchenko SHIRTNUMBER 40 POSITION goalie ADDRESS 341 Fluer Blvd. CITY Quebec City POSTALCODE H7J 8R7 PHONE 418-757-7377 DATEOFBIRTH 1/9/1970 DATEHIRED 10/3/1997 AMOUNT 245.67 NOTE fast glove hand
Record #19 FIRSTNAME Will LASTNAME Nestor SHIRTNUMBER 88 POSITION centre ADDRESS 123 Flagler St. CITY Montreal, North POSTALCODE G9R 6Y7 PHONE 454-366-8844 DATEOFBIRTH 04/06/1978 DATEHIRED 12/12/1990 AMOUNT 123.43 NOTE hustles!	Record #20 FIRSTNAME Steven LASTNAME Lofter SHIRTNUMBER 2 POSITION wing ADDRESS Apt #4, 332 Slater St. CITY Ottawa POSTALCODE J7T 5K5 PHONE 419-389-6149 DATEOFBIRTH 10/5/1980 DATEHIRED 12/3/1998 AMOUNT 188.89 NOTE needs lots of work