From the course: Access Basics for Excel Users
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Report Wizard - Microsoft Access Tutorial
From the course: Access Basics for Excel Users
Report Wizard
- [Narrator] Preparing tabular reports using Access data is easy. Open up the database file, 04_01_Reports, to follow along with me. From the create menu, go ahead and select the report wizard. This allows us to very quickly and easily create new reports from scratch. Let's say that we want to create a yearly summary report on the employment data for California. To start with, let's go ahead and move the following fields from our available fields to our selected fields. Let's move the year. Now let's move the labor force, the employment, and lastly, the unemployment field across to the selected fields. Let's go ahead and click on next. Now let's move the year across to the right. This allows us to group the data by year instead of showing it in tabular format. You'll see in a moment what it looks like. Now let's go ahead and click on next, and now let's click on summary options and we want to check the sum box for…
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.