1
00:00:00,909 --> 00:00:03,918
a local taxes 2013 22 rooms in this video

2
00:00:03,919 --> 00:00:08,119
I'm gonna be talking you through datasheets so you wanna play along

3
00:00:08,119 --> 00:00:11,320
follow the link below the video to determine section website and download

4
00:00:11,320 --> 00:00:14,660
DB there are nine an open up

5
00:00:14,660 --> 00:00:18,230
in 2013 if you come to this video from the last video

6
00:00:18,230 --> 00:00:21,640
because I said I was gonna show you how to open

7
00:00:21,640 --> 00:00:26,390
up are you recall to a specific wear proper form to specific record

8
00:00:26,390 --> 00:00:30,170
then I am a liar amazing is that in the next video

9
00:00:30,170 --> 00:00:33,090
so for this video only be looking at data sheets were going to use data

10
00:00:33,090 --> 00:00:34,180
sheets is the

11
00:00:34,179 --> 00:00:37,659
I'm starting point for opening

12
00:00:37,659 --> 00:00:42,599
record from another form and I know I just said

13
00:00:42,600 --> 00:00:46,689
okay caterpillar where we be made form testimony

14
00:00:46,689 --> 00:00:50,589
book of the buttons on in the loss for source video

15
00:00:50,590 --> 00:00:54,629
okay

16
00:00:54,628 --> 00:00:57,689
I'm are stores close at 10

17
00:00:57,689 --> 00:01:01,189
we are really neat up were

18
00:01:01,189 --> 00:01:04,209
re: were today we do in is datasheets

19
00:01:04,209 --> 00:01:07,279
I'm so de wildt a sheet will the

20
00:01:07,280 --> 00:01:10,409
eerily similar two tables

21
00:01:10,409 --> 00:01:14,280
very very similar fact tables but you can do

22
00:01:14,280 --> 00:01:17,879
a bit more with them they can respond to events I'm

23
00:01:17,879 --> 00:01:22,140
the very very very useful not just in accessing any kind of

24
00:01:22,140 --> 00:01:26,090
database application you should have an option to produce data sheets

25
00:01:26,090 --> 00:01:30,159
so let us the study sheet with

26
00:01:30,159 --> 00:01:34,650
McQueary because who if we don't already have one on over to reaffirm sorry the

27
00:01:34,650 --> 00:01:37,359
query room so it is sending resource the rooms

28
00:01:37,359 --> 00:01:41,299
by the room number and you can click on a

29
00:01:41,299 --> 00:01:44,740
going to create kinda more forms and click on basic

30
00:01:44,739 --> 00:01:47,828
hey Doc city looks very similar to

31
00:01:47,828 --> 00:01:52,289
I'm a table and save it are cooler

32
00:01:52,290 --> 00:01:57,490
frm rooms so it is sending

33
00:01:57,489 --> 00:02:02,919
PS DSS

34
00:02:02,920 --> 00:02:06,879
date she to her if you haven't worked on it already now

35
00:02:06,879 --> 00:02:11,519
day she's present the data I in a similar way to the table does

36
00:02:11,520 --> 00:02:15,610
in the its a lists the data going down

37
00:02:15,610 --> 00:02:19,239
as one does advantage over tables are the

38
00:02:19,239 --> 00:02:22,950
if you base today she gonna clear you can actually saw the records

39
00:02:22,949 --> 00:02:26,000
as we've done here by room number because the table

40
00:02:26,000 --> 00:02:29,650
is

41
00:02:29,650 --> 00:02:33,890
we've got a couple even normally go for one here and

42
00:02:33,889 --> 00:02:37,068
2004 he I did that literally just demonstrate

43
00:02:37,068 --> 00:02:41,039
stuff doesn't always get into the northern a table staff from

44
00:02:41,039 --> 00:02:44,340
so one good thing about the issues you can base of the query

45
00:02:44,340 --> 00:02:47,739
not a good thing about date sheets are events

46
00:02:47,739 --> 00:02:51,969
so click here go to the proficiency have coalesced the events

47
00:02:51,969 --> 00:02:55,239
and I will be covering the click event because that's only use

48
00:02:55,239 --> 00:02:58,289
foo emblems data entry to a specific

49
00:02:58,289 --> 00:03:01,840
record by will be due next video other good things about

50
00:03:01,840 --> 00:03:06,110
datasheets are conditional for who is conditional formatting

51
00:03:06,110 --> 00:03:11,300
if we go to day she here and let's say for example

52
00:03:11,300 --> 00:03:16,180
we were interested the using some kind of color coated indicate the rooms there

53
00:03:16,180 --> 00:03:16,629
are

54
00:03:16,628 --> 00:03:20,408
most expensive so we can actually create some

55
00:03:20,408 --> 00:03:24,489
conditional formatting rules we can say pic on there

56
00:03:24,489 --> 00:03:28,950
and whether we want to say 150 over

57
00:03:28,949 --> 00:03:33,789
should be red 130 to 150 should be

58
00:03:33,789 --> 00:03:38,128
amber unless the non didn't they should be

59
00:03:38,128 --> 00:03:44,079
yellow right so new rule bear in mind

60
00:03:44,080 --> 00:03:48,069
he show me for my roots will cost per night so interested in this field

61
00:03:48,068 --> 00:03:51,839
cyclical new rule and what we would do

62
00:03:51,840 --> 00:03:56,810
is former only cells where the field value is between

63
00:03:56,810 --> 00:03:59,818
well we think achieved

64
00:03:59,818 --> 00:04:05,250
in this case is greater than 150

65
00:04:05,250 --> 00:04:09,449
case that's the rule know what we want to do is greater than 150 but we will

