WEBVTT Kind: captions Language: en 00:00:11.490 --> 00:00:15.580 In this example, I'd like to create a menu that we can print for our bakery that shows 00:00:15.580 --> 00:00:18.000 a list of our products and their prices. 00:00:18.000 --> 00:00:22.470 We're going to need to create a report that uses multiple tables, and the easiest way 00:00:22.470 --> 00:00:24.920 to do that is by using the Report Wizard. 00:00:24.920 --> 00:00:33.140 First, we'll go to the Create tab… and in the Reports group, select Report Wizard. 00:00:33.140 --> 00:00:36.710 We'll start by choosing the fields that we want in our report. 00:00:36.710 --> 00:00:40.390 If you click the drop-down arrow, you'll see a list of all of the tables and queries in 00:00:40.390 --> 00:00:41.780 your database. 00:00:41.780 --> 00:00:45.420 And we're going to add fields from several different tables. 00:00:45.420 --> 00:00:50.040 From the Categories table… we're going to need the Product Types field. 00:00:50.040 --> 00:00:55.440 You can either double-click it, or click the right arrow button to add it. 00:00:55.440 --> 00:01:04.580 Next we'll choose the Products table… and here we'll add the Product Name and Description. 00:01:04.580 --> 00:01:10.700 From the Sales Unit table… we'll add the Product Name (which in this case is just dozen, 00:01:10.700 --> 00:01:13.909 half dozen, or single). 00:01:13.909 --> 00:01:21.060 And finally, from the Menu Items table… we'll need the Price. 00:01:21.060 --> 00:01:25.909 So all of these fields are going to be placed into our report. 00:01:25.909 --> 00:01:28.740 Now click Next. 00:01:28.740 --> 00:01:32.920 Since we're using multiple tables, we need decide how we want the tables to be organized 00:01:32.920 --> 00:01:34.579 on the page. 00:01:34.579 --> 00:01:39.640 If we had just used a single table or query, then it would have skipped this step. 00:01:39.640 --> 00:01:44.390 In this case, we want it to be organized by the Categories table… and to the right, 00:01:44.390 --> 00:01:49.609 you can see a kind of outline, which shows where each field will go. 00:01:49.609 --> 00:01:51.859 Now we'll go onto the next step. 00:01:51.859 --> 00:01:57.590 Here, you can change the way that the records are grouped by adding a grouping level. 00:01:57.590 --> 00:02:01.759 Much of the time, you won't need to do anything in this step, but if you have a very specific 00:02:01.759 --> 00:02:06.869 idea of how you want the report to be organized, then you can add a grouping level. 00:02:06.869 --> 00:02:10.940 For example, if we wanted the products to be grouped into dozen, half dozen, and single 00:02:10.940 --> 00:02:17.950 units, then we would add Sales Unit… and then use the arrows to change the Priority. 00:02:17.950 --> 00:02:24.390 But we don't really want that here, so I'll remove this… and then click Next. 00:02:24.390 --> 00:02:29.010 Here, we can sort the records by up to four fields. 00:02:29.010 --> 00:02:35.920 I'm going to sort by Price… and I'll also change this to Descending… so it will start 00:02:35.920 --> 00:02:38.060 with the highest price. 00:02:38.060 --> 00:02:41.280 And then click Next. 00:02:41.280 --> 00:02:44.610 There are a few different layout options that you can choose from. 00:02:44.610 --> 00:02:48.980 I'm going to select Block because it will tend to keep things on the same line. 00:02:48.980 --> 00:02:55.340 I'm going to leave the orientation as Portrait, and I'll also leave the auto-adjust option 00:02:55.340 --> 00:03:01.720 checked so that we won't have to do quite as much adjusting at the end. 00:03:01.720 --> 00:03:04.470 And in the final step, you can type in a name. 00:03:04.470 --> 00:03:08.680 I'm going to call it Menu Report. 00:03:08.680 --> 00:03:12.651 And here you can choose whether you want it to open in Print Preview or Design view, but 00:03:12.651 --> 00:03:16.090 this won't actually affect the report. 00:03:16.090 --> 00:03:19.610 When you click Finish, it will create the Report. 00:03:19.610 --> 00:03:23.240 And you won't be able to go back into the Wizard to edit your report, but you can always 00:03:23.240 --> 00:03:28.070 go to Layout view to make any adjustments that you want. 00:03:28.070 --> 00:03:29.260 And here's our finished menu.