Report objects organize records and prepare them for the printed page. By using the Report wizard, found on the Create tab of the ribbon, and using the results of the Check In Details query as the source of the data, Adam will show you how to generate a report that reveals the history of each room at the Landon Hotel.
- The Access report object is great for taking…your data and organizing it for the printed page.…Let's build a quick report that organizes the data…being returned by the check-in details query…and sorts it out for each room at the hotel.…To do this I'm gonna come up to the create tab…and I'll find the reports section over here.…From here, I'm gonna choose the report wizard option.…Now just like when building our query,…the first thing we need to do is tell Access…where we want to get the data from.…But instead of choosing data from a table,…we're going to use the query…that we built in the last movie.…In this case I'll just select it…from the drop-down list here.…
Next we need to tell Access…which fields we want to use from that query.…I'm gonna take everything from the available field section…and move it over to selected fields.…And a shortcut way to do that is just to press…this double-headed arrow button here.…That will move everything from available to selected.…Go ahead and press the next button.…And the next thing we need to do is tell Access…
If you need a deeper dive into the topics discussed, check out Adam's Office 365: Access 2016 Essential Training course.
- Loading a premade template database
- Exploring the interface
- Defining data types
- Creating tables
- Defining table relationships
- Editing forms
- Creating queries and reports
- Editing reports in Layout view