Report objects can help cut through the clutter and surface important details about the state of your business. In this movie, Adam will show you how different reports within the Task Manager database can reveal drastically different details that can help shape management decisions at the Landon Hotel.
- [Voiceover] I've gone ahead and added some additional…contacts and tasks to our Landon Hotel…task manager database.…Here on the main form,…you can see that they're listed based off of the priority…with the highest priority task listed here at the top.…Using your report, we can view the same information…in alternate ways.…The reports that came with this template can be found…either in the main form area here…underneath this report drop-down menu,…and this is created as a custom interactive element,…or we can always go over to the navigation pane…and scroll down to find all of the reports listed here.…
I'm gonna find the report called Tasks by Assigned To…and double-click on it to open it.…This report groups the tasks by the person…so I can quickly see who in the organization…might be over-tasked and who might be able to take on…some additional responsibilities.…I have each employee's name listed here…followed by a listing of all the tasks…that have been assigned to them.…At the bottom, I have a subtotal that counts up…
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