1
00:00:01,459 --> 00:00:04,000
i'm ok taxes 2013 tutorials

2
00:00:04,000 --> 00:00:09,599
in this video I'm gonna be making the main report for the invoice so this is

3
00:00:09,599 --> 00:00:12,660
I think possibly in 9th video in the

4
00:00:12,660 --> 00:00:16,289
miniseries on invoices and play along

5
00:00:16,289 --> 00:00:20,429
usual stuff follow the link below the video to the dollar section website now

6
00:00:20,429 --> 00:00:22,839
taxes 2013 DV 52

7
00:00:22,839 --> 00:00:26,730
and to that's not bad for a

8
00:00:26,730 --> 00:00:33,730
okie dokie

9
00:00:33,899 --> 00:00:37,100
an

10
00:00:37,100 --> 00:00:41,020
process password or not

11
00:00:41,020 --> 00:00:45,359
turning is possible okay

12
00:00:45,359 --> 00:00:49,329
so in order to create the main invoice

13
00:00:49,329 --> 00:00:52,329
we are going to need to create a query

14
00:00:52,329 --> 00:00:56,320
and I'm for the main information on the scene then we're going to create

15
00:00:56,320 --> 00:01:01,520
all gonna add the the sub invoice that I think we made

16
00:01:01,520 --> 00:01:05,280
you read it hope you made it okay we're gonna die in

17
00:01:05,280 --> 00:01:08,390
and think the from in fields

18
00:01:08,390 --> 00:01:12,799
so and it's going to create task ok redesign

19
00:01:12,799 --> 00:01:16,280
now the tables were gonna warn by thing

20
00:01:16,280 --> 00:01:19,650
for a collection service table invoices table

21
00:01:19,650 --> 00:01:26,650
bookings in table guests kiko key

22
00:01:29,659 --> 00:01:33,670
so let's start with its a

23
00:01:33,670 --> 00:01:37,189
start booking ID Niska

24
00:01:37,188 --> 00:01:41,228
in worse ID I am

25
00:01:41,228 --> 00:01:44,909
McKenna 1 the first and last name to the guest

26
00:01:44,909 --> 00:01:48,009
cyclic in top Roman empty

27
00:01:48,009 --> 00:01:51,069
condom to come builder

28
00:01:51,069 --> 00:01:54,938
next guest sinkhole on

29
00:01:54,938 --> 00:01:58,438
and we won table guests

30
00:01:58,438 --> 00:02:01,728
door first name ampersand

31
00:02:01,728 --> 00:02:06,679
open/close quotation marks this patient space in middle and

32
00:02:06,680 --> 00:02:11,510
table guests talk last night

33
00:02:11,509 --> 00:02:16,840
palaces take a quick look at that scarce

34
00:02:16,840 --> 00:02:22,259
stuffing and the other things were going to warn

35
00:02:22,259 --> 00:02:25,759
are as long as you can on the talking

36
00:02:25,759 --> 00:02:30,289
day I am rotated discount from Table invoices

37
00:02:30,289 --> 00:02:34,068
stronger okie dokie

38
00:02:34,068 --> 00:02:38,009
family will call this

39
00:02:38,009 --> 00:02:41,239
cleary

40
00:02:41,239 --> 00:02:44,800
Harry query Harry

41
00:02:44,800 --> 00:02:47,890
you sorry very bookings

42
00:02:47,889 --> 00:02:51,399
for voices

43
00:02:51,400 --> 00:02:54,610
okay twice a close to

44
00:02:54,610 --> 00:02:59,319
and it's closed main form as well week

45
00:02:59,318 --> 00:03:02,408
cleary bookings for invoice no idea

46
00:03:02,408 --> 00:03:06,189
when I ll yeah at Aria

47
00:03:06,189 --> 00:03:09,949
they are okay now gonna crate foam

48
00:03:09,949 --> 00:03:13,219
order for Silas create a blank for

49
00:03:13,219 --> 00:03:17,469
for to to straight reporters I actually

50
00:03:17,469 --> 00:03:20,650
okay side

51
00:03:20,650 --> 00:03:26,580
because a nice white detail section which is what

52
00:03:26,580 --> 00:03:30,480
form so go to press a formerly property she

53
00:03:30,479 --> 00:03:33,959
and record source we're gonna choose to be

54
00:03:33,959 --> 00:03:38,030
weary bookings for invoices an

55
00:03:38,030 --> 00:03:41,509
to come title know at us

56
00:03:41,509 --> 00:03:45,509
kinda neat title in which local invoice

