i'm ok taxes 2013
two rooms in this video on me showing you how you can create reports
I'm from report design social play-along follow the link below the video to them
a section website down to Texas 2013
TV 19 and then
open with taxes 2013 funny enough
enable run disco okay we are in the process
of creating a guest activity report and in last video
we created how suber for
I wanted in this video is create the main report
I'm from before design like I said
so the first thing we need to do
is ask ourselves whether we need to create a query
or for happy to I'm
based the report offers table guests
I would suggest
I was just we crack where you at least have it going how for better Kylie said
it to her pepcid the crew be just the sort it
nothing else so create kar designed for just pressed
and table guests so it's going for the same fields in
was talking on the field as I go
I'm not gonna actually restrict
any of the taser a
except no settlements in the am
the way I am going to his own witness swap over first name last name
and sort by sending last name so pass on the first time
which have you put to the left side the first encounters amuse right
is the first thing you look at sort by so I was so by last name first name by
first name
to free runner to see exactly what it's done
so let's save that I think all that long query cast
activity school to its
ASC the AC's tie the pointless
on it in it because that's what well to keep with the name conventional used to
rinse
so they go try same clothes at home now
here's what we do to credit report from design view we've become create
number click on report design and we see this
which is I think that most important thing to remember about report design
is that anything you put in the detail section will be repeated
have so rocks are contrary to reports and data
so we do anything else safer for
call this report guest activity
okay and I'm on the property she pressed her for
if you don't have your property she I make sure some report credit data
and in records also can actually touch a datasource to it
and we are going to choose query guest activity sorted ascending
I'm now we the tasaday source we can look at the fields
and let's put the guessed it: in here let's pull this right the way up
and this destruction to levy to remain place repeating the guessed it:
and the but think you can see this but this the difference
in call if the background he this case study number forty guess that the
and I'm five sets of creating a was cool to banditry for design
retreat are really need to worry about whatever
right okay so you talk back to design view
click and drag to recast I T co 2 range
and click on stacked so we've extra it
an arrangement now so it's going to be too easy for students of more
information
I'm cyclic contract tight so
and last name
and a steep drop first name add your last name and data per
very nice click here arrange concert right concert Ryan so
right and this drug control addresses
yeah and not forget the
confirmation high-powered email I'm
select column before
former cry give it easier for 6
got some quite savage padding between the cells for 20
really like that when we go to lay off you we wanted in that column that
who make first name and last name separated
we will widen this column here and we will whiten
this column massively here and this one not quite so massively path
okay and less press in the control panel members cookin in only the selves
police textbooks as I should say and I'm going to remove
the border style we're gonna transparent okay
so now I've got repeating day to that i won drop it back design view
and current design and click on title
and we get this to report Heather forecast activity
parity this okay let last change the size 36
and let us change the height to
and more importantly if you cook this
in the report had a we gotta print preview
this is gonna be at the start the report
I want this at the stove at the top of every page
so hoop clicked in it and press control X
clicking page had a control freak to now actually dropped it
into the page header I
gonna change the backcolor
twelve-page had a section and climate change
to something care ish
before the the theme we were miserable oranges let's try that
know if I go to print preview
yeah the star of every page is brother Paul
and and I'm let's to
page numbers in bomb page for to
we don't really want anything whom report and one last thing we want to do
good detail and force the page
of two sections where this is going to do is off to every detail sex is gonna
force it to be a new page
so now but one guest on every page which is why I want
per preview
okay nothing actually
first thing I should to prevent a laugh you just click
just to the left of the line the toes with the margin is
and for alternate back colorless caregiver
so that BIF background want spin Africa backed Print Preview
we get this going I know you miss a
is missing a whole other information down here I knew you say that but we're
gonna do with the and the next video when we at the
summer for so thank you for watching and I see you next year we'll be having some
powerful