1
00:00:01,689 --> 00:00:04,140
a local taxes 2013 tutorials

2
00:00:04,139 --> 00:00:07,250
in this video I'm gonna be talking you through data entry forms

3
00:00:07,250 --> 00:00:11,039
so you wanna play along follow the link below the video to down a section

4
00:00:11,039 --> 00:00:14,189
website and download access 2013 the bees are

5
00:00:14,189 --> 00:00:17,710
8 and its opener for up

6
00:00:17,710 --> 00:00:22,359
okay site data entry forms

7
00:00:22,359 --> 00:00:26,660
what other well better entry forms traditionally of forms

8
00:00:26,660 --> 00:00:31,379
the are used did she just for entering data into the system not ready for

9
00:00:31,379 --> 00:00:32,308
modifying them

10
00:00:32,308 --> 00:00:37,269
I'm but because it's the the way access is designed you can actually create one

11
00:00:37,270 --> 00:00:38,059
form

12
00:00:38,058 --> 00:00:41,459
and use it 5*a editing data for

13
00:00:41,460 --> 00:00:44,878
for adding data so I'm I'm

14
00:00:44,878 --> 00:00:48,949
interested at the moment in Table rooms there it is

15
00:00:48,950 --> 00:00:52,100
I mcrae data entry form for tapeworms so

16
00:00:52,100 --> 00:00:55,239
I make from click into table rooms on the

17
00:00:55,238 --> 00:00:59,089
navigation pane I go to create and quite useful

18
00:00:59,090 --> 00:01:02,820
and I get this which

19
00:01:02,820 --> 00:01:07,379
may or may not be likely depending on YouVersion a beauty

20
00:01:07,379 --> 00:01:11,019
parts first things first I'm you get rid of this

21
00:01:11,019 --> 00:01:15,158
subform bomb and

22
00:01:15,159 --> 00:01:20,368
with essentially actually already done much to access the most the work force

23
00:01:20,368 --> 00:01:23,890
waste on as its and taken table rooms

24
00:01:23,890 --> 00:01:28,219
and its use that as the record set for

25
00:01:28,219 --> 00:01:31,368
this particular forms if you press if for

26
00:01:31,368 --> 00:01:36,049
bring up the property she make sure some form here good data

27
00:01:36,049 --> 00:01:40,229
record sources table rooms which means is taking over data from Table rooms and

28
00:01:40,228 --> 00:01:42,709
it's dropping it into this form

29
00:01:42,709 --> 00:01:47,669
and that's because that were able to use the navigation buttons at the bottom

30
00:01:47,670 --> 00:01:52,030
and click through records and who this information missing corresponds to

31
00:01:52,030 --> 00:01:55,030
information is actually in table form so

32
00:01:55,030 --> 00:02:00,609
number 54 Ramadi five is room number 205 230 Palin I

33
00:02:00,609 --> 00:02:06,599
and 2005 330-pound not sexy sexy takes care most the information for us

34
00:02:06,599 --> 00:02:09,669
and and even to the extent

35
00:02:09,669 --> 00:02:13,488
here where 5 to his FormView

36
00:02:13,489 --> 00:02:17,530
homeowners might deter

37
00:02:17,530 --> 00:02:22,949
know you any do something like that you actually just get the

38
00:02:22,949 --> 00:02:26,259
on/off timer are know me losing the plot

39
00:02:26,259 --> 00:02:30,079
areas access is done most of the work force with really needs to anything

40
00:02:30,080 --> 00:02:33,510
more accepts started and also show you how to open them up

41
00:02:33,509 --> 00:02:37,079
to a.m. at dates and

42
00:02:37,080 --> 00:02:40,310
other at the bonds actually do a bit more to the right

43
00:02:40,310 --> 00:02:44,209
and styling its I got a former go to former

44
00:02:44,209 --> 00:02:48,750
and kicking down here we don't recall selectors that's a

45
00:02:48,750 --> 00:02:54,479
bar here I'm gonna keep the navigation buttons

46
00:02:54,479 --> 00:02:57,560
because they're Chronicle lets the

47
00:02:57,560 --> 00:03:01,318
attend just get rid of the header these days

48
00:03:01,318 --> 00:03:05,979
and we need to right click and save for my call it

49
00:03:05,979 --> 00:03:09,199
and I'm form rooms data

50
00:03:09,199 --> 00:03:13,280
entry okay that's great and

51
00:03:13,280 --> 00:03:16,408
and what we do is still in the proficiency on the form

52
00:03:16,408 --> 00:03:19,489
forces captured in war we're in. he will be displayed here

53
00:03:19,489 --> 00:03:23,390
so that's right rooms that's kinda cool

54
00:03:23,389 --> 00:03:28,039
and everything I sometimes like sometimes I don't do it depends on the

55
00:03:28,039 --> 00:03:28,989
styling is

56
00:03:28,989 --> 00:03:34,810
person the control bond click on a love these text boxes in the combo box

