1
00:00:00,640 --> 00:00:04,739
her work taxes 2013 tutorials in a series of videos on we'll be talking you

2
00:00:04,740 --> 00:00:08,789
through how to make a booking system for hotel so

3
00:00:08,789 --> 00:00:11,899
and let's have a look at it before we go any further

4
00:00:11,900 --> 00:00:16,528
and this is fu axis 2013 obviously over this

5
00:00:16,528 --> 00:00:20,118
his I would say I and access 2010

6
00:00:20,118 --> 00:00:23,429
icon don't ask me why that is by gotta

7
00:00:23,429 --> 00:00:26,960
over with an open coffin axis 2013

8
00:00:26,960 --> 00:00:32,759
the minimize that damn little bits actually fit so we can see we're looking

9
00:00:32,759 --> 00:00:35,140
at naval call in 10

10
00:00:35,140 --> 00:00:38,869
and here we are okay so it's got a login screen

11
00:00:38,869 --> 00:00:42,149
and the password is password no

12
00:00:42,149 --> 00:00:46,210
some into that in reverse control of 12 minimized on the ribbon

13
00:00:46,210 --> 00:00:50,600
okay say this is your shoe system itself

14
00:00:50,600 --> 00:00:54,260
I am we've got says the main navigation screen

15
00:00:54,259 --> 00:00:58,808
which houses a several entities

16
00:00:58,808 --> 00:01:02,399
and you can see that should for the bookings

17
00:01:02,399 --> 00:01:05,879
got rooms guest invoices reports and uses

18
00:01:05,879 --> 00:01:11,009
okay the first one is a surgery which in this case is a visual representation

19
00:01:11,010 --> 00:01:14,630
I'm of bookings so the idea being

20
00:01:14,629 --> 00:01:19,298
the for example with courtroom 2001 and we can see that

21
00:01:19,299 --> 00:01:22,799
on 29th May room 201 is empty

22
00:01:22,799 --> 00:01:27,150
for if simply for the first is empty now on the 1st to June

23
00:01:27,150 --> 00:01:31,829
we have a booking for an and else that its and goes all the way

24
00:01:31,828 --> 00:01:36,339
along have a room 202 and we can see though the 29th May

25
00:01:36,340 --> 00:01:39,930
on Hudson is booked in there and on the 30th May

26
00:01:39,930 --> 00:01:43,950
its new booking that's the idea if this judge let's give us a visual

27
00:01:43,950 --> 00:01:44,799
representation

28
00:01:44,799 --> 00:01:48,040
we can use is bond you can go along Monday

29
00:01:48,040 --> 00:01:51,750
to numbers everything wonderful we can go along two weeks

30
00:01:51,750 --> 00:01:54,899
and same %uh they were good

31
00:01:54,899 --> 00:01:58,290
back and you are able to

32
00:01:58,290 --> 00:02:03,240
filter down by floor so for example 281

33
00:02:03,239 --> 00:02:06,699
anything related to use floor two chunks pretty standard for

34
00:02:06,700 --> 00:02:11,319
hotel 303 43 so we do say we'll look at everything

35
00:02:11,318 --> 00:02:15,549
inflow number three just click on 30 tonight filters down for that

36
00:02:15,550 --> 00:02:19,969
you can also was would be too because you get a call for a

37
00:02:19,969 --> 00:02:24,959
double room and can also filter down for the room type so that's a problem

38
00:02:24,959 --> 00:02:28,128
particular and it will filter down for

39
00:02:28,128 --> 00:02:32,598
doubles and give you available double rooms and everything you can to

40
00:02:32,598 --> 00:02:35,699
is a few for example a

41
00:02:35,699 --> 00:02:39,189
wanna look at this booking in more depth you click on stuff we can get

42
00:02:39,189 --> 00:02:43,959
this come up which explains the booking in the booking details

43
00:02:43,959 --> 00:02:47,689
I'm if you click on one of the squares doesn't have

44
00:02:47,689 --> 00:02:52,150
booking so shady opens up new bookings to escape up

45
00:02:52,150 --> 00:02:55,860
I guess sssss quite bored visual representation

