From the course: Microsoft Access: Forms and Reports

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Edit the report's data source

Edit the report's data source

From the course: Microsoft Access: Forms and Reports

Start my 1-month free trial Buy for my team

Edit the report's data source

“

- [Instructor] Now, just like when working with forms, we can also access the Property Sheet to continue working with the different elements in the Reports layout. I'll open up the Property Sheet, and that's what it looks like here. Then we can take a look at the Data tab and find the Record Source property. It's currently a select statement or a query. This is what the wizard built for us. This query is embedded into the design of the report. The other option is to use the drop-down menu and link the report to an existing table or query from the navigation pane. Alternatively, you can click on the Build button over here on the right if you wanted to edit the embedded query. When I do that, it opens up a query design window, and the tab confirms that I'm inside of the Orders by State report and I'm in a query builder session inside of that report. You can also run this query with the button on the ribbon, just like any…

Contents