57
00:03:34,810 --> 00:03:38,658
and property she i'm looking for special effects

58
00:03:38,658 --> 00:03:42,949
and change it to some can so

59
00:03:42,949 --> 00:03:46,068
but formed you got to look kinda nice and bit more

60
00:03:46,068 --> 00:03:50,018
professional depending on what you want okay

61
00:03:50,019 --> 00:03:53,120
next up I'm were interested in

62
00:03:53,120 --> 00:03:58,289
buttons I as click on burn the design part the top click on the parliament

63
00:03:58,289 --> 00:03:58,699
just

64
00:03:58,699 --> 00:04:03,188
drop on down there and

65
00:04:03,188 --> 00:04:08,340
I'm gonna actually you sum up the in bill

66
00:04:08,340 --> 00:04:11,900
functionality

67
00:04:11,900 --> 00:04:16,129
if we taken close form that is going to work

68
00:04:16,129 --> 00:04:20,978
going to the only saving close a

69
00:04:20,978 --> 00:04:25,379
notice cancel our own actually

70
00:04:25,379 --> 00:04:30,500
I was on the workers we're saving close on it too undoing close

71
00:04:30,500 --> 00:04:33,569
which we can do from we did you want to get from here

72
00:04:33,569 --> 00:04:37,740
the record operations on the record ski the figure

73
00:04:37,740 --> 00:04:42,810
gonna rain to split horizontally and I just one close I suppose

74
00:04:42,810 --> 00:04:47,470
don't delay

75
00:04:47,470 --> 00:04:52,370
and subtly

76
00:04:52,370 --> 00:04:55,579
to league record

77
00:04:55,579 --> 00:05:00,959
okay so person the control Quicken Loans bonds change to Britt

78
00:05:00,959 --> 00:05:04,719
to to know is too small

79
00:05:04,720 --> 00:05:08,259
the of through expiration to

80
00:05:08,259 --> 00:05:11,430
and 345

81
00:05:11,430 --> 00:05:15,478
ice a bit better and this band here

82
00:05:15,478 --> 00:05:19,359
I'm go to property she

83
00:05:19,360 --> 00:05:22,639
Mon 25 this change the name to CMD

84
00:05:22,639 --> 00:05:25,728
safe

85
00:05:25,728 --> 00:05:28,740
and for my and this change the picture

86
00:05:28,740 --> 00:05:32,769
Sunday fear to type in S

87
00:05:32,769 --> 00:05:35,879
and that's what I'm looking for I say to you

88
00:05:35,879 --> 00:05:41,350
save got undue so-called on seeing the undue

89
00:05:41,350 --> 00:05:45,930
and this once indeed early

90
00:05:45,930 --> 00:05:50,610
change in the names and one other thing we do is change

91
00:05:50,610 --> 00:05:55,860
the styling other the one changing the style in between us

92
00:05:55,860 --> 00:05:59,080
horrible because it we're gonna later on this cheese

93
00:05:59,079 --> 00:06:02,849
team is gonna change everything but this for now so we feel better about our

94
00:06:02,850 --> 00:06:06,889
about things and that's pretty awful color in that

95
00:06:06,889 --> 00:06:09,910
okay so click on the

96
00:06:09,910 --> 00:06:13,810
safe bond go to on click

97
00:06:13,810 --> 00:06:17,500
macro builder

98
00:06:17,500 --> 00:06:21,509
and just tough in close

99
00:06:21,509 --> 00:06:25,270
window object art form

100
00:06:25,269 --> 00:06:30,568
Forms Data Entry so from yes

101
00:06:30,569 --> 00:06:33,600
save that and close that

102
00:06:33,600 --> 00:06:38,639
this one girl already be an embedded macro

103
00:06:38,639 --> 00:06:42,038
down here close window

104
00:06:42,038 --> 00:06:45,620
form same thing Forms Data Entry

105
00:06:45,620 --> 00:06:51,149
as its and onto save no

106
00:06:51,149 --> 00:06:56,589
just drag and drop to understand on menu command

107
00:06:56,589 --> 00:07:03,008
I'm and the same I T

108
00:07:03,009 --> 00:07:09,259
which is a close window

109
00:07:09,259 --> 00:07:12,620
form Forms Data Entry

110
00:07:12,620 --> 00:07:15,680
and from

111
00:07:15,680 --> 00:07:18,759
for you to the thing at miss Italy you the reader

112
00:07:18,759 --> 00:07:22,150
Cinderella so

113
00:07:22,149 --> 00:07:26,870
close window just drag and drop that one up

114
00:07:26,870 --> 00:07:32,639
if I can Vic

115
00:07:32,639 --> 00:07:37,060
okkk said the three buttons since going to design view

116
00:07:37,060 --> 00:07:40,530
you have a pretty good so we're gonna close

117
00:07:40,529 --> 00:07:43,549
former state Sen sure it's going to make a dummy form

