a local taxes 2013 22 rooms in this video
I'm gonna be talking you through datasheets so you wanna play along
follow the link below the video to determine section website and download
DB there are nine an open up
in 2013 if you come to this video from the last video
because I said I was gonna show you how to open
up are you recall to a specific wear proper form to specific record
then I am a liar amazing is that in the next video
so for this video only be looking at data sheets were going to use data
sheets is the
I'm starting point for opening
record from another form and I know I just said
okay caterpillar where we be made form testimony
book of the buttons on in the loss for source video
okay
I'm are stores close at 10
we are really neat up were
re: were today we do in is datasheets
I'm so de wildt a sheet will the
eerily similar two tables
very very similar fact tables but you can do
a bit more with them they can respond to events I'm
the very very very useful not just in accessing any kind of
database application you should have an option to produce data sheets
so let us the study sheet with
McQueary because who if we don't already have one on over to reaffirm sorry the
query room so it is sending resource the rooms
by the room number and you can click on a
going to create kinda more forms and click on basic
hey Doc city looks very similar to
I'm a table and save it are cooler
frm rooms so it is sending
PS DSS
date she to her if you haven't worked on it already now
day she's present the data I in a similar way to the table does
in the its a lists the data going down
as one does advantage over tables are the
if you base today she gonna clear you can actually saw the records
as we've done here by room number because the table
is
we've got a couple even normally go for one here and
2004 he I did that literally just demonstrate
stuff doesn't always get into the northern a table staff from
so one good thing about the issues you can base of the query
not a good thing about date sheets are events
so click here go to the proficiency have coalesced the events
and I will be covering the click event because that's only use
foo emblems data entry to a specific
record by will be due next video other good things about
datasheets are conditional for who is conditional formatting
if we go to day she here and let's say for example
we were interested the using some kind of color coated indicate the rooms there
are
most expensive so we can actually create some
conditional formatting rules we can say pic on there
and whether we want to say 150 over
should be red 130 to 150 should be
amber unless the non didn't they should be
yellow right so new rule bear in mind
he show me for my roots will cost per night so interested in this field
cyclical new rule and what we would do
is former only cells where the field value is between
well we think achieved
in this case is greater than 150
case that's the rule know what we want to do is greater than 150 but we will
make the back fifty
I'm so red everyone make from to sell problem
or the a lacs why so we can see them
click OK and then apply
you see it to the cells been affected tonight list too
another room Kenny and food value is between
130 and
149 and we were on the back of the cell to be
amber was that close as a sorry this is the
the writing and I'm Rebecca Soni three amber
wasn't even close to Amber
enough to do the front is so white
was a show yes or press OK and apply
okay and and I'm the rope
which is food value is
less than and 150
we went back to sell to be yellow
should I do for a sec recollect an affront to do so
what's no good disco black okay and apply
we got a small and only because the 157 come up
arm between 1:30 of greater okay
rift edit this room so click on it at a true
greater than or equal to 150
like okay okay so now having done that
its slightly more visually
appeasing appeasing pleasing
appeasing pleasing your I'm and you can
get a sense that the rooms inbred are the more expensive ones in Ambon and
yellow
the summit you could do that you could divide them types
so you got singles doubles and tweens and
former in conditional format is actually something the by
think we should I use more of it's going to be readout
I just another couple other things you can do you can change the row colors for
the data sheets
so for example you could pick the background color and
make something care ish agreeing while
horrible truly horrible and
the Scotia point below and you can actually choose what alternate
row Cali want when you choose a background color chooses a
a suitable alternate row color but you can if she
reduce the something really disgusting actually let's go for
I'm green and alternate be
yellow thats file that's truly fell
that's disgusting should be legal let's change
this back to automatic and let's change this to you
are Louis
talk plan something like that I'm not and characters who dis I think that
makes it stand out a little bit so you've got an alternate
row colors there you've got conditional formatting to use conditional format it
does make a difference
one other thing a I will mention about I'm
day she's is if you click in here
and this is what we're gonna be using to open up for me the next video
and we go here and my sis display stifling
this change that always and then in day she she gets nice
ability to be able to
treat this particular food as a button which
Karnataka bond the other hand looping
but does make a difference was kinda nice okay
so that stays sheets hope you enjoy it that video
as much as I did and really
and I'll see you next year I will be showing you genuinely how to
open up a form to record
a that you click on in another
for okay it's ok thank you for watching and I sure see you then