1
00:00:01,579 --> 00:00:03,139
i'm ok taxes 2013

2
00:00:03,138 --> 00:00:07,080
two rooms in this video on me showing you how you can create reports

3
00:00:07,080 --> 00:00:12,030
I'm from report design social play-along follow the link below the video to them

4
00:00:12,029 --> 00:00:14,558
a section website down to Texas 2013

5
00:00:14,558 --> 00:00:17,750
TV 19 and then

6
00:00:17,750 --> 00:00:23,339
open with taxes 2013 funny enough

7
00:00:23,339 --> 00:00:27,089
enable run disco okay we are in the process

8
00:00:27,089 --> 00:00:31,028
of creating a guest activity report and in last video

9
00:00:31,028 --> 00:00:35,140
we created how suber for

10
00:00:35,140 --> 00:00:38,340
I wanted in this video is create the main report

11
00:00:38,340 --> 00:00:41,670
I'm from before design like I said

12
00:00:41,670 --> 00:00:44,710
so the first thing we need to do

13
00:00:44,710 --> 00:00:48,500
is ask ourselves whether we need to create a query

14
00:00:48,500 --> 00:00:51,840
or for happy to I'm

15
00:00:51,840 --> 00:00:55,350
based the report offers table guests

16
00:00:55,350 --> 00:00:58,989
I would suggest

17
00:00:58,988 --> 00:01:04,170
I was just we crack where you at least have it going how for better Kylie said

18
00:01:04,170 --> 00:01:06,609
it to her pepcid the crew be just the sort it

19
00:01:06,609 --> 00:01:10,900
nothing else so create kar designed for just pressed

20
00:01:10,900 --> 00:01:14,200
and table guests so it's going for the same fields in

21
00:01:14,200 --> 00:01:18,650
was talking on the field as I go

22
00:01:18,650 --> 00:01:22,759
I'm not gonna actually restrict

23
00:01:22,759 --> 00:01:28,170
any of the taser a

24
00:01:28,170 --> 00:01:31,640
except no settlements in the am

25
00:01:31,640 --> 00:01:36,019
the way I am going to his own witness swap over first name last name

26
00:01:36,019 --> 00:01:40,449
and sort by sending last name so pass on the first time

27
00:01:40,450 --> 00:01:44,439
which have you put to the left side the first encounters amuse right

28
00:01:44,438 --> 00:01:49,069
is the first thing you look at sort by so I was so by last name first name by

29
00:01:49,069 --> 00:01:49,969
first name

30
00:01:49,969 --> 00:01:53,728
to free runner to see exactly what it's done

31
00:01:53,728 --> 00:01:57,769
so let's save that I think all that long query cast

32
00:01:57,769 --> 00:02:01,849
activity school to its

33
00:02:01,849 --> 00:02:05,468
ASC the AC's tie the pointless

34
00:02:05,468 --> 00:02:09,848
on it in it because that's what well to keep with the name conventional used to

35
00:02:09,848 --> 00:02:10,389
rinse

36
00:02:10,389 --> 00:02:14,469
so they go try same clothes at home now

37
00:02:14,469 --> 00:02:18,539
here's what we do to credit report from design view we've become create

38
00:02:18,539 --> 00:02:22,269
number click on report design and we see this

39
00:02:22,270 --> 00:02:26,480
which is I think that most important thing to remember about report design

40
00:02:26,479 --> 00:02:30,969
is that anything you put in the detail section will be repeated

41
00:02:30,969 --> 00:02:35,189
have so rocks are contrary to reports and data

42
00:02:35,189 --> 00:02:38,318
so we do anything else safer for

43
00:02:38,318 --> 00:02:42,479
call this report guest activity

44
00:02:42,479 --> 00:02:48,590
okay and I'm on the property she pressed her for

45
00:02:48,590 --> 00:02:53,080
if you don't have your property she I make sure some report credit data

46
00:02:53,080 --> 00:02:56,340
and in records also can actually touch a datasource to it

47
00:02:56,340 --> 00:03:00,390
and we are going to choose query guest activity sorted ascending

48
00:03:00,389 --> 00:03:05,369
I'm now we the tasaday source we can look at the fields

49
00:03:05,370 --> 00:03:09,769
and let's put the guessed it: in here let's pull this right the way up

50
00:03:09,769 --> 00:03:14,110
and this destruction to levy to remain place repeating the guessed it:

51
00:03:14,110 --> 00:03:17,700
and the but think you can see this but this the difference

52
00:03:17,699 --> 00:03:22,679
in call if the background he this case study number forty guess that the

53
00:03:22,680 --> 00:03:26,560
and I'm five sets of creating a was cool to banditry for design

54
00:03:26,560 --> 00:03:30,219
retreat are really need to worry about whatever

55
00:03:30,219 --> 00:03:33,229
right okay so you talk back to design view

