1
00:00:02,040 --> 00:00:04,450
other local taxes 2013 shoot or ooze

2
00:00:04,450 --> 00:00:08,370
this video are we talking you through sober force

3
00:00:08,369 --> 00:00:11,899
at six wanna play along follow the link below the video to download section

4
00:00:11,900 --> 00:00:14,609
website and download axis 2013 TB

5
00:00:14,609 --> 00:00:18,820
18 and let us open it up

6
00:00:18,820 --> 00:00:22,010
okay so lost few videos

7
00:00:22,010 --> 00:00:27,029
we'll work in a way through query bookings

8
00:00:27,028 --> 00:00:31,649
tito's extended who strip

9
00:00:31,649 --> 00:00:37,189
to design a few cake

10
00:00:37,189 --> 00:00:40,390
now that what we wanted do you wanna curry

11
00:00:40,390 --> 00:00:45,210
a report foo I think

12
00:00:45,210 --> 00:00:49,299
guests probably so so many to link table bookings to

13
00:00:49,299 --> 00:00:53,959
the actual guess over graph to so the table

14
00:00:53,960 --> 00:00:58,390
respectable for candy toast a guest so that they would say workings

15
00:00:58,390 --> 00:01:03,808
oMG I guessed it: gonna drop custodian here

16
00:01:03,808 --> 00:01:07,359
and to promote it then runner I'm gonna be

17
00:01:07,359 --> 00:01:13,030
using this service a multi-purpose report of query for the summer force

18
00:01:13,030 --> 00:01:16,049
so they've done close that

19
00:01:16,049 --> 00:01:19,810
temerity to create the sub report which is actually I hope this

20
00:01:19,810 --> 00:01:23,460
booking detail information soak up to create

21
00:01:23,459 --> 00:01:26,769
and choose I am

22
00:01:26,769 --> 00:01:30,609
report design be marked with nation

23
00:01:30,609 --> 00:01:34,099
we've had a Gatito regatta for topper

24
00:01:34,099 --> 00:01:40,828
with details where we're going to repeat the repeating data centers close

25
00:01:40,828 --> 00:01:45,029
enough to little pixel actually one who's online updates for

26
00:01:45,030 --> 00:01:50,509
and the save the report cool it report

27
00:01:50,509 --> 00:01:53,509
I'm guest

28
00:01:53,509 --> 00:01:57,180
act City me

29
00:01:57,180 --> 00:02:00,579
them question asked terribly fearful

30
00:02:00,578 --> 00:02:03,739
to

31
00:02:03,739 --> 00:02:07,280
of a name for could have called a worse name what might doing

32
00:02:07,280 --> 00:02:10,699
Chris rename a its report

33
00:02:10,699 --> 00:02:15,030
booking tito's

34
00:02:15,030 --> 00:02:18,848
by guest sup

35
00:02:18,848 --> 00:02:23,829
Parker that's a slightly better

36
00:02:23,830 --> 00:02:27,060
name all right now I'm in design view

37
00:02:27,060 --> 00:02:30,489
from at the property she is probably she's not there persist for

38
00:02:30,489 --> 00:02:33,640
and data so now going to

39
00:02:33,639 --> 00:02:38,189
shoes to query Corey booking details extended

40
00:02:38,189 --> 00:02:42,019
as the date for the report I would add some photos are not going to add

41
00:02:42,019 --> 00:02:45,280
all the field so the food I'm interested in added in

42
00:02:45,280 --> 00:02:51,539
are guessed it: I'm

43
00:02:51,539 --> 00:02:55,628
from

44
00:02:55,628 --> 00:02:59,359
time with the faith the air con

45
00:02:59,360 --> 00:03:05,060
and

46
00:03:05,060 --> 00:03:11,908
I warm the check in date nor the check out they

47
00:03:11,908 --> 00:03:14,959
check out the it to collect and I want the

48
00:03:14,959 --> 00:03:19,959
cost which is that wanna call it cost practice that long line up for

49
00:03:19,959 --> 00:03:24,719
with details so ends up looking something like this

50
00:03:24,719 --> 00:03:28,889
switches for not sure we want to talk to layout view

51
00:03:28,889 --> 00:03:32,458
I am actual guess thought the

52
00:03:32,459 --> 00:03:36,780
that's a shift over who and Persephone let's make that

53
00:03:36,780 --> 00:03:40,090
invisible because to see killer in layout

