1
00:00:01,010 --> 00:00:05,200
folks taxes twenty thirteen tutorials macedo only talking use a comma boxes

2
00:00:05,200 --> 00:00:06,610
and datasheets

3
00:00:06,610 --> 00:00:09,579
uh... drove little uh...

4
00:00:09,579 --> 00:00:14,399
followed the link below to go to another section website and download

5
00:00:14,398 --> 00:00:17,989
which is called exercise that indeed it is for it

6
00:00:17,989 --> 00:00:21,548
uh... she's being playing a long way from the start

7
00:00:21,548 --> 00:00:25,808
do the best

8
00:00:25,809 --> 00:00:28,400
psych ward within the last video

9
00:00:28,399 --> 00:00:31,009
recreated this query

10
00:00:31,009 --> 00:00:32,679
bookings extended

11
00:00:32,679 --> 00:00:36,390
amber folks in on coca tonight in this field

12
00:00:36,390 --> 00:00:38,310
tenors bit confusing

13
00:00:38,310 --> 00:00:40,280
uh... there was a bit confused as to life

14
00:00:40,280 --> 00:00:43,300
if you've look at the uh...

15
00:00:43,299 --> 00:00:45,189
state-run behind it

16
00:00:45,189 --> 00:00:48,798
that's a little bit confusing cigarette careful make sure it is correct

17
00:00:48,798 --> 00:00:50,450
and not for that

18
00:00:50,450 --> 00:00:54,920
well-adjusted ended today scurrying a datasheet from cree booking

19
00:00:54,920 --> 00:00:56,690
xx stranded

20
00:00:56,689 --> 00:01:03,299
uh... anamensis creative straight away

21
00:01:03,299 --> 00:01:05,149
casino net going to create

22
00:01:05,150 --> 00:01:08,290
all forms and their shape

23
00:01:08,290 --> 00:01:09,900
and we get up

24
00:01:09,900 --> 00:01:12,000
pretty much exactly the same xquery

25
00:01:12,000 --> 00:01:13,730
worker to save it

26
00:01:13,730 --> 00:01:14,719
and korea

27
00:01:14,719 --> 00:01:16,849
form

28
00:01:16,849 --> 00:01:19,559
uh... bookings extended

29
00:01:19,560 --> 00:01:23,670
two yes

30
00:01:23,670 --> 00:01:25,579
so here's the thing

31
00:01:25,579 --> 00:01:28,118
obviously biggest issue we got was this

32
00:01:28,118 --> 00:01:32,170
datasheet for the moment is to get started in the room i think

33
00:01:32,170 --> 00:01:35,030
such as friday's not actual

34
00:01:35,030 --> 00:01:39,640
nine zero save as per usual i_d_'s a grade for access to pat frost so reagan

35
00:01:39,640 --> 00:01:41,819
at drove this form into design dude

36
00:01:41,819 --> 00:01:45,019
ocd

37
00:01:45,019 --> 00:01:47,209
uh... we're going to

38
00:01:47,209 --> 00:01:50,879
purcell click on the labels guest just change it against them separately from

39
00:01:50,879 --> 00:01:54,239
camilla rem intranets removed

40
00:01:54,239 --> 00:01:58,560
and we're going to do it ranged combo box here

41
00:01:58,560 --> 00:02:02,769
elsa change it exports to accommodate so they just click on a right-click

42
00:02:02,769 --> 00:02:04,429
and uh... change too

43
00:02:04,430 --> 00:02:06,040
comic books

44
00:02:06,040 --> 00:02:10,959
and december for mighty change the comparables

45
00:02:10,959 --> 00:02:14,639
we're still figure to date issued

46
00:02:14,639 --> 00:02:16,289
to crumble tomorrow

47
00:02:16,288 --> 00:02:17,569
who haven't given it

48
00:02:17,569 --> 00:02:22,090
or total really wants gets information from members still only story in number

49
00:02:22,090 --> 00:02:25,889
throwback to the monies for for censorship took longer party

50
00:02:25,889 --> 00:02:29,230
go to the property shapes not their process for

51
00:02:29,229 --> 00:02:30,688
ted data

52
00:02:30,688 --> 00:02:33,338
and we're gonna get uh... buddies you won't from

53
00:02:33,338 --> 00:02:38,579
uh... table guests particulate runs salsa clicking on the three docks

54
00:02:38,579 --> 00:02:41,599
uh... if they will cast their

55
00:02:41,598 --> 00:02:43,968
we won't get started

56
00:02:43,968 --> 00:02:44,848
uh...

57
00:02:44,848 --> 00:02:47,399
because you are first and last night a guest for dinner

58
00:02:47,400 --> 00:02:49,549
to a bit more concatenation

59
00:02:49,549 --> 00:02:50,808
by going

60
00:02:50,808 --> 00:02:53,778
coca-cola uh... futurist

61
00:02:53,778 --> 00:02:58,808
corazon has cast

62
00:02:58,808 --> 00:03:01,370
i would say lost nine

63
00:03:01,370 --> 00:03:03,308
ampersand

64
00:03:03,308 --> 00:03:09,558
uh... a quotation mock almost place close with a schmuck ampersand

65
00:03:09,558 --> 00:03:13,818
firstline

66
00:03:13,818 --> 00:03:17,868
source ending

67
00:03:17,868 --> 00:03:19,250
another so yet

68
00:03:19,250 --> 00:03:23,049
a list of all the guests last name first first and last

69
00:03:23,049 --> 00:03:27,409
and now for the court upside down

70
00:03:27,408 --> 00:03:29,269
but still

71
00:03:29,269 --> 00:03:31,179
chiropractor

