Assignment 2

In your DPS folder, create a folder called UNIT 1

In this new folder create another new folder called HOCKEY

Create a new database called Bayridge Hockey Team

Using the Design View include the following fields

Filename	Type	Properties
PlayerID	AutoNumber	<no changes>
FirstName	Text	Field Size = 10
LastName	Text	Field Size = 15
ShirtNum	Number	Field Size = Byte; Format=General Number; Deicmal Places = 0
Address	Text	Field Size = 50
City	Text	Field Size = 25
PostaICode	Text	Field Size = 7
Phone	Text	Field Size = 13
DateOfBirth	Date/Time	<no changes>
DateHired	Date/Time	<no changes>
Salary	Currency	Decimal Places = 2
Note	Memo	<no changes>

The Primary field is the PlayerID field

Use the Insert Rows icon to add the Field POSITION before the field ADDRESS.

Save the table with the name PlayerInfo

Record #1 FIRSTNAME LASTNAME SHIRTNUMBER POSITION ADDRESS CITY POSTALCODE PHONE DATEOFBIRTH DATEOFHIRE AMOUNT NOTE	Luc Tremblay 23 wing 1530, rue De l'Entente Montreal D7F 8G0 514-233-3345 2/23/1974 9/23/1974 256.3 right handed	Record #2 FIRSTNAME Claude LASTNAME Benoit SHIRTNUMBER 12 POSITION wing ADDRESS 220, Dorchester Blvd. CITY Montreal North POSTALCODE H3G 9D9 PHONE 514-654-7656 DATEOFBIRTH 9/3/1978 DATEOFHIRE 1/24/1990 AMOUNT 325.54 NOTE good wrist shot
Record #3 FIRSTNAME Jean-Marc LASTNAME Perron SHIRTNUMBER 44 POSITION centre ADDRESS 23, Stanley St. CITY Montreal, North POSTALCODE G2L 4D4 PHONE 514-555-7777 DATEOFBIRTH 12/4/1980 DATEOFHIRE 3/30/1996 AMOUNT 180.34 NOTE in great physical condition		Record #4 FIRSTNAME Eric LASTNAME Roy SHIRTNUMBER 30 POSITION goalie ADDRESS 300, Dupas St. CITY Quebec City POSTALCODE F9G 7F2 PHONE 418-450-5434 DATEOFBIRTH 5/30/1973 DATEOFHIRE 10/2/1990 AMOUNT 300.12 NOTE very quick glove hand

Record #5 Record #6

FIRSTNAME Yvan FIRSTNAME Barney

LASTNAME Dube LASTNAME Rubble

SHIRTNUMBER 89 SHIRTNUMBER 3

POSITION defence POSITION centre

ADDRESS 45, Laval St. ADDRESS 103 Bedrock Lane

CITY Montreal CITY Bedrock

POSTALCODE H8V 7B4 POSTALCODE R5T 6Y7

PHONE 514-356-8951 PHONE 123-321-4321

DATEOFBIRTH 8/1/1975 DATEOFBIRTH 11/16/1960

DATEOFHIRE 4/28/1991 DATEOFHIRE 7/7/1986

AMOUNT 356.45 AMOUNT 120.34

NOTE solid checker NOTE Crumbles under pressure

Record #7 Record #8

FIRSTNAME Christian FIRSTNAME Fred

LASTNAME Champagne LASTNAME Flintstone

SHIRTNUMBER 11 SHIRTNUMBER 55

POSITION wing POSITION defence

ADDRESS 304, de la Curonne St. ADDRESS 101 Bedrock Lane

CITY Quebec City CITY Bedrock

POSTALCODE G5T 6Y8 POSTALCODE R5T 6Y7

PHONE 418-456-3421 PHONE 123-123-1234

DATEOFBIRTH 3/2511969 DATEOFBIRTH 1/2/1954

DATEOFHIRE 8/31/1987 DATEOFHIRE 4/5/1980

AMOUNT 234.56 AMOUNT 546.54

NOTE very fast skater NOTE solid as a rock

Record #9 Record #10

FIRSTNAME Luc FIRSTNAME Super

LASTNAME Charbonneau LASTNAME Man

SHIRTNUMBER 87 SHIRTNUMBER 57

POSITION centre POSITION centre

ADDRESS 1222, Sirois St. ADDRESS 912 Galaxy Way

CITY Montreal, North CITY Krypton

POSTALCODE G5Y 7J8 POSTALCODE K7M 5T7

PHONE 514-456-9876 PHONE 613-456-4665

DATEOFBIRTH 11/17/1970 DATEOFBIRTH 1/6/1971

DATEOFHIRE 2/29/1984 DATEOFHIRE 7/3/1996

AMOUNT 427.00 AMOUNT 899.00

NOTE assist leader NOTE so fast he flies

Record #11 Record #12

FIRSTNAME Craig FIRSTNAME Spider

LASTNAME Stuart - LASTNAME Man

SHIRTNUMBER 22 SHIRTNUMBER 77

POSITION defence POSITION goalie

ADDRESS 1495, Lajoie St. ADDRESS 123 Web Lane

CITY Quebec City CITY Kingston

POSTALCODE H7Z 3R8 POSTALCODE K8J 8S1

PHONE ' 418-345-6542 PHONE 613-845-1654

DATEOFBIRTH 12/12/1971 DATEOFBIRTH 10/19/1970

DATEOFHIRE 9/3/1994 DATEOFHIRE 9/9/1995

AMOUNT 345.54 AMOUNT 321.56

NOTE needs to improve his skating skills NOTE Messes up the net with his webbing

Record #13 Record #14

FIRSTNAME Wayne FIRSTNAME Brett

LASTNAME Gretzky LASTNAME Hull

SHIRTNUMBER 99 SHIRTNUMBER 9

POSITION centre POSITION goalie

ADDRESS 999 Blue Line Lane ADDRESS 123 No Score Dr.

CITY Montreal CITY Toronto

POSTALCODE G9R 9E9 POSTALCODE M7M 5T5

PHONE 999-999-9999 PHONE 419-562-8996

DATEOFBIRTH 9/9/1969 DATEOFBIRTH 10/15/1978

DATEOFHIRE 9/9/1990 DATEOFHIRE 12/30/1993

AMOUNT 999.99 AMOUNT 245.67

NOTE over paid NOTE would be more successful as a centre

Add 2 more records. Your name being one of them and a fictitious other person. Do not use a shirt number that has already been used.