WEBVTT Kind: captions Language: en 00:00:09.440 --> 00:00:13.519 In this example, I'd like to create a menu that we can print for our bakery that shows 00:00:13.519 --> 00:00:16.110 a list of our products and their prices. 00:00:16.110 --> 00:00:20.340 We're going to need to create a report that uses multiple tables, and the easiest way 00:00:20.340 --> 00:00:22.830 to do that is by using the Report Wizard. 00:00:22.830 --> 00:00:31.230 First, we'll go to the Create tab… and in the Reports group, select Report Wizard. 00:00:31.230 --> 00:00:34.860 We'll start by choosing the fields that we want in our report. 00:00:34.860 --> 00:00:38.550 If you click the drop-down arrow, you'll see a list of all of the tables and queries in 00:00:38.550 --> 00:00:39.860 your database. 00:00:39.860 --> 00:00:43.500 And we're going to add fields from several different tables. 00:00:43.500 --> 00:00:48.340 From the Categories table… we're going to need the Product Types field. 00:00:48.340 --> 00:00:53.920 You can either double-click it, or click the right arrow button to add it. 00:00:53.920 --> 00:01:03.949 Next we'll choose the Products table… and here we'll add the Product Name and Description. 00:01:03.949 --> 00:01:10.479 From the Sales Unit table… we'll add the Product Name (which in this case is just dozen, 00:01:10.479 --> 00:01:13.670 half dozen, or single). 00:01:13.670 --> 00:01:21.300 And finally, from the Menu Items table… we'll need the Price. 00:01:21.300 --> 00:01:26.150 So all of these fields are going to be placed into our report. 00:01:26.150 --> 00:01:29.600 Now click Next. 00:01:29.600 --> 00:01:33.780 Since we're using multiple tables, we need decide how we want the tables to be organized 00:01:33.780 --> 00:01:35.430 on the page. 00:01:35.430 --> 00:01:40.700 If we had just used a single table or query, then it would have skipped this step. 00:01:40.700 --> 00:01:45.160 In this case, we want it to be organized by the Categories table, and to the right, you 00:01:45.160 --> 00:01:50.640 can see a kind of outline, which shows where each field will go. 00:01:50.640 --> 00:01:53.190 Now we'll go onto the next step. 00:01:53.190 --> 00:01:59.230 Here, you can change the way that the records are grouped by adding a grouping level. 00:01:59.230 --> 00:02:03.390 Much of the time, you won't need to do anything in this step, but if you have a very specific 00:02:03.390 --> 00:02:08.500 idea of how you want the report to be organized, then you can add a grouping level. 00:02:08.500 --> 00:02:12.580 For example, if we wanted the products to be grouped into dozen, half dozen, and single 00:02:12.580 --> 00:02:19.420 units, then we would add Sales Unit… and then use the arrows to change the Priority. 00:02:19.420 --> 00:02:26.120 But we don't really want that here, so I'll remove this… and then click Next. 00:02:26.120 --> 00:02:30.760 Here, we can sort the records by up to four fields. 00:02:30.760 --> 00:02:37.500 I'm going to sort by Price… and I'll also change this to Descending… so it will start 00:02:37.500 --> 00:02:39.980 with the highest price. 00:02:39.980 --> 00:02:43.060 And then click Next. 00:02:43.060 --> 00:02:46.410 There are a few different layout options that you can choose from. 00:02:46.410 --> 00:02:50.730 I'm going to select Block because it will tend to keep things on the same line. 00:02:50.730 --> 00:02:57.130 I'm going to leave the orientation as Portrait, and I'll also leave the auto-adjust option 00:02:57.130 --> 00:03:03.740 checked so that we won't have to do quite as much adjusting at the end. 00:03:03.740 --> 00:03:06.490 And in the final step, you can type in a name. 00:03:06.490 --> 00:03:10.900 I'm going to call it Menu Report. 00:03:10.900 --> 00:03:14.871 And here you can choose whether you want it to open in Print Preview or Design view, but 00:03:14.871 --> 00:03:18.480 this won't actually affect the report. 00:03:18.480 --> 00:03:23.270 When you click Finish, it will create the Report. 00:03:23.270 --> 00:03:26.910 And you won't be able to go back into the Wizard to edit your report, but you can always 00:03:26.910 --> 00:03:29.660 go to Layout view to make any adjustments that you want.