her work taxes 2013 tutorials in a series of videos on we'll be talking you
through how to make a booking system for hotel so
and let's have a look at it before we go any further
and this is fu axis 2013 obviously over this
his I would say I and access 2010
icon don't ask me why that is by gotta
over with an open coffin axis 2013
the minimize that damn little bits actually fit so we can see we're looking
at naval call in 10
and here we are okay so it's got a login screen
and the password is password no
some into that in reverse control of 12 minimized on the ribbon
okay say this is your shoe system itself
I am we've got says the main navigation screen
which houses a several entities
and you can see that should for the bookings
got rooms guest invoices reports and uses
okay the first one is a surgery which in this case is a visual representation
I'm of bookings so the idea being
the for example with courtroom 2001 and we can see that
on 29th May room 201 is empty
for if simply for the first is empty now on the 1st to June
we have a booking for an and else that its and goes all the way
along have a room 202 and we can see though the 29th May
on Hudson is booked in there and on the 30th May
its new booking that's the idea if this judge let's give us a visual
representation
we can use is bond you can go along Monday
to numbers everything wonderful we can go along two weeks
and same %uh they were good
back and you are able to
filter down by floor so for example 281
anything related to use floor two chunks pretty standard for
hotel 303 43 so we do say we'll look at everything
inflow number three just click on 30 tonight filters down for that
you can also was would be too because you get a call for a
double room and can also filter down for the room type so that's a problem
particular and it will filter down for
doubles and give you available double rooms and everything you can to
is a few for example a
wanna look at this booking in more depth you click on stuff we can get
this come up which explains the booking in the booking details
I'm if you click on one of the squares doesn't have
booking so shady opens up new bookings to escape up
I guess sssss quite bored visual representation
I'm one thing I will say for go any further visit nothing
in this database involves any VBA it so its Koo
just the macros and
so native access controls so nothing involves VBA
and but Nick Scott bookings so we've got
a data sheet which lists bookings booking
details to be more specific and
you can use these barns to serve food about what you wanna see so if you wanna
see today's arrivals you prepare
and you're nothing I'm there was something that yes they have my car car
bookings
so we've got to cart bookings in the reason the current is the they are life
today
which is actually turning off my and we can look at future bookings
here this was huge bookings previous bookings the
and whatever you've got you can sort by chicken or by cheque Ayer
I am if you want to
drill down into booking you can click here if you want to look at a guest you
think a case anything the hyperlinks
cases ability to drill into the item itself from this
rooms says bookings so rims
same idea room datasheet you can drill into you can look at
active and inactive rooms an inactive room something for example
room 205 it's got a problem so XP maintains is not active at the moment
and look back to all I'm guests
same idea and if you have a hyperlink opens up if you pick a new
you get this for the way I'm
lil Scott top six he and you
go know yet invoices that in the actual invoice itself this is preparing
invoices tells us that
all the booking we've got a good ass invoice to the moment I'm
so for example Sandra duffy as
so close to 500 1840 which includes VAT in the discount
she's paid 400 may think
I'm so because that's not balanced if we
work at the difference between that which is 38 40 make a payment
so even close up
press f5 it doesn't work
astonishing no school at the
type sorry for a point following as a sheep
paper card okay so now you can see that
forever they before he's the cost that's how much you paid
and it's now actually automatically worked out this a balanced invoices paid
as much as the voice
I write reports got some basic reports
review to go there gonna go there yet we r
are you choosing booking rooms guest invoices booking reports
a.m. is listed bookings between dates
we can go back a little bit and you can actually
look today report form we can look to improve free-form
print of I'm
rooms same right to you can
her back and you can view
should have distanced and report form where you can go to
Print Preview dismiss the rooms and also listen associate bookings within that
time period
and and guess this truck similar to an end invoices
night invoices you select the merciless safer
freemen the and can you look at the report view
or you can go Print Preview although print preview
now this is really important if you can see
I'm sure whether it was
from the florida you can see here that
this particular person they have
book tour in 2003 from 25 May for the 25th May
which is a 140 pounds so there
and there are 140 pound they've also booked a room 202
and the 720 said oh that if you come down to
here they make a payment
on 70 from over 1000 so they were arriving
1692 now though 612 so what we've done is we've used the running some
to keep track of how much they currently 0 I'm
and he's actually paid way way way more the Neo's
saying that would indicate that he's gonna book another room
not the quick messed up have never bought we've got
the sub 20 hooves a with the discount which is nothing VAT
total including VAT to pay and balance and begin in the 50s im
special reunion queries to do with this which is mind the reasons I chose this
and last but not least we got the user's
it is guy we sort started mister james Conway
hello James and the same ID
click on their I'm and I do use is we've
infirm ask for the password field addict so Vesta
database the just to reiterate is not one single line if he be a code is so
done
through macros in continuous forms inquiries in all kinds of stuff
so that's what we're gonna be makin a.m.
crystalline xvideo you only talking about tables and ima gonna be moving
into actually
making specific objects for the state a race
so please prolong I don't know how many videos is gonna be things can require a
few
and hopefully will learn something on CNNX video