WEBVTT Kind: captions Language: en 00:00:11.960 --> 00:00:14.270 In this example, I'd like to create a menu that we 00:00:14.270 --> 00:00:15.700 can print for our bakery 00:00:15.700 --> 00:00:18.660 that shows a list of our products and their prices. 00:00:18.660 --> 00:00:20.790 We're going to need to create a report that uses 00:00:20.790 --> 00:00:22.110 multiple tables, 00:00:22.110 --> 00:00:25.310 and the easiest way to do that is by using the Report Wizard. 00:00:25.310 --> 00:00:29.090 First, we'll go to the Create tab, and in the 00:00:29.090 --> 00:00:32.810 Reports group, select Report Wizard. 00:00:32.810 --> 00:00:34.820 We'll start by choosing the fields that we want in 00:00:34.820 --> 00:00:36.230 our report. 00:00:36.230 --> 00:00:37.610 If you click the drop-down arrow, 00:00:37.610 --> 00:00:41.239 you'll see a list of all of the tables and queries in your database. 00:00:41.239 --> 00:00:44.890 And we're going to add fields from several different tables. 00:00:44.890 --> 00:00:46.690 From the Categories table, we're going to need the 00:00:46.690 --> 00:00:48.559 Product Types field. 00:00:48.559 --> 00:00:50.730 And you can either double-click it, or click the 00:00:50.730 --> 00:00:52.789 right arrow button to add it. 00:00:52.789 --> 00:00:55.980 Next, we'll choose the Products table, and here 00:00:55.980 --> 00:01:00.829 we'll add the Product Name and Description. 00:01:00.829 --> 00:01:03.989 From the Sales Unit table, we'll add the Product Name, 00:01:03.989 --> 00:01:08.460 which in this case is just Dozen, Half Dozen, or Single. 00:01:08.460 --> 00:01:11.540 And finally, from the Menu Items table, we'll need 00:01:11.540 --> 00:01:14.100 the price. 00:01:14.100 --> 00:01:16.200 So all of these fields are going to be placed into 00:01:16.200 --> 00:01:18.130 our report. 00:01:18.130 --> 00:01:20.750 Now click Next. 00:01:20.750 --> 00:01:22.430 Since we're using multiple tables, 00:01:22.430 --> 00:01:26.380 we need decide how we want the tables to be organized on the page. 00:01:26.380 --> 00:01:29.140 If we had just used a single table or query, then 00:01:29.140 --> 00:01:31.479 it would have skipped this step. 00:01:31.479 --> 00:01:33.430 In this case, we want it to be organized by the 00:01:33.430 --> 00:01:35.450 Categories table. 00:01:35.450 --> 00:01:40.729 And to the right, you can see a kind of outline, which shows where each field will go. 00:01:40.729 --> 00:01:42.909 Now we'll go on to the next step. 00:01:42.909 --> 00:01:45.700 Here, you can change the way that the records are 00:01:45.700 --> 00:01:48.590 grouped by adding a grouping level. 00:01:48.590 --> 00:01:50.380 Much of the time, you won't need to do anything in 00:01:50.380 --> 00:01:51.439 this step, 00:01:51.439 --> 00:01:55.400 but if you have a very specific idea of how you want the report to be organized, 00:01:55.400 --> 00:01:57.229 then you can add a grouping level. 00:01:57.229 --> 00:01:59.310 For example, if we wanted the products to be 00:01:59.310 --> 00:02:00.310 grouped into 00:02:00.310 --> 00:02:04.509 dozen, half dozen, and single units, then we would add Sales Unit, 00:02:04.509 --> 00:02:07.619 and then use the arrows to change the Priority. 00:02:07.619 --> 00:02:09.729 But we don't really want that here, so I'll remove 00:02:09.729 --> 00:02:12.460 this and then click Next. 00:02:12.460 --> 00:02:16.620 Here, we can sort the records by up to four fields. 00:02:16.620 --> 00:02:19.100 I'm going to sort by Price, 00:02:19.100 --> 00:02:22.140 and I'll also change this to Descending so it 00:02:22.140 --> 00:02:24.110 will start with the highest price. 00:02:24.110 --> 00:02:26.730 And then click Next. 00:02:26.730 --> 00:02:28.580 There are a few different layout options that you 00:02:28.580 --> 00:02:30.580 can choose from. 00:02:30.580 --> 00:02:32.840 I'm going to select Block because it will tend to 00:02:32.840 --> 00:02:35.440 keep things on the same line. 00:02:35.440 --> 00:02:39.320 I'm going to leave the orientation as Portrait, 00:02:39.320 --> 00:02:41.970 and I'll also leave the auto-adjust option checked 00:02:41.970 --> 00:02:43.990 so we won't have to do quite as much adjusting at 00:02:43.990 --> 00:02:45.850 the end. 00:02:45.850 --> 00:02:48.840 And in the final step, you can type in a name. 00:02:48.840 --> 00:02:53.250 I'm going to call it Menu Report. 00:02:53.250 --> 00:02:54.720 And here you can choose whether you want it to 00:02:54.720 --> 00:02:57.230 open in Print Preview or Design view, 00:02:57.230 --> 00:03:00.260 but this won't actually affect the report. 00:03:00.260 --> 00:03:03.790 When you click Finish, it will create the Report. 00:03:03.790 --> 00:03:05.570 And you won't be able to go back into the Wizard 00:03:05.570 --> 00:03:06.960 to edit your report, 00:03:06.960 --> 00:03:09.790 but you can always go to Layout view to make any adjustments that you 00:03:09.790 --> 00:03:12.260 want. 00:03:12.260 --> 00:03:37.510 And here's our finished menu.