1
00:00:00,890 --> 00:00:03,300
hello i'm ok taxes 2013 tutorials

2
00:00:03,299 --> 00:00:07,519
this video is gonna be the first in a series videos discussing continues forms

3
00:00:07,519 --> 00:00:11,468
and we're gonna be using continuous forms where he continues form in a very

4
00:00:11,468 --> 00:00:12,449
specific way

5
00:00:12,449 --> 00:00:15,518
to do a very specific saying for us

6
00:00:15,519 --> 00:00:19,490
in this database so edition of a long follow that blood video to them a

7
00:00:19,489 --> 00:00:22,909
section website and on the Texas 2013 DB 55

8
00:00:22,910 --> 00:00:27,109
and then not in 2013

9
00:00:27,109 --> 00:00:32,599
take password is password

10
00:00:32,598 --> 00:00:38,619
sure you can read Chris what we actually trying to do

11
00:00:38,619 --> 00:00:42,628
that we're gonna need continuous forms for well as you can see

12
00:00:42,628 --> 00:00:46,079
we've got I'll wherein process and making

13
00:00:46,079 --> 00:00:50,039
a database or hotel and we're locking bookings

14
00:00:50,039 --> 00:00:55,198
and if we'd looked she takes pic for can I deal at number nine we can see that

15
00:00:55,198 --> 00:00:58,390
one single booking contains

16
00:00:58,390 --> 00:01:02,170
a multiple rooms so for example booking ID number nine

17
00:01:02,170 --> 00:01:05,409
room 502 I am

18
00:01:05,409 --> 00:01:12,409
was someone checked in on the 30th July and checked out the 25 August

19
00:01:12,540 --> 00:01:15,740
a.m. and is actually two other rooms so say to that

20
00:01:15,739 --> 00:01:18,938
booking wanna do is we want to create

21
00:01:18,938 --> 00:01:22,839
form where we couldn't see

22
00:01:22,840 --> 00:01:26,478
wherever a room is books a specific day

23
00:01:26,478 --> 00:01:30,039
however it isn't but said be a essentially visual representation of the

24
00:01:30,040 --> 00:01:30,680
data

25
00:01:30,680 --> 00:01:34,780
I'm going to be using continuous forms to achieve that

26
00:01:34,780 --> 00:01:38,590
so what we're gonna to in this tutorial

27
00:01:38,590 --> 00:01:44,118
is just gonna create the a very a basic continues for mitch is gonna

28
00:01:44,118 --> 00:01:49,519
contain information about basically each individual room ima gonna

29
00:01:49,519 --> 00:01:52,859
in the future tutorials work from there so

30
00:01:52,859 --> 00:01:55,859
close to the first things first we've got

31
00:01:55,859 --> 00:02:00,409
a query for rooms which is grooms or sending

32
00:02:00,409 --> 00:02:03,659
which is fine takes a rich

33
00:02:03,659 --> 00:02:07,320
we only want to be displaying active rooms

34
00:02:07,319 --> 00:02:10,978
compromise inactive for maintenance reasons so this is

35
00:02:10,979 --> 00:02:14,629
almost a free one so gonna keep my life simple we're going to Kona

36
00:02:14,628 --> 00:02:19,459
actually is checked for a number type question is: fight so we're gonna

37
00:02:19,459 --> 00:02:22,810
click on a control C control face was gonna copier

38
00:02:22,810 --> 00:02:25,900
how gonna call it query rooms

39
00:02:25,900 --> 00:02:30,620
a.m. active scored firms active

40
00:02:30,620 --> 00:02:34,920
easy as pie right and then we're gonna click

41
00:02:34,919 --> 00:02:39,259
on a continuous form now we're continues for more do for clicking clear objective

42
00:02:39,259 --> 00:02:43,348
is actually display every single record

43
00:02:43,348 --> 00:02:46,459
flowing down the page I'm not

44
00:02:46,459 --> 00:02:50,090
in a sense dissimilar to date sheet but you conduct does a lot more

45
00:02:50,090 --> 00:02:51,239
functionality

46
00:02:51,239 --> 00:02:56,340
you can use it for and ralph let me try and explain everything ok just

