1. Home
  2. Computing & Technology
  3. Databases
Microsoft Access Reports Tutorial
Part 2: Selecting the Data
 More of this Feature
• Part 1: Getting Started 
• Part 3: Finishing Touches
 Related Resources
• Microsoft Access Fundamentals
• Creating a Query in Microsoft Access
• Microsoft Access Forms
 From Other Guides
• MS Access Contact Manager
• Gaining Access
 Elsewhere on the Web
• Access 2000 Tour
• Access FAQ 

5. Select the fields to include.  Use the ‘>’ button to move over the desired fields.  Note that the order you place the fields in the right column determines the default order they will appear in your report.  Remember that we're creating an employee telephone directory for our senior management.  Let's keep the information contained in it simple -- the first and last name of each employee, their title and their home telephone number.  Go ahead and select these fields.  When you are satisfied, click the Next button.

6.  Select the grouping levels.  At this stage, you can select one or more grouping levels to refine the order in which our report data is presented.  For example, we may wish to break down our telephone directory by department so that all of the members of each department are listed separately.  However, due to the small number of employees in our database, this is not necessary for our report.  Go ahead and simply click on the Next button to bypass this step.  You may wish to return here later and experiment with grouping levels.

 

   
Select the fields to include

 

 
Choose the grouping levels

 

 

7.  Choose your sorting options.  In order to make reports useful, we often want to sort our results by one or more attributes.  In the case of our telephone directory, the logical choice is to sort by the last name of each employee.  Select this attribute from the first drop-down box and then click the Next button to continue.

   
Choose the sorting options

 In the next section, we'll put the finishing touches on our report.  Read on for more!

 Next page > Finishing Touches  > Page 1, 2, 3

Explore Databases
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Databases

©2009 About.com, a part of The New York Times Company.

All rights reserved.