56
00:03:33,229 --> 00:03:36,229
click and drag to recast I T co 2 range

57
00:03:36,229 --> 00:03:40,310
and click on stacked so we've extra it

58
00:03:40,310 --> 00:03:44,590
an arrangement now so it's going to be too easy for students of more

59
00:03:44,590 --> 00:03:45,500
information

60
00:03:45,500 --> 00:03:49,209
I'm cyclic contract tight so

61
00:03:49,209 --> 00:03:52,549
and last name

62
00:03:52,549 --> 00:03:57,129
and a steep drop first name add your last name and data per

63
00:03:57,128 --> 00:04:02,729
very nice click here arrange concert right concert Ryan so

64
00:04:02,729 --> 00:04:06,280
right and this drug control addresses

65
00:04:06,280 --> 00:04:12,908
yeah and not forget the

66
00:04:12,908 --> 00:04:17,870
confirmation high-powered email I'm

67
00:04:17,870 --> 00:04:21,829
select column before

68
00:04:21,829 --> 00:04:25,370
former cry give it easier for 6

69
00:04:25,370 --> 00:04:29,860
got some quite savage padding between the cells for 20

70
00:04:29,860 --> 00:04:36,250
really like that when we go to lay off you we wanted in that column that

71
00:04:36,250 --> 00:04:40,918
who make first name and last name separated

72
00:04:40,918 --> 00:04:44,609
we will widen this column here and we will whiten

73
00:04:44,610 --> 00:04:50,050
this column massively here and this one not quite so massively path

74
00:04:50,050 --> 00:04:55,680
okay and less press in the control panel members cookin in only the selves

75
00:04:55,680 --> 00:05:00,180
police textbooks as I should say and I'm going to remove

76
00:05:00,180 --> 00:05:03,610
the border style we're gonna transparent okay

77
00:05:03,610 --> 00:05:09,180
so now I've got repeating day to that i won drop it back design view

78
00:05:09,180 --> 00:05:15,400
and current design and click on title

79
00:05:15,399 --> 00:05:21,629
and we get this to report Heather forecast activity

80
00:05:21,629 --> 00:05:27,079
parity this okay let last change the size 36

81
00:05:27,079 --> 00:05:30,269
and let us change the height to

82
00:05:30,269 --> 00:05:34,329
and more importantly if you cook this

83
00:05:34,329 --> 00:05:37,430
in the report had a we gotta print preview

84
00:05:37,430 --> 00:05:40,470
this is gonna be at the start the report

85
00:05:40,470 --> 00:05:45,479
I want this at the stove at the top of every page

86
00:05:45,478 --> 00:05:49,219
so hoop clicked in it and press control X

87
00:05:49,220 --> 00:05:52,539
clicking page had a control freak to now actually dropped it

88
00:05:52,538 --> 00:05:55,800
into the page header I

89
00:05:55,800 --> 00:05:59,740
gonna change the backcolor

90
00:05:59,740 --> 00:06:03,750
twelve-page had a section and climate change

91
00:06:03,750 --> 00:06:08,129
to something care ish

92
00:06:08,129 --> 00:06:11,490
before the the theme we were miserable oranges let's try that

93
00:06:11,490 --> 00:06:15,519
know if I go to print preview

94
00:06:15,519 --> 00:06:19,810
yeah the star of every page is brother Paul

95
00:06:19,810 --> 00:06:25,199
and and I'm let's to

96
00:06:25,199 --> 00:06:30,520
page numbers in bomb page for to

97
00:06:30,519 --> 00:06:36,359
we don't really want anything whom report and one last thing we want to do

98
00:06:36,360 --> 00:06:40,840
good detail and force the page

99
00:06:40,839 --> 00:06:44,119
of two sections where this is going to do is off to every detail sex is gonna

100
00:06:44,120 --> 00:06:45,668
force it to be a new page

101
00:06:45,668 --> 00:06:49,019
so now but one guest on every page which is why I want

102
00:06:49,019 --> 00:06:52,620
per preview

103
00:06:52,620 --> 00:06:56,149
okay nothing actually

104
00:06:56,149 --> 00:06:59,649
first thing I should to prevent a laugh you just click

105
00:06:59,649 --> 00:07:05,129
just to the left of the line the toes with the margin is

106
00:07:05,129 --> 00:07:08,889
and for alternate back colorless caregiver

107
00:07:08,889 --> 00:07:13,439
so that BIF background want spin Africa backed Print Preview

108
00:07:13,439 --> 00:07:17,660
we get this going I know you miss a

109
00:07:17,660 --> 00:07:21,539
is missing a whole other information down here I knew you say that but we're

110
00:07:21,538 --> 00:07:24,259
gonna do with the and the next video when we at the

111
00:07:24,259 --> 00:07:28,000
summer for so thank you for watching and I see you next year we'll be having some

112
00:07:28,000 --> 00:07:28,250
powerful