47
00:02:56,340 --> 00:03:00,580
show you the videos go on so click on clearance active go to create a

48
00:03:00,580 --> 00:03:03,930
anklet call more swarms and

49
00:03:03,930 --> 00:03:08,230
multiple items Texas display multiple items

50
00:03:08,229 --> 00:03:13,649
makeup smaller so as you can see stake in exactly the same information here

51
00:03:13,650 --> 00:03:18,569
basis displayed it animal so traditional form

52
00:03:18,568 --> 00:03:22,658
way sonnets clueless should Sheila

53
00:03:22,658 --> 00:03:26,019
I'm and begin

54
00:03:26,019 --> 00:03:29,920
to he's we r

55
00:03:29,919 --> 00:03:33,139
going to his way gets really good if you

56
00:03:33,139 --> 00:03:36,939
dropped into design view is actually only one

57
00:03:36,939 --> 00:03:40,598
rose information which is the detail section is just

58
00:03:40,598 --> 00:03:43,859
generate at most four times depending on how many records terror

59
00:03:43,860 --> 00:03:47,459
the facts love you which is to confirm it.

60
00:03:47,459 --> 00:03:51,039
range click on Insert below so we can actually

61
00:03:51,039 --> 00:03:54,919
widan share little bit and twosome

62
00:03:54,919 --> 00:03:59,309
interesting stuff down the line as an actress said to the bishop

63
00:03:59,310 --> 00:04:03,209
before we do that let us had some bonds to the top

64
00:04:03,209 --> 00:04:07,810
as a concert in August horizontal split horizontal

65
00:04:07,810 --> 00:04:10,830
to just gonna make

66
00:04:10,830 --> 00:04:15,430
for bonds here so design and just have fun

67
00:04:15,430 --> 00:04:22,430
Ste cancel cancel yet we're gonna cancel that one as well

68
00:04:24,610 --> 00:04:28,270
guess we're gonna do this you can select got F's for

69
00:04:28,269 --> 00:04:33,129
Banco to format and picture

70
00:04:33,129 --> 00:04:37,339
we warn G go to

71
00:04:37,339 --> 00:04:40,959
first this farm

72
00:04:40,959 --> 00:04:44,109
picture we will go to

73
00:04:44,110 --> 00:04:47,270
previous I think or lost

74
00:04:47,269 --> 00:04:52,560
no not lost seasonal go to previous then

75
00:04:52,560 --> 00:04:55,769
there's there it was thirties

76
00:04:55,769 --> 00:05:02,769
this only one go to next

77
00:05:03,899 --> 00:05:07,829
stencils go to last okay I love the song gonna do is gonna make much sense in

78
00:05:07,829 --> 00:05:09,240
this particular video

79
00:05:09,240 --> 00:05:13,840
just bear with me I am but gonna be using these bonds to click through

80
00:05:13,839 --> 00:05:18,310
dates again what dates meaning that new dates so

81
00:05:18,310 --> 00:05:22,978
because I just have to bear with me

82
00:05:22,978 --> 00:05:26,288
to to

83
00:05:26,288 --> 00:05:29,668
to Scotians

84
00:05:29,668 --> 00:05:35,560
now we're going to do is scan had a spitzer

85
00:05:35,560 --> 00:05:39,699
scan had a text books

86
00:05:39,699 --> 00:05:43,990
she's gonna be star today

87
00:05:43,990 --> 00:05:47,259
Ambleside had a text books

88
00:05:47,259 --> 00:05:52,889
there

89
00:05:52,889 --> 00:05:56,538
she's going to be and day and thus make this

90
00:05:56,538 --> 00:06:00,870
lots more

91
00:06:00,870 --> 00:06:04,030
practice law in action

92
00:06:04,029 --> 00:06:08,349
doesn't speak for his wife

93
00:06:08,350 --> 00:06:11,379
passes I okay

94
00:06:11,379 --> 00:06:14,810
%ah so that's a top lines are going to be using

95
00:06:14,810 --> 00:06:18,139
these to give us some or Rangers dates and

96
00:06:18,139 --> 00:06:21,490
start date to the end date we're gonna be using the Cisco free today

