Affiliates

Amazon.com


Popular Microsoft Access Books

Building Microsoft Access Applications
Building Microsoft Access Applications
Author: John L. Viescas 

Access 2003 All-in-One Desk Reference for Dummies
Access 2003 All-in-One Desk Reference for Dummies
Author: Alan Simpson 

Access 2003 for Dummies
Access 2003 for Dummies
Author: John Kaufeld 

Office 2007 All-in-One Desk Reference For Dummies
Office 2007 All-in-One Desk Reference For Dummies
Author: Peter Weverka 

Microsoft Office Access 2003 Step by Step
Microsoft Office Access 2003 Step by Step
Author: Online Training Solutions Inc. 

Access 2007 Bible
Access 2007 Bible
Author: Michael R. Groh 

Microsoft Office Access
Microsoft Office Access
Author: Steve Lambert 

Beginning Access 2003 VBA
Beginning Access 2003 VBA
Author: Denise M. Gosnell 

Microsoft Office Access 2003
Microsoft Office Access 2003
Author: Gary B. Shelly, Thomas J. Cashman.... 

Popular MS Access Related Websites

Microsoft Corporation 













Microsoft Access 2007 Tutorials for beginners    

Welcome to MS Tips and Tricks
Welcome to MS Tips and Tricks - You are at the right place if you need tutorials for beginners - Online Microsoft Access tutorials for beginners, covering the following categories - Databases, Customization, Table, Forms, Queries, Reports, etc.,

  Microsoft Access Tips and Tricks for beginners
Reports {Tutorial for beginners}  
 
Written by Ravi Prakash  
Friday, 22 June 2007
Category MS Access 2007 - Reports.  
 
General Information
 
 
Data source
Create a form that shows several records
Create a report with the wizard
Create a report from blank template
Set up report properties
 
 
Reports summarize and present data stored on tables. A report can be executed at any time and it will always reflect the updated data of the data base. The information usually has a format that allows printing, but it's possible to be consulted in the screen, to be exported to another program or also to be sent by electronic mail. You can create a wide variety of reports in Microsoft Office Access 2007, from simplest to most complex. 
 
Later to choose the record's data source, a report wizard will assist you creating reports. 
 
Data source
 
A report consists on extracted information of a table or consults, as well as of the information stored in the design of the report, as labels, header and graphics. The table or query that provides the underlying data is knows as report's data source.. 
 
Create a report
 
1) In the exploration panel, clicks in the table or query that contains the data that wish to see in the report.
 
Illustration 1: Select the Files tables.
 
2) In the Create tab, in the group Reports, clicks in Report.
 
Illustration 2: Select the Report command.
 
3) Access creates the form and shows it in the Presentation View. Inside this view, changes of form's design can be made while it shows data.
 
Illustration 3: Report in presentation view.  Click here to view larger image.
 
Create a report with the wizard
 
In order to select with better criteria the fields that are going to appear in a report, you can use the report's Wizard instead of the previously mentioned tool.
 
4) In the exploration panel, clicks in the table or query that contains the data that wish to see in the form.
 
5) In the Create, in the group Reports, clicks in Report Wizard.
 
Illustration 4: Report Wizard tool.  Click here to view larger image.
 

 
Advertisement



Advertisement



Copyright MS Tips and Tricks
A Division of Gurijala and Company, 2006
Home - Tips and Tricks - Resources - Links - Contact - Site Map - Privacy Policy - Email Webmaster