72
00:03:31,179 --> 00:03:34,979
was still only showing the mighty of the guest for not showing

73
00:03:34,979 --> 00:03:38,209
the um... action nine sister of former

74
00:03:38,209 --> 00:03:40,109
cocktail

75
00:03:40,109 --> 00:03:44,009
and then the say one com a four in column widths

76
00:03:44,008 --> 00:03:46,208
so now right click on it

77
00:03:46,209 --> 00:03:49,739
you can see that we've got to feel sick with the idea to get a few we've got the

78
00:03:49,739 --> 00:03:52,118
cat's name here

79
00:03:52,118 --> 00:03:53,449
and dubbed

80
00:03:53,449 --> 00:03:55,239
what we wanted to is

81
00:03:55,239 --> 00:03:58,588
get rid of the society we want to call it looks a story which is really

82
00:03:58,588 --> 00:04:00,299
important we don't see it

83
00:04:00,299 --> 00:04:02,338
so again the best of both worlds stand

84
00:04:02,338 --> 00:04:06,308
uh... until a week and that is just go back to the column widths and make the

85
00:04:06,308 --> 00:04:07,558
first

86
00:04:07,558 --> 00:04:08,658
column

87
00:04:08,658 --> 00:04:10,668
zero seven days

88
00:04:10,669 --> 00:04:13,459
so then we get

89
00:04:13,459 --> 00:04:15,558
and now

90
00:04:15,558 --> 00:04:18,838
fact one of the guests were sitting there name rather than

91
00:04:18,838 --> 00:04:20,218
the uh...

92
00:04:20,218 --> 00:04:22,449
value of theology

93
00:04:22,449 --> 00:04:26,228
that's the dentist want and i will do exactly the same reverend so we can come

94
00:04:26,228 --> 00:04:27,728
to the practice

95
00:04:27,728 --> 00:04:31,779
click on the marty we've already change it so commonplace scott at data

96
00:04:31,779 --> 00:04:35,619
caruso stricken the three docks

97
00:04:35,620 --> 00:04:38,459
and we want it wouldn't

98
00:04:38,459 --> 00:04:41,848
cobra marty and room number

99
00:04:41,848 --> 00:04:45,408
sending returning to conquer tonight just want to get that

100
00:04:45,408 --> 00:04:47,199
saved her clothes

101
00:04:47,199 --> 00:04:49,900
yet again storey two-and-a-half

102
00:04:49,899 --> 00:04:51,368
the numbers

103
00:04:51,369 --> 00:04:54,400
sites are we going to need to talk since the designed to

104
00:04:54,399 --> 00:04:58,239
took on the performer conquer too

105
00:04:58,240 --> 00:05:02,379
at the same clinic and one com before in congress

106
00:05:02,379 --> 00:05:03,589
so we've got

107
00:05:03,589 --> 00:05:05,918
dramatically and and number

108
00:05:05,918 --> 00:05:10,918
widow on that we just want to see lumber so transfers quotas are

109
00:05:10,918 --> 00:05:12,120
and that weekend

110
00:05:12,120 --> 00:05:15,259
uh... for her number

111
00:05:15,259 --> 00:05:16,229
uh...

112
00:05:16,228 --> 00:05:20,428
so that's the basic idea behind calmer boxes and datasheets is that you store

113
00:05:20,428 --> 00:05:22,809
in the datasheet the ideas

114
00:05:22,810 --> 00:05:27,360
whilst the foreign key idea called us to cancel and and and the room in this case

115
00:05:27,360 --> 00:05:31,910
they use a comma books that she gets the information u_s_a_

116
00:05:31,910 --> 00:05:32,710
want to go

117
00:05:32,709 --> 00:05:36,969
so use so comes up to his an obvious is if you can see on the cast of her white

118
00:05:36,970 --> 00:05:38,680
to calm the boxes

119
00:05:38,680 --> 00:05:42,199
cc route or change that we can go over here and say well

120
00:05:42,199 --> 00:05:44,499
two guests like the two weeks

121
00:05:44,499 --> 00:05:47,189
nineteen s change that ten

122
00:05:47,189 --> 00:05:50,178
like staying at nine ten

123
00:05:50,178 --> 00:05:53,409
uh... than usual buying a little bit as he was going to go

124
00:05:53,410 --> 00:05:57,778
the reason is so simple design viewed

125
00:05:57,778 --> 00:05:59,689
it's because it's

126
00:05:59,689 --> 00:06:03,908
nineteen seventies what is the estimate this smaller

127
00:06:03,908 --> 00:06:08,228
now it's about false evidence and i would make us more makeup activation

128
00:06:08,228 --> 00:06:10,240
view

129
00:06:10,240 --> 00:06:11,389
sexual conduct

130
00:06:11,389 --> 00:06:14,960
uh... resolve itself

131
00:06:14,959 --> 00:06:19,329
that just uh... co boxes and a sheets just to recap you're gonna store the

132
00:06:19,329 --> 00:06:23,469
heidi's for heidi sanitation anybody's combo boxes to get

133
00:06:23,470 --> 00:06:24,789
information

134
00:06:24,788 --> 00:06:26,839
uh... that we want to say

135
00:06:26,839 --> 00:06:33,099
uh... always bearing in mind that the secret to databases is this they do that

136
00:06:33,100 --> 00:06:34,740
took this access

137
00:06:34,740 --> 00:06:38,838
needs to store which is sort of numbers from the sky gas parties nancy

138
00:06:38,838 --> 00:06:41,110
information which we need to see which is

139
00:06:41,110 --> 00:06:42,460
forgets nine

140
00:06:42,459 --> 00:06:46,859
uh... so give us the video thank you for watching and i should see you next week