57
00:03:45,509 --> 00:03:50,318
invoice answer added a tying the air

58
00:03:50,318 --> 00:03:54,119
the time honest

59
00:03:54,120 --> 00:03:57,799
day at a time in very nice K

60
00:03:57,799 --> 00:04:01,360
now page header we don't really want anything in the page header

61
00:04:01,360 --> 00:04:04,430
which can at the existing shows we've got here

62
00:04:04,430 --> 00:04:07,989
a.m. invoice ID start with a

63
00:04:07,989 --> 00:04:11,480
go to once you try to own better range

64
00:04:11,479 --> 00:04:15,419
and click on stacked so that puts it together and layout

65
00:04:15,419 --> 00:04:18,478
to his little bit better my opinion

66
00:04:18,478 --> 00:04:22,250
and change the label 0

67
00:04:22,250 --> 00:04:27,910
change it to say invoice number

68
00:04:27,910 --> 00:04:31,800
so the invoice I deval

69
00:04:31,800 --> 00:04:36,079
sensually be the invoice number she I go back to design feel took on

70
00:04:36,079 --> 00:04:40,008
at existing fields we're gonna win booking ID as well

71
00:04:40,009 --> 00:04:43,389
to a drug that next to the investor will actually

72
00:04:43,389 --> 00:04:47,439
make to invisible some for the English side

73
00:04:47,439 --> 00:04:52,540
the and what we want where do we wanna

74
00:04:52,540 --> 00:04:55,840
case I'll say we won the

75
00:04:55,839 --> 00:04:59,569
once I D Dave boxing

76
00:04:59,569 --> 00:05:02,849
thank guest fight f ing

77
00:05:02,850 --> 00:05:06,720
enough to make me a bit sparse a second booking Baker arranged to coincide

78
00:05:06,720 --> 00:05:11,090
above less a guest even and surpass

79
00:05:11,089 --> 00:05:14,448
I am change booking date to

80
00:05:14,449 --> 00:05:18,329
dates of booking

81
00:05:18,329 --> 00:05:21,689
fish is everything white-out that

82
00:05:21,689 --> 00:05:25,180
column for the invoice ID and guess this is to then

83
00:05:25,180 --> 00:05:30,250
to you for you take a look at it that's fine

84
00:05:30,250 --> 00:05:34,418
using the control bomb click on these three boxes format

85
00:05:34,418 --> 00:05:38,740
and were meant to be invisible so visible

86
00:05:38,740 --> 00:05:43,500
no you don't miss a lie we were on the border style to be transparent

87
00:05:43,500 --> 00:05:47,750
K and mom looking to be invisible

88
00:05:47,750 --> 00:05:52,069
a to to the has a pool norm

89
00:05:52,069 --> 00:05:55,269
cool shave your print preview

90
00:05:55,269 --> 00:05:59,089
can it's fine to now organization can add in the summer for

91
00:05:59,089 --> 00:06:05,459
she got a design geocaching to make enough space for the summer for so

92
00:06:05,459 --> 00:06:08,959
track Services page for down click on guests

93
00:06:08,959 --> 00:06:14,019
better range anger insert blood supply

94
00:06:14,019 --> 00:06:17,279
and go to the bottom right the

95
00:06:17,279 --> 00:06:20,779
creative in T cells and click Insert right

96
00:06:20,779 --> 00:06:24,309
and then go to range she s been a range select 2-row

97
00:06:24,310 --> 00:06:28,110
and merch so you can this is where we gonna drop the

98
00:06:28,110 --> 00:06:32,020
invoice supper for now to converse

99
00:06:32,019 --> 00:06:35,849
for invoices sought actual money speaks into layout

100
00:06:35,850 --> 00:06:39,680
first she can hit

101
00:06:39,680 --> 00:06:46,680
space sacred invoices Saab drug over

102
00:06:48,120 --> 00:06:52,680
highest point in me are just drop any

103
00:06:52,680 --> 00:06:57,750
I'll he says

104
00:06:57,750 --> 00:07:01,060
actually know that did hit space you looking for which is fine

105
00:07:01,060 --> 00:07:06,720
so you need to do an hour small problem

106
00:07:06,720 --> 00:07:12,229
small problem me thinks go to

107
00:07:12,228 --> 00:07:15,439
click in the top list thang called the necropsy middling

108
00:07:15,439 --> 00:07:19,029
moss to filter don't think we've got the rocks

109
00:07:19,029 --> 00:07:22,689
now you have to move go

