Even though I'm the wrong side of Cemetary Hill I joined the computer
revolution and taught myself Excel.
My hobby is Horse Racing and I had been keeping the results in an Excel
File. However that has grown to a huge spreadsheet and I found it very
hard to learn how to extract the information needed.
I therefore tried to learn Access but am finding it very difficult to
understand in places in particular keys and relationships. Below are the
tables. the HORSE table has ID as primary key but after that I'm at a
loss trying to decide primary and foreign key connections between
tables.
I would appreciate your advice.
Many Thanks
Davey H
RESULTS DECS HORSE
RaceNo 466066 466080 RaceNo 1
HORSEID HORSE Course DONC NEWB Course
ASCO 1 A B Celebration Date 21-Oct-11
21-Oct-11 Date 1/1/2011 2 A Boy
Named Suzi Rtime 15:45 16:05 Rtime 14:00
3 A P Ling Go GD GF Go GD
4 A Pocketful Of Rye (IRE) Age 4 4 Furs
6 5 A Southside Boy (GER) Furs 6 10
Class 4 Class 2 4
Prize 1111 Prize £11,450
£4,528 Horse A P Ling
Ran 22 15 Pos
1 1 Drw 20
14 RACES Btn 2.25
0.1 RaceNo 466066 466080 466067 466081
466068 TBtn 2.25 0.1 Course DONC
NEWB DONC NEWB DONC Horse Bohemian Melody
Jiwen (CAN) Date 21-Oct-11 21-Oct-11 21-Oct-11
21-Oct-11 21-Oct-11 Wgt 122 129
Rtime 15:45 16:05 16:20 16:40 16:55 OR 91 83
Go GD GF GD GF GD GRD 105 81
Age 4 4 4 3 4 WA 4 8 Furs
6 10 14.6 8 10.3 AA 0 0
Class 2 4 4 5 4 PPL 2.95 1.77
Prize £11,450 £4,528 £4,528 £2,588 £4,528
RAW 102 85 Ran 22 15 18 12 19
RAWadj 88 82 BHB 105 81 84 75 85
BHB 107 81 WA 4 8 0 9 7
BHBadj 89 70 AA 0 0 0 2 0
HEAL 98 78
ORADJ 80 72
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar