From the course: Building Solutions Using Excel and Access 2019 Together
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Build a basic report
From the course: Building Solutions Using Excel and Access 2019 Together
Build a basic report
- [Instructor] Now, I know we use Excel for a lot of reporting, but it doesn't always have the most user-friendly tools for some types of reports. We do a lot of heavy formatting just to turn it into a PDF. And then once one change occurs, we start the whole process back over again. Let's go build a simple report. We remember department list is our linked list, and again, when it gets updated, so does our database. And then we have the department list with names, so let's go ahead and right click and go to the design view. Again, this brings in all of the additional things we need like the department list names, the actual department list and the zip codes. I want to build a report on this that's grouped by the department and then puts all the people in their department. All right, go ahead and right click and close that. I'll go to create, I'll choose report wizard. Now, my report wizard screen pops open with department list with names already selected, because I have it selected on…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.