1. Home
  2. Computing & Technology
  3. Databases
Microsoft Access Reports Tutorial
Part 3: Finishing Touches
 More of this Feature
• Part 1: Getting Started 
• Part 2: Selecting the Data 
 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 

8.  Choose the formatting options.  In the next screen, we’re presented with some formatting options.  We’ll accept the default tabular layout but let’s change the page orientation to landscape to ensure the data fits properly on the page.  Once you’ve completed this, click the Next button to continue.

9.  Select a report style.  The next screen asks you to select a style for your report.  Click on the various options and you’ll see a preview of your report in that style in the left portion of the screen.  We’ll use the Corporate style for this report.  Select this option and then click the Next button to move on.




   
Chose Formatting Options

 
Select a Report Style  

10.  Add the title.  Finally, we need to give the report a title.  Access will automatically provide a nicely formatted title at the top of the screen, with the appearance shown in the report style you selected during the previous step.  Let’s call our report “Employee Home Phone List.”  Make sure that the “Preview the report” option is selected and click on Finish to see our report!

 
Adding a Title

 
Our Finished Product

Congratulations, you've successfully created a report in Microsoft Access!  The final report you see should appear similar to the one presented above.  When you close this report, you'll once again see the main database menu illustrated below.  Notice that your report now appears in the list (I've added a red box to the figure below for your viewing convenience, this won't appear on your screen.)  In the future, you can simply double-click on the report title and a new report will instantly be generated with up-to-date information from your database.


Updated Reports Menu

I hope you've enjoyed following along with this tutorial.  Be sure to experiment on your own with the various report options and you'll be an expert in no time!

 Next page > > 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.