1 00:00:01,370 --> 00:00:06,230 ok taxes 2013 sheet or hosted on me talking you through some airports 2 00:00:06,230 --> 00:00:09,269 to try to play along follow the link below the video to Thomas section a 3 00:00:09,269 --> 00:00:09,910 website 4 00:00:09,910 --> 00:00:13,949 download axis 2013 DB 23 5 00:00:13,949 --> 00:00:18,460 open up 2013 is on danse 6 00:00:18,460 --> 00:00:21,789 as just take a quick look at what we did in the previous 7 00:00:21,789 --> 00:00:25,410 video is if not for mine 8 00:00:25,410 --> 00:00:31,469 and 9 00:00:31,469 --> 00:00:35,629 regatta reports we made a guests we made a 10 00:00:35,630 --> 00:00:39,379 summary report now getting ready to offer for 11 00:00:39,378 --> 00:00:43,429 now I'm making a summer full Arctic made a summary report 12 00:00:43,429 --> 00:00:47,988 the detail for was wrong with me detailed report gives us 13 00:00:47,988 --> 00:00:51,349 information about booking bookings 14 00:00:51,350 --> 00:00:55,439 relate to guess so for example this cast it has a two bookings it gives us some 15 00:00:55,439 --> 00:01:00,429 if my smoking storm in a tea today just cry summer for a summary report 16 00:01:00,429 --> 00:01:05,228 in this case for guests is just gonna list all of the guests in their contact 17 00:01:05,228 --> 00:01:08,250 details so you might want to be in a situation where you print off 18 00:01:08,250 --> 00:01:12,640 palaces guess the contact details and then on now you can offer 19 00:01:12,640 --> 00:01:17,400 may be found them in find us there are come again people to send them an email 20 00:01:17,400 --> 00:01:18,270 because we live in 21 00:01:18,269 --> 00:01:22,548 to 21st century is that right yet 21st century 22 00:01:22,549 --> 00:01:27,189 addict so a.m. let's have a look at the guests table 23 00:01:27,188 --> 00:01:32,139 to information is in there so 24 00:01:32,140 --> 00:01:35,200 summary reports in this case is probably gonna be 25 00:01:35,200 --> 00:01:38,490 landscape you I am 26 00:01:38,489 --> 00:01:43,429 read not only to guessed it: total for some lost time you have a nato that 27 00:01:43,430 --> 00:01:45,210 names will too together 28 00:01:45,209 --> 00:01:48,449 so why should I get all this information on Dec 7 notes 29 00:01:48,450 --> 00:01:51,560 site close that's what we gonna do 30 00:01:51,560 --> 00:01:56,079 is Creek weary really use a query 31 00:01:56,078 --> 00:02:00,149 to @comcast.net copper sales and also to I am 32 00:02:00,149 --> 00:02:03,149 organize the data tough backorder 33 00:02:03,149 --> 00:02:06,859 side table guests at close 34 00:02:06,859 --> 00:02:11,949 gonna burn one is just a query for summer for not commit guessed it: 35 00:02:11,949 --> 00:02:16,659 I will need title tournament at first and last name gonna go 36 00:02:16,659 --> 00:02:22,509 split together to kick 'em builder 37 00:02:22,509 --> 00:02:26,919 Tappan 38 00:02:26,919 --> 00:02:31,988 are pricey perk side name peco's 39 00:02:31,989 --> 00:02:35,090 last name ampersand 40 00:02:35,090 --> 00:02:39,409 ok rotation lock on a space close but a small campus and 41 00:02:39,409 --> 00:02:42,628 first name okay 42 00:02:42,628 --> 00:02:46,030 if you from there his contract tonight two names 43 00:02:46,030 --> 00:02:50,250 other than the obvious enough backwater so drop it back to design view 44 00:02:50,250 --> 00:02:54,889 and we changes sought to sending 45 00:02:54,889 --> 00:02:59,908 but lost to okay sorry forgot the name to the guest societal 46 00:02:59,908 --> 00:03:05,250 and now it's just a personal information and see how much we think we can share 47 00:03:05,250 --> 00:03:12,250 for 48 00:03:12,389 --> 00:03:16,829 you live to be rocked 49 00:03:16,830 --> 00:03:22,370 gonna City OK school so if concatenated name to be put into affect for the 50 00:03:22,370 --> 00:03:22,759 service 51 00:03:22,759 --> 00:03:25,759 save that call cleary and 52 00:03:25,759 --> 00:03:30,840 truck for sale in a sec look at your queries 26 property for change 53 00:03:30,840 --> 00:03:34,060 Crary guest summary 54 00:03:34,060 --> 00:03:37,590 sort descending the selective colour 55 00:03:37,590 --> 00:03:41,598 why not summary 56 00:03:41,598 --> 00:03:45,408 sorted sending cutie 57 00:03:45,408 --> 00:03:48,840 so closer go away 58 00:03:48,840 --> 00:03:53,239 cue I'm going to click on that one query guess some resource ending 59 00:03:53,239 --> 00:03:56,908 she go to create and just grateful 60 00:03:56,908 --> 00:04:02,068 which happiness report to access it decided to produce tux 61 00:04:02,068 --> 00:04:06,780 funky said asked about okie dokie 62 00:04:06,780 --> 00:04:10,009 a first thing we should do is 63 00:04:10,009 --> 00:04:13,469 we need to change the page to landscapes a click on page setup 64 00:04:13,469 --> 00:04:17,060 I landscape and just line here 65 00:04:17,060 --> 00:04:22,040 which you see faintly router must that is the edges to page so obviously 66 00:04:22,040 --> 00:04:27,949 many to a.m. adjusted with cities field so it doesn't go over there to the page 67 00:04:27,949 --> 00:04:34,949 so stupor clicking and dragging 68 00:04:45,939 --> 00:04:49,329 shame in a and 69 00:04:49,329 --> 00:04:56,329 no space email Snagit and Taylor in that case 70 00:04:56,730 --> 00:05:00,060 caring attitude 71 00:05:00,060 --> 00:05:03,629 middle addresses we try it chiat 72 00:05:03,629 --> 00:05:08,750 point smack dab why the email addresses need to be pretty wide issue 73 00:05:08,750 --> 00:05:12,250 because they can't go on a little bit I'm 74 00:05:12,250 --> 00:05:18,470 okay that's fine distilled here's account the number guess I believe that 75 00:05:18,470 --> 00:05:18,940 where 76 00:05:18,939 --> 00:05:25,939 miss track fees over here 77 00:05:29,170 --> 00:05:34,240 click click guest so mine and 78 00:05:34,240 --> 00:05:38,500 we shall save this schooler 79 00:05:38,500 --> 00:05:41,970 for for cast summary: 80 00:05:41,970 --> 00:05:45,320 I'll discover the source sending for that and 81 00:05:45,319 --> 00:05:49,240 last but not least for to come 82 00:05:49,240 --> 00:05:52,680 on the titles go to range selects Road 83 00:05:52,680 --> 00:05:56,840 for format border-style: 84 00:05:56,839 --> 00:05:59,869 transparent before you 85 00:05:59,870 --> 00:06:04,170 we get fat and back to their views per fishy 86 00:06:04,170 --> 00:06:07,500 the pool former 87 00:06:07,500 --> 00:06:11,879 caption cast 88 00:06:11,879 --> 00:06:16,689 summary say 89 00:06:16,689 --> 00:06:20,759 if andar district if we go to print preview 90 00:06:20,759 --> 00:06:26,120 she see that that's what I luck in print preview below we actually want things 91 00:06:26,120 --> 00:06:30,399 Street picky should never border around as well 92 00:06:30,399 --> 00:06:35,689 a.m. yes must have noticed 93 00:06:35,689 --> 00:06:40,029 for so on y-axis create some or launching looks particularly nice I 94 00:06:40,029 --> 00:06:40,979 expect without 95 00:06:40,980 --> 00:06:44,100 what do I know I okay 96 00:06:44,100 --> 00:06:47,590 so that's a very simple guess summaries that shit list is 97 00:06:47,589 --> 00:06:51,859 day you've got use a query to concatenate diffusion a organize it they 98 00:06:51,860 --> 00:06:53,980 tell you whatever you gotta make a decision about 99 00:06:53,980 --> 00:06:58,759 what data goes in what day it goes out being a summary reports quite normal not 100 00:06:58,759 --> 00:07:00,449 have schools with a Syrian 101 00:07:00,449 --> 00:07:04,439 a so if you wanna actually saw a drill into it need something like a detailed 102 00:07:04,439 --> 00:07:05,430 reports 103 00:07:05,430 --> 00:07:09,509 receps fine so this is to guess report only showing in the next video 104 00:07:09,509 --> 00:07:13,740 he is how to 105 00:07:13,740 --> 00:07:17,870 call 106 00:07:17,870 --> 00:07:20,949 will be able to call both report suggests active year for and to get 107 00:07:20,949 --> 00:07:21,939 summer for 108 00:07:21,939 --> 00:07:25,660 from I'm the 109 00:07:25,660 --> 00:07:31,600 guest report form sandwiches on this did notice an application forms 110 00:07:31,600 --> 00:07:34,400 okay so thanks for watching and I see that