46
00:02:55,860 --> 00:02:59,360
I'm one thing I will say for go any further visit nothing

47
00:02:59,360 --> 00:03:02,940
in this database involves any VBA it so its Koo

48
00:03:02,939 --> 00:03:06,050
just the macros and

49
00:03:06,050 --> 00:03:10,280
so native access controls so nothing involves VBA

50
00:03:10,280 --> 00:03:14,550
and but Nick Scott bookings so we've got

51
00:03:14,550 --> 00:03:17,840
a data sheet which lists bookings booking

52
00:03:17,840 --> 00:03:20,890
details to be more specific and

53
00:03:20,889 --> 00:03:24,329
you can use these barns to serve food about what you wanna see so if you wanna

54
00:03:24,330 --> 00:03:26,260
see today's arrivals you prepare

55
00:03:26,259 --> 00:03:30,769
and you're nothing I'm there was something that yes they have my car car

56
00:03:30,769 --> 00:03:31,469
bookings

57
00:03:31,469 --> 00:03:35,549
so we've got to cart bookings in the reason the current is the they are life

58
00:03:35,549 --> 00:03:36,219
today

59
00:03:36,219 --> 00:03:40,060
which is actually turning off my and we can look at future bookings

60
00:03:40,060 --> 00:03:43,229
here this was huge bookings previous bookings the

61
00:03:43,229 --> 00:03:47,090
and whatever you've got you can sort by chicken or by cheque Ayer

62
00:03:47,090 --> 00:03:50,150
I am if you want to

63
00:03:50,150 --> 00:03:55,799
drill down into booking you can click here if you want to look at a guest you

64
00:03:55,799 --> 00:03:57,830
think a case anything the hyperlinks

65
00:03:57,830 --> 00:04:03,390
cases ability to drill into the item itself from this

66
00:04:03,389 --> 00:04:06,529
rooms says bookings so rims

67
00:04:06,530 --> 00:04:10,500
same idea room datasheet you can drill into you can look at

68
00:04:10,500 --> 00:04:13,669
active and inactive rooms an inactive room something for example

69
00:04:13,669 --> 00:04:18,019
room 205 it's got a problem so XP maintains is not active at the moment

70
00:04:18,019 --> 00:04:21,228
and look back to all I'm guests

71
00:04:21,228 --> 00:04:25,289
same idea and if you have a hyperlink opens up if you pick a new

72
00:04:25,290 --> 00:04:28,879
you get this for the way I'm

73
00:04:28,879 --> 00:04:32,689
lil Scott top six he and you

74
00:04:32,689 --> 00:04:37,418
go know yet invoices that in the actual invoice itself this is preparing

75
00:04:37,418 --> 00:04:39,000
invoices tells us that

76
00:04:39,000 --> 00:04:43,228
all the booking we've got a good ass invoice to the moment I'm

77
00:04:43,228 --> 00:04:46,389
so for example Sandra duffy as

78
00:04:46,389 --> 00:04:51,290
so close to 500 1840 which includes VAT in the discount

79
00:04:51,290 --> 00:04:54,610
she's paid 400 may think

80
00:04:54,610 --> 00:04:57,610
I'm so because that's not balanced if we

81
00:04:57,610 --> 00:05:04,610
work at the difference between that which is 38 40 make a payment

82
00:05:06,259 --> 00:05:10,580
so even close up

83
00:05:10,579 --> 00:05:14,870
press f5 it doesn't work

84
00:05:14,870 --> 00:05:18,000
astonishing no school at the

85
00:05:18,000 --> 00:05:22,730
type sorry for a point following as a sheep

86
00:05:22,730 --> 00:05:26,480
paper card okay so now you can see that

87
00:05:26,480 --> 00:05:29,790
forever they before he's the cost that's how much you paid

88
00:05:29,790 --> 00:05:33,420
and it's now actually automatically worked out this a balanced invoices paid

89
00:05:33,420 --> 00:05:34,460
as much as the voice

90
00:05:34,459 --> 00:05:38,099
I write reports got some basic reports

91
00:05:38,100 --> 00:05:41,620
review to go there gonna go there yet we r

