WEBVTT Kind: captions Language: en 00:00:11.990 --> 00:00:14.080 Access gives you a lot of flexibility when it 00:00:14.080 --> 00:00:16.150 comes to formatting a report. 00:00:16.150 --> 00:00:18.750 You can use any fonts and colors that you want, 00:00:18.750 --> 00:00:20.410 you can change the theme, 00:00:20.410 --> 00:00:23.770 and you can even add a header, footer, and company logo. 00:00:23.770 --> 00:00:26.520 In this example, I'd like to start out by changing 00:00:26.520 --> 00:00:27.789 the fonts, 00:00:27.789 --> 00:00:32.369 and I also want to put the descriptions in italics, and make the product types bold. 00:00:32.369 --> 00:00:34.900 To do this, we'll need to be in Layout view. 00:00:34.900 --> 00:00:39.420 First, select the column that you want to change. 00:00:39.420 --> 00:00:41.780 You can also hold down the shift key if you want 00:00:41.780 --> 00:00:44.360 to select multiple columns. 00:00:44.360 --> 00:00:47.699 Then go to the Format tab, and choose the font 00:00:47.699 --> 00:00:50.460 that you want. 00:00:50.460 --> 00:00:53.809 I'm going to pick Cambria. 00:00:53.809 --> 00:00:56.210 Now to make the descriptions italic, I'll select 00:00:56.210 --> 00:00:58.280 them and click the Italic command. 00:00:58.280 --> 00:01:02.089 And then I'll select the product type and make it 00:01:02.089 --> 00:01:03.769 bold. 00:01:03.769 --> 00:01:07.010 I think I'll go ahead and delete the field headers. 00:01:07.010 --> 00:01:08.790 Anybody who sees this menu will know what each 00:01:08.790 --> 00:01:09.720 column is, 00:01:09.720 --> 00:01:12.610 so they don't really need to be labeled. 00:01:12.610 --> 00:01:14.689 At this point, we can switch to Print Preview to 00:01:14.689 --> 00:01:16.750 see how it looks. 00:01:16.750 --> 00:01:18.590 The new font and the italics really help to give 00:01:18.590 --> 00:01:20.590 it a more distinctive look. 00:01:20.590 --> 00:01:23.280 Now, I'd like to add a page header, which will 00:01:23.280 --> 00:01:25.590 include the address of our bakery. 00:01:25.590 --> 00:01:29.939 To do this we'll need to go into Design view, which we haven't looked at yet. 00:01:29.939 --> 00:01:32.189 Here, you can make some of the same types of 00:01:32.189 --> 00:01:34.499 adjustments you can make in Layout view, 00:01:34.499 --> 00:01:36.749 but it also lets you do some other things like 00:01:36.749 --> 00:01:39.280 adding Headers and Footers. 00:01:39.280 --> 00:01:42.030 You'll see several gray bars, and find the one 00:01:42.030 --> 00:01:44.429 that says Page Header. 00:01:44.429 --> 00:01:46.030 You'll need to make sure that there's some empty 00:01:46.030 --> 00:01:47.240 space below it, 00:01:47.240 --> 00:01:49.179 and if there isn't any space, then you'll need 00:01:49.179 --> 00:01:53.119 to click on this border and drag it down. 00:01:53.119 --> 00:01:57.729 Then, in the Design tab, find the Controls group, 00:01:57.729 --> 00:01:59.840 and you'll want to click on this icon, which is 00:01:59.840 --> 00:02:02.299 the Label command. 00:02:02.299 --> 00:02:04.439 And then in your page header, click and drag to 00:02:04.439 --> 00:02:06.490 create a box. 00:02:06.490 --> 00:02:08.830 You can type whatever you want here, and I'm going 00:02:08.830 --> 00:02:09.220 to type 00:02:09.220 --> 00:02:13.850 our bakery's address, phone number, and email address. 00:02:13.850 --> 00:02:18.670 And if you want, you can also edit the Report Header, Page Footer, 00:02:18.670 --> 00:02:21.590 and Report Footer in the same way. 00:02:21.590 --> 00:02:23.280 Let's go back to Print Preview to see how our 00:02:23.280 --> 00:02:25.160 header looks. 00:02:25.160 --> 00:02:28.530 I think it looks good, so I'm not going to change 00:02:28.530 --> 00:02:29.940 anything. 00:02:29.940 --> 00:02:35.770 Now if you scroll down, you can see that today's date and the page number are in the Page Footer. 00:02:35.770 --> 00:02:37.810 These were automatically added for us because we 00:02:37.810 --> 00:02:40.370 created this report with the Report Wizard. 00:02:40.370 --> 00:02:43.160 However, you can also add them manually by going 00:02:43.160 --> 00:02:46.650 to either Layout view or Design view and then 00:02:46.650 --> 00:02:49.070 clicking Page Numbers or Date and Time on the 00:02:49.070 --> 00:02:51.080 Design tab. 00:02:51.080 --> 00:02:53.020 Now one thing that will make this report look much 00:02:53.020 --> 00:02:55.730 more complete is a company logo, 00:02:55.730 --> 00:02:58.700 so I'll click the Logo command. 00:02:58.700 --> 00:03:00.930 And then you can select the picture that you want, 00:03:00.930 --> 00:03:02.630 and then click OK. 00:03:02.630 --> 00:03:05.930 Okay, now this may be hard to see, but our logo 00:03:05.930 --> 00:03:08.340 has been added in the Report Header, 00:03:08.340 --> 00:03:10.030 and it has an orange box around it. 00:03:10.030 --> 00:03:12.180 And I'm just going to drag this corner to make it 00:03:12.180 --> 00:03:13.340 larger, 00:03:13.340 --> 00:03:19.090 and then I'll move it over to the center of the page. 00:03:19.090 --> 00:03:22.470 I'll also move the title to the center. 00:03:22.470 --> 00:03:24.260 And I think this title would look better if it 00:03:24.260 --> 00:03:29.780 just said Menu. 00:03:29.780 --> 00:03:31.960 And finally, you can change the overall look of 00:03:31.960 --> 00:03:34.580 your report by selecting a different theme. 00:03:34.580 --> 00:03:38.110 A theme is a set of colors and fonts that applies 00:03:38.110 --> 00:03:40.170 to your entire database. 00:03:40.170 --> 00:03:42.270 That means it can effect your other objects as 00:03:42.270 --> 00:03:43.780 well. 00:03:43.780 --> 00:03:45.810 If you want, you can even mix and match colors and 00:03:45.810 --> 00:03:50.480 fonts from different themes. 00:03:50.480 --> 00:03:52.130 All of these little details that we've added to 00:03:52.130 --> 00:03:54.210 our report make a big difference, 00:03:54.210 --> 00:04:01.210 and now it actually looks like real menu that we can print and give to our customers.