110
00:07:22,689 --> 00:07:27,180
a few ninety we've got to can I T

111
00:07:27,180 --> 00:07:32,250
which either hush it worked in

112
00:07:32,250 --> 00:07:37,470
have a was a oriental as wide an hour over the

113
00:07:37,470 --> 00:07:41,440
and why the value down there

114
00:07:41,439 --> 00:07:45,959
and taxing units one out seven more for their

115
00:07:45,959 --> 00:07:49,508
even a little bit more an hour encroaching ok

116
00:07:49,509 --> 00:07:52,680
page

117
00:07:52,680 --> 00:07:55,910
not good news

118
00:07:55,910 --> 00:08:02,860
showed

119
00:08:02,860 --> 00:08:08,970
get inside okay a.m.

120
00:08:08,970 --> 00:08:13,680
out guest is gone below national we want as a

121
00:08:13,680 --> 00:08:17,569
in the control bomb miss click and drag to stop

122
00:08:17,569 --> 00:08:20,689
the range sir

123
00:08:20,689 --> 00:08:24,029
on pick up for the times okay so

124
00:08:24,029 --> 00:08:27,098
kinda their provided the invoice

125
00:08:27,098 --> 00:08:30,639
got the solver for saved this

126
00:08:30,639 --> 00:08:35,479
and cooler for forces

127
00:08:35,479 --> 00:08:39,778
I am perfect in a sec nice close-up

128
00:08:39,778 --> 00:08:45,028
and let's go to for invoices sup good design view

129
00:08:45,028 --> 00:08:48,338
let's make that as narrow as possible

130
00:08:48,339 --> 00:08:51,510
suppressive for and data format

131
00:08:51,509 --> 00:08:55,110
and scrollbars you will need a

132
00:08:55,110 --> 00:08:59,839
saved and close that my life a number for invoices again

133
00:08:59,839 --> 00:09:04,010
score was anymore right click into layout view

134
00:09:04,009 --> 00:09:08,299
make sure you clicked on the foreign forces sup could've border-style:

135
00:09:08,299 --> 00:09:11,429
transparent and we will be dropping knowing this tweet over the next year

136
00:09:11,429 --> 00:09:13,949
will be dropping some stuff below

137
00:09:13,950 --> 00:09:18,769
the the sub report

138
00:09:18,769 --> 00:09:22,000
but what we wanted do you another thing you want to do

139
00:09:22,000 --> 00:09:26,730
if I gotta print preview you can see the big issue we've got a good morning

140
00:09:26,730 --> 00:09:28,990
what's on the pages of the sea and on since

141
00:09:28,990 --> 00:09:32,799
so collect a lab to you process for

142
00:09:32,799 --> 00:09:36,069
go to detail

143
00:09:36,070 --> 00:09:40,230
and go to yet for snoop a jumper

144
00:09:40,230 --> 00:09:45,339
of two sections in Africa 0 she say tango to print preview

145
00:09:45,339 --> 00:09:50,410
you get one invoice per page

146
00:09:50,409 --> 00:09:54,409
know that we only get ahead on the first invoice for our next the Africana

147
00:09:54,409 --> 00:09:57,659
be print and online voice a time so that's absolutely fine

148
00:09:57,659 --> 00:10:01,789
yetta service can alright I am pass a bill or dismiss course not the top so I

149
00:10:01,789 --> 00:10:03,250
just

150
00:10:03,250 --> 00:10:08,009
sold out to compare particular regions below

151
00:10:08,009 --> 00:10:11,629
click on invoice number tokens above

152
00:10:11,629 --> 00:10:16,399
and go previews similar looks like

153
00:10:16,399 --> 00:10:20,019
yeah I mean a sore thats just

154
00:10:20,019 --> 00:10:23,240
stoking the flames acceptability

155
00:10:23,240 --> 00:10:26,759
I'm re: so that's going to be enough for for that sweet

156
00:10:26,759 --> 00:10:31,169
we have ninety major we've just trade top the main invoice BEFORE

157
00:10:31,169 --> 00:10:34,639
drop de subir foreign and on a bit formatting

158
00:10:34,639 --> 00:10:38,049
and get you stuff to go back over stuff in the next video ever going to be

159
00:10:38,049 --> 00:10:40,809
playing some sub toning and tightening in this part

160
00:10:40,809 --> 00:10:43,869
up down here to refill out the invoice nicely

161
00:10:43,870 --> 00:10:47,139
okay so thank you joie chen et and see next video