From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Configure report controls

Configure report controls

From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)

Start my 1-month free trial

Configure report controls

- In our access reports we have several ways that we can configure the report controls. Probably the easiest way to configure those controls is using the report wizard because as you walk through the wizard you can group your data together, you can sort the data and it just makes it a lot easier to do both of those steps as you're creating your reports. In this video we'll use the wizard to create a brand new report and we'll group and sort the data as we go. I'll also show you how to insert fields and how to remove fields. Let's take a look at our 06_02 Report Controls database. I'm going to create a brand new report using the wizard and I'll use the 2016 Orders table. I'll go to Create, Report Wizard. Make sure the 2016 Orders table is selected and I'll go ahead and first select region and then customer. Remember the order in which you choose to move them to the selected fields is the order in which they're going to show on your report so try and think ahead as to which field you…

Contents