66
00:04:09,449 --> 00:04:10,738
make the back fifty

67
00:04:10,739 --> 00:04:15,060
I'm so red everyone make from to sell problem

68
00:04:15,060 --> 00:04:18,120
or the a lacs why so we can see them

69
00:04:18,120 --> 00:04:21,209
click OK and then apply

70
00:04:21,209 --> 00:04:24,819
you see it to the cells been affected tonight list too

71
00:04:24,819 --> 00:04:29,459
another room Kenny and food value is between

72
00:04:29,459 --> 00:04:32,680
130 and

73
00:04:32,680 --> 00:04:36,769
149 and we were on the back of the cell to be

74
00:04:36,769 --> 00:04:40,019
amber was that close as a sorry this is the

75
00:04:40,019 --> 00:04:45,829
the writing and I'm Rebecca Soni three amber

76
00:04:45,829 --> 00:04:49,659
wasn't even close to Amber

77
00:04:49,660 --> 00:04:52,729
enough to do the front is so white

78
00:04:52,728 --> 00:04:56,870
was a show yes or press OK and apply

79
00:04:56,870 --> 00:05:01,220
okay and and I'm the rope

80
00:05:01,220 --> 00:05:04,830
which is food value is

81
00:05:04,829 --> 00:05:08,149
less than and 150

82
00:05:08,149 --> 00:05:12,339
we went back to sell to be yellow

83
00:05:12,339 --> 00:05:15,909
should I do for a sec recollect an affront to do so

84
00:05:15,910 --> 00:05:21,639
what's no good disco black okay and apply

85
00:05:21,639 --> 00:05:24,720
we got a small and only because the 157 come up

86
00:05:24,720 --> 00:05:28,400
arm between 1:30 of greater okay

87
00:05:28,399 --> 00:05:32,319
rift edit this room so click on it at a true

88
00:05:32,319 --> 00:05:35,800
greater than or equal to 150

89
00:05:35,800 --> 00:05:40,780
like okay okay so now having done that

90
00:05:40,779 --> 00:05:43,879
its slightly more visually

91
00:05:43,879 --> 00:05:47,779
appeasing appeasing pleasing

92
00:05:47,779 --> 00:05:51,769
appeasing pleasing your I'm and you can

93
00:05:51,769 --> 00:05:56,258
get a sense that the rooms inbred are the more expensive ones in Ambon and

94
00:05:56,259 --> 00:05:56,990
yellow

95
00:05:56,990 --> 00:06:00,210
the summit you could do that you could divide them types

96
00:06:00,209 --> 00:06:03,629
so you got singles doubles and tweens and

97
00:06:03,629 --> 00:06:07,038
former in conditional format is actually something the by

98
00:06:07,038 --> 00:06:10,449
think we should I use more of it's going to be readout

99
00:06:10,449 --> 00:06:13,960
I just another couple other things you can do you can change the row colors for

100
00:06:13,959 --> 00:06:15,788
the data sheets

101
00:06:15,788 --> 00:06:19,310
so for example you could pick the background color and

102
00:06:19,310 --> 00:06:22,879
make something care ish agreeing while

103
00:06:22,879 --> 00:06:26,709
horrible truly horrible and

104
00:06:26,709 --> 00:06:30,560
the Scotia point below and you can actually choose what alternate

105
00:06:30,560 --> 00:06:33,959
row Cali want when you choose a background color chooses a

106
00:06:33,959 --> 00:06:37,839
a suitable alternate row color but you can if she

107
00:06:37,839 --> 00:06:41,159
reduce the something really disgusting actually let's go for

108
00:06:41,160 --> 00:06:44,800
I'm green and alternate be

109
00:06:44,800 --> 00:06:48,610
yellow thats file that's truly fell

110
00:06:48,610 --> 00:06:51,919
that's disgusting should be legal let's change

111
00:06:51,918 --> 00:06:57,258
this back to automatic and let's change this to you

112
00:06:57,259 --> 00:07:01,449
are Louis

113
00:07:01,449 --> 00:07:05,788
talk plan something like that I'm not and characters who dis I think that

114
00:07:05,788 --> 00:07:09,399
makes it stand out a little bit so you've got an alternate

115
00:07:09,399 --> 00:07:12,750
row colors there you've got conditional formatting to use conditional format it

116
00:07:12,750 --> 00:07:13,829
does make a difference

117
00:07:13,829 --> 00:07:17,939
one other thing a I will mention about I'm

118
00:07:17,939 --> 00:07:21,348
day she's is if you click in here

119
00:07:21,348 --> 00:07:26,199
and this is what we're gonna be using to open up for me the next video

120
00:07:26,199 --> 00:07:29,550
and we go here and my sis display stifling

121
00:07:29,550 --> 00:07:33,430
this change that always and then in day she she gets nice

122
00:07:33,430 --> 00:07:36,829
ability to be able to

123
00:07:36,829 --> 00:07:40,019
treat this particular food as a button which

124
00:07:40,019 --> 00:07:43,240
Karnataka bond the other hand looping

125
00:07:43,240 --> 00:07:46,288
but does make a difference was kinda nice okay

126
00:07:46,288 --> 00:07:49,459
so that stays sheets hope you enjoy it that video

127
00:07:49,459 --> 00:07:52,829
as much as I did and really

128
00:07:52,829 --> 00:07:57,008
and I'll see you next year I will be showing you genuinely how to

129
00:07:57,009 --> 00:08:00,240
open up a form to record

130
00:08:00,240 --> 00:08:03,400
a that you click on in another

131
00:08:03,399 --> 00:08:06,649
for okay it's ok thank you for watching and I sure see you then