92
00:05:41,620 --> 00:05:45,829
are you choosing booking rooms guest invoices booking reports

93
00:05:45,829 --> 00:05:49,089
a.m. is listed bookings between dates

94
00:05:49,089 --> 00:05:53,849
we can go back a little bit and you can actually

95
00:05:53,850 --> 00:05:57,120
look today report form we can look to improve free-form

96
00:05:57,120 --> 00:06:00,290
print of I'm

97
00:06:00,290 --> 00:06:03,600
rooms same right to you can

98
00:06:03,600 --> 00:06:06,850
her back and you can view

99
00:06:06,850 --> 00:06:11,390
should have distanced and report form where you can go to

100
00:06:11,389 --> 00:06:16,529
Print Preview dismiss the rooms and also listen associate bookings within that

101
00:06:16,529 --> 00:06:17,389
time period

102
00:06:17,389 --> 00:06:22,560
and and guess this truck similar to an end invoices

103
00:06:22,560 --> 00:06:27,600
night invoices you select the merciless safer

104
00:06:27,600 --> 00:06:31,360
freemen the and can you look at the report view

105
00:06:31,360 --> 00:06:35,180
or you can go Print Preview although print preview

106
00:06:35,180 --> 00:06:39,720
now this is really important if you can see

107
00:06:39,720 --> 00:06:43,440
I'm sure whether it was

108
00:06:43,439 --> 00:06:46,500
from the florida you can see here that

109
00:06:46,500 --> 00:06:49,579
this particular person they have

110
00:06:49,579 --> 00:06:53,419
book tour in 2003 from 25 May for the 25th May

111
00:06:53,420 --> 00:06:57,050
which is a 140 pounds so there

112
00:06:57,050 --> 00:07:00,970
and there are 140 pound they've also booked a room 202

113
00:07:00,970 --> 00:07:05,690
and the 720 said oh that if you come down to

114
00:07:05,689 --> 00:07:08,689
here they make a payment

115
00:07:08,689 --> 00:07:11,959
on 70 from over 1000 so they were arriving

116
00:07:11,959 --> 00:07:15,979
1692 now though 612 so what we've done is we've used the running some

117
00:07:15,980 --> 00:07:19,930
to keep track of how much they currently 0 I'm

118
00:07:19,930 --> 00:07:23,780
and he's actually paid way way way more the Neo's

119
00:07:23,779 --> 00:07:27,159
saying that would indicate that he's gonna book another room

120
00:07:27,160 --> 00:07:31,270
not the quick messed up have never bought we've got

121
00:07:31,269 --> 00:07:35,789
the sub 20 hooves a with the discount which is nothing VAT

122
00:07:35,790 --> 00:07:40,730
total including VAT to pay and balance and begin in the 50s im

123
00:07:40,730 --> 00:07:44,900
special reunion queries to do with this which is mind the reasons I chose this

124
00:07:44,899 --> 00:07:48,089
and last but not least we got the user's

125
00:07:48,089 --> 00:07:52,089
it is guy we sort started mister james Conway

126
00:07:52,089 --> 00:07:55,149
hello James and the same ID

127
00:07:55,149 --> 00:07:59,000
click on their I'm and I do use is we've

128
00:07:59,000 --> 00:08:02,110
infirm ask for the password field addict so Vesta

129
00:08:02,110 --> 00:08:06,740
database the just to reiterate is not one single line if he be a code is so

130
00:08:06,740 --> 00:08:07,319
done

131
00:08:07,319 --> 00:08:12,459
through macros in continuous forms inquiries in all kinds of stuff

132
00:08:12,459 --> 00:08:16,149
so that's what we're gonna be makin a.m.

133
00:08:16,149 --> 00:08:20,479
crystalline xvideo you only talking about tables and ima gonna be moving

134
00:08:20,480 --> 00:08:21,370
into actually

135
00:08:21,370 --> 00:08:24,569
making specific objects for the state a race

136
00:08:24,569 --> 00:08:29,069
so please prolong I don't know how many videos is gonna be things can require a

137
00:08:29,069 --> 00:08:29,649
few

138
00:08:29,649 --> 00:08:33,569
and hopefully will learn something on CNNX video