NAH IF I GOTTA DO THIS VIRTUAL SCHOOL U GOTTA SUFFER WIT ME00:00:00 TEACHER: Access also provides robust reporting capabilities. In this topic, we'll look at the basics of creating a report.
Section 2
00:00:00
TEACHER: So as the database starts to have useful information in it, there are going to be, certainly, the need to produce reports that we can use for analysis. And then, possibly, we would want to publish those reports either in digital form or in print form.
00:00:16
We have a number of different report creation tools. You can create reports, essentially, based on the data in tables or more likely the data in queries. The Report Tool allows you to create a report that includes all the fields in a table or query. The report would be displayed in the Layout view. You're going to use this when you
00:00:35
want to start with all the fields and then remove the fields you don't want to use. You can start with a blank report and manually add fields from tables and queries. The report would also be displayed in the Layout view, and you can create it by adding and positioning controls. This gives you a bit more flexibility because you can do it exactly according to your requirements.
00:00:58
So, typically, you'd use this when you'd like to be in with no fields and then just one by one add them. It's also a good choice if you want to create a report with data separated into multiple columns. Report design--you can create a new report or edit an existing one.
00:01:15
This is using the Design view. And you can add fields from tables and queries. You would use this when you're building a new report, typically, that's based on an old one. And then you also have a wizard-- a graphical wizard that walks you through the process of adding fields from tables and queries, grouping, sorting, data, customizing
00:01:34
the layout of the report, basically, lets you do everything. And so we typically will use this if you just like the ability to use a wizard that is going to guide you through the process.
Section 3
00:00:00
TEACHER: So the Report Wizard is seen here, and we'll walk you through the steps of creating a report. That report can be based on one or more tables, and then it allows you to select the fields from those tables that you want to include in the report. There are going to be, additionally, some options for grouping and sorting data
00:00:18
and customizing the layout. Those are going to be on the upcoming pages in the Wizard as we will see here shortly.
Section 5
00:00:00
TEACHER: So in this demonstration we're going to start the process of working with reports and access. We have an inventory reporting database here that we're going to use. It's got information about departments, inventory, and suppliers.
00:00:18
And so the scenario is that we periodically prepare an updated list of all of the department codes. And we do this as a cheat sheet for employees so that when they're counting inventory, when they're placing orders, and so forth, they can see that information. So let's just go and walk through the process of doing that. We need to create a report.
00:00:41
We need to do it from a particular table. So logically, we would select that table. And that would be the basis of our report. So with the table selected, we would go up and select Create. And then we have the Reports area here. So we have Report, Report Design, Blank Report, and Report Wizard. Let's just click on Report first.