118
00:07:43,550 --> 00:07:48,370
I can demonstrate something and

119
00:07:48,370 --> 00:07:51,889
chorus 1 form test

120
00:07:51,889 --> 00:07:56,069
and drop a ban on here

121
00:07:56,069 --> 00:07:59,590
and will call this one

122
00:07:59,589 --> 00:08:02,719
edit record

123
00:08:02,720 --> 00:08:06,830
of a barn on here and call this one

124
00:08:06,829 --> 00:08:11,529
new record I was looking at these are going to use these buttons

125
00:08:11,529 --> 00:08:14,878
cool the form his room data entry

126
00:08:14,879 --> 00:08:19,080
but I'm gonna I in the first bon we're gonna call it

127
00:08:19,079 --> 00:08:23,149
so the it's not message you know so the opens to

128
00:08:23,149 --> 00:08:28,429
existing data and in the second bomb gonna open the form up so it's

129
00:08:28,430 --> 00:08:33,940
a new record so click on the bond press the form actually property she

130
00:08:33,940 --> 00:08:37,919
go to then and complex organism macro

131
00:08:37,918 --> 00:08:41,718
marker builder and open form

132
00:08:41,719 --> 00:08:45,089
for name is Forms Data Entry

133
00:08:45,089 --> 00:08:48,580
I am and window motor bomb

134
00:08:48,580 --> 00:08:52,589
dialogue for the second bono u2

135
00:08:52,589 --> 00:08:56,050
exactly the same thing except

136
00:08:56,049 --> 00:09:00,179
open form for name and face entry

137
00:09:00,179 --> 00:09:03,469
dialogue but now we're gonna say data mode

138
00:09:03,470 --> 00:09:08,759
his at actually just for the sake consistency this change today amo to

139
00:09:08,759 --> 00:09:11,879
to headed

140
00:09:11,879 --> 00:09:15,439
who the fuck said anyway but so

141
00:09:15,440 --> 00:09:20,149
seem consistent now you see the difference for reform if I click on

142
00:09:20,149 --> 00:09:23,250
edit record was opened up a hoot is a pain

143
00:09:23,250 --> 00:09:26,419
I'm the

144
00:09:26,419 --> 00:09:32,009
form opens up before the date you need you can search through the records

145
00:09:32,009 --> 00:09:35,399
cougar layout view

146
00:09:35,399 --> 00:09:39,100
form format and

147
00:09:39,100 --> 00:09:43,070
also send the yes naral open up in the center

148
00:09:43,070 --> 00:09:47,580
to forego posted on the time and it recorded opens up to 50 day to the

149
00:09:47,580 --> 00:09:50,589
and you can fit for the records save closer

150
00:09:50,589 --> 00:09:55,510
never hurt a new record I was up exactly the same for me opens up

151
00:09:55,509 --> 00:09:58,610
as very specific data entry form in the

152
00:09:58,610 --> 00:10:02,409
do anything I can do at the moment is put data into the form

153
00:10:02,409 --> 00:10:07,338
the press escape and close their

154
00:10:07,339 --> 00:10:11,180
okay one other thing I'm gonna cover in a later video she wondered is possible

155
00:10:11,179 --> 00:10:14,309
to open up forms to specific record so

156
00:10:14,309 --> 00:10:18,149
so you when I opened up to room ID number four

157
00:10:18,149 --> 00:10:22,100
but that would involve something like wireless box opening up for

158
00:10:22,100 --> 00:10:25,389
buddy I'm going to get too much into that is the way I am designing this

159
00:10:25,389 --> 00:10:26,278
database

160
00:10:26,278 --> 00:10:30,389
values navigation forms nazar so specific way you do that

161
00:10:30,389 --> 00:10:34,458
so marked activities to demonstrate data entry form

162
00:10:34,458 --> 00:10:38,009
which was tied to table which is table rooms

163
00:10:38,009 --> 00:10:41,889
I'm took no effort so to actually create before we just clicked on the table and

164
00:10:41,889 --> 00:10:42,659
then

165
00:10:42,659 --> 00:10:47,149
create months was created anything to deal with if it was all striving the

166
00:10:47,149 --> 00:10:48,200
form

167
00:10:48,200 --> 00:10:51,360
I'm and two in the buttons on I'm

168
00:10:51,360 --> 00:10:54,810
to some sort basic formatting techniques and then

169
00:10:54,809 --> 00:10:57,989
opening day or entry form is slightly different

170
00:10:57,990 --> 00:11:01,629
I'm thing but cover the I found cover the

171
00:11:01,629 --> 00:11:05,409
cover the next video so you can see how to open but their entry form to a

172
00:11:05,409 --> 00:11:07,208
specific record

173
00:11:07,208 --> 00:11:10,359
okay so thank you for watching

174
00:11:10,360 --> 00:11:12,560
I'm and I will see you in an exterior