54
00:03:40,090 --> 00:03:45,280
Cooper so visible now check in date check out think cost

55
00:03:45,280 --> 00:03:49,408
let's move to border if you want to click a motive to

56
00:03:49,408 --> 00:03:53,859
I'm items at the same time press the control bond click-through

57
00:03:53,860 --> 00:03:56,870
and leaves post

58
00:03:56,870 --> 00:04:02,688
to this make this much bigger okay

59
00:04:02,688 --> 00:04:06,969
and some other obvious things are gonna walk putting the labels about much

60
00:04:06,969 --> 00:04:07,539
option

61
00:04:07,539 --> 00:04:10,889
this is a subir for none of this makes sense so this just

62
00:04:10,889 --> 00:04:16,310
to karen is had a full stop

63
00:04:16,310 --> 00:04:19,589
let's make this like the report 6

64
00:04:19,589 --> 00:04:22,739
and yes movie

65
00:04:22,740 --> 00:04:27,829
thus far off is it going stein of as much as it would go

66
00:04:27,829 --> 00:04:31,089
so we get that

67
00:04:31,089 --> 00:04:34,918
Connie and layout view

68
00:04:34,918 --> 00:04:41,649
notices or just formatting there's no picture on the Sirius literacy

69
00:04:41,649 --> 00:04:46,258
change my mind but just the literally for my existing data anyway

70
00:04:46,259 --> 00:04:51,669
we're gonna do now is good lifestyle bomb solid

71
00:04:51,668 --> 00:04:54,709
okay and I'm just click on the left here

72
00:04:54,709 --> 00:04:57,930
I want backcolor an alternate back cover

73
00:04:57,930 --> 00:05:01,829
to be the same time its curative dark 5 percent

74
00:05:01,829 --> 00:05:05,120
thanks to a very similar a few rows of data now

75
00:05:05,120 --> 00:05:09,780
and I will

76
00:05:09,779 --> 00:05:13,198
probably just to keep

77
00:05:13,199 --> 00:05:17,560
want to do that's gonna change the name this text box was going to put a dash

78
00:05:17,560 --> 00:05:19,199
between check in and

79
00:05:19,199 --> 00:05:23,350
know they got the same thing over and I'm just finished aspin hyphen

80
00:05:23,350 --> 00:05:26,500
to change the name resume doing a

81
00:05:26,500 --> 00:05:30,740
is stock now clicking here Americans say

82
00:05:30,740 --> 00:05:36,120
equals check

83
00:05:36,120 --> 00:05:39,660
in home loan

84
00:05:39,660 --> 00:05:45,340
and checking day

85
00:05:45,339 --> 00:05:50,489
macum this approach into space and where

86
00:05:50,490 --> 00:05:55,360
the space chickens that use checkin

87
00:05:55,360 --> 00:05:58,910
and this one same idea

88
00:05:58,910 --> 00:06:03,229
he cools check

89
00:06:03,228 --> 00:06:07,699
Alps to

90
00:06:07,699 --> 00:06:11,620
I'm percent suspect a concatenation idea

91
00:06:11,620 --> 00:06:17,848
that

92
00:06:17,848 --> 00:06:19,288
just in this town

93
00:06:19,288 --> 00:06:24,908
are

94
00:06:24,908 --> 00:06:27,658
& Print Preview just to relax okay so that's the

95
00:06:27,658 --> 00:06:31,218
that's pretty good for some report

96
00:06:31,218 --> 00:06:35,278
at now key you might be wondering

97
00:06:35,278 --> 00:06:39,499
was a key for you might wonder why we've got the guest ideas visible

98
00:06:39,499 --> 00:06:43,949
but he's the guessed it: to link up to the main report to make in a report by

99
00:06:43,949 --> 00:06:44,939
guest activity

100
00:06:44,939 --> 00:06:48,718
to the next I'm story we're going to create

101
00:06:48,718 --> 00:06:52,058
the sorta main guest report which is going to list all the guests and then

102
00:06:52,059 --> 00:06:55,889
we're gonna at this in as a subir former going to use to guessed it:

103
00:06:55,889 --> 00:06:59,288
as West filtering down the sub report so you

104
00:06:59,288 --> 00:07:03,269
that's a simple some report and see you next video

105
00:07:03,269 --> 00:07:07,038
where we will be creating the main report thank you and goodbye