97
00:06:21,490 --> 00:06:25,860
X and what we want to do down here

98
00:06:25,860 --> 00:06:31,479
well we're going to I am for Swiss men's room I D down

99
00:06:31,478 --> 00:06:37,089
moving on room number

100
00:06:37,089 --> 00:06:41,750
in there going on tie

101
00:06:41,750 --> 00:06:45,490
in there so moving these labels down into the actual

102
00:06:45,490 --> 00:06:49,639
detail section anything even a detail section or repeat

103
00:06:49,639 --> 00:06:54,379
so for example cost per night at the moment is in the

104
00:06:54,379 --> 00:06:57,788
had two sections that is a new one and a fun movie down here

105
00:06:57,788 --> 00:07:02,019
i gather notes frankly we could get rid of am cashing service

106
00:07:02,019 --> 00:07:05,579
active SLE convertible with that garbage k click on tight

107
00:07:05,579 --> 00:07:09,389
go range insert left click on course tonight

108
00:07:09,389 --> 00:07:12,550
concert left and

109
00:07:12,550 --> 00:07:15,750
cost tonight change it charge

110
00:07:15,750 --> 00:07:20,879
yeah K and

111
00:07:20,879 --> 00:07:25,939
mmm work on those process for

112
00:07:25,939 --> 00:07:30,490
Brougham border-style: transparent

113
00:07:30,490 --> 00:07:34,538
a.m. 2001 by accident gonna

114
00:07:34,538 --> 00:07:38,329
but on this hot links for 12 your to leave the label for a mighty in and

115
00:07:38,329 --> 00:07:39,339
smooth firm idea

116
00:07:39,339 --> 00:07:43,098
here split horizontal

117
00:07:43,098 --> 00:07:46,228
spawned us and just make room

118
00:07:46,228 --> 00:07:50,250
ID visible night

119
00:07:50,250 --> 00:07:56,228
okay say we've done basically what we wanted to do to save time called up

120
00:07:56,228 --> 00:07:59,740
commercial charged

121
00:07:59,740 --> 00:08:05,030
okay so we don't want to do for this video

122
00:08:05,029 --> 00:08:08,198
and on Lost thing

123
00:08:08,199 --> 00:08:12,090
which 1.5 okay so we've got

124
00:08:12,089 --> 00:08:17,549
continues form we wanted now many to do the slightly more difficult thing is

125
00:08:17,550 --> 00:08:18,020
we're gonna

126
00:08:18,019 --> 00:08:22,758
at I'm rather's text boxes up here for Leafs

127
00:08:22,759 --> 00:08:27,389
15 to 20 but nada rose text boxes here

128
00:08:27,389 --> 00:08:31,500
and we're gonna be reading information from the bookings

129
00:08:31,500 --> 00:08:35,500
I'm gonna be looking up whether for example particular day which had been

130
00:08:35,500 --> 00:08:36,950
his text books

131
00:08:36,950 --> 00:08:40,240
and a particular room number form part for booking and if they

132
00:08:40,240 --> 00:08:43,879
do will be writing the name for gestational

133
00:08:43,879 --> 00:08:47,450
will be blank its so then we'll stop to get that concept

134
00:08:47,450 --> 00:08:50,580
visual representation of data everything we're gonna do

135
00:08:50,580 --> 00:08:55,009
is we're going to get it so that we can click on of a single double twin

136
00:08:55,009 --> 00:08:59,259
and also to the form so if you become single to show the single rooms

137
00:08:59,259 --> 00:09:02,980
and and river numbers will also get it if you click on

138
00:09:02,980 --> 00:09:07,259
room number will filter the form by the floor now the floor is determined by the

139
00:09:07,259 --> 00:09:10,569
star room number so

140
00:09:10,570 --> 00:09:14,560
to second floor 30 third floor forceful slow

141
00:09:14,559 --> 00:09:18,419
such such a standard hotel fair okay

142
00:09:18,419 --> 00:09:22,120
that sold in future videos so this is just a the basic conception of the

143
00:09:22,120 --> 00:09:23,179
Sharjah

144
00:09:23,179 --> 00:09:26,289
a.m. and thank you watchin see you can actually a