Open Directory Site Microsoft Access2000 Tutorials

Home | Word | Excel | AccessFrontPage | Outlook | PowerPoint | Internet Explorer

Home >> Microsoft Office XP >> Access 2000 >> Reports

Reports

Text               

Reports can be very complex.  In this tutorial we'll learn the basics.  A good manual, or some knowledgeable assistance, will be essential to mastering reports.  

 

There are several types of reports.  We'll use the Wizards to design some.

 

If you are not in the Person: Database main window screen with the Table, Queries, Forms, Reports, etc., click-on Window in the Menu Bar and then on Person: Database at the bottom of the menu.  Also, make sure that you have closed any Tables, Forms, or Queries on which you are working.

 

 

 

 

 

In the Person: Database widow click-on the Report button.  Then, click-on the New Button See the arrows on the image at the right.


 

 

 

The following New Report menu window will appear.

 

First, click-on Report Wizard in the New Report menu screen.  Then, in the area to the right of: Choose the table or query where the object’s data comes from:, click-on the down triangle and select Personnel.  Then click-on OK.

 

 

The following Report Wizard Menu screen should appear:

 

 

 

 

 

 

Read all the information in the window.  Only the fields you select from your table will show-in the report.  To bring fields into the report individually you click-on the name of the field in the list of fields in the area under Available Fields: and then click-on the >.  The order, on which you click-on the fields, will be their order in the report. The >> brings over all of the fields.  The <  brings back one of the fields which you have selected and << brings back all of the fields, if you make a mistake, or want to start over. 


 

 

 

 

 

So let's begin.  Click-on First Name, then click-on > (notice how the First Name field went from the Available Fields: to Selected Fields:).  Now do the same with the Last Name, State, Gender and Salary fields.  These are the fields that will appear in or first report.

 

Your Report Wizard screen should look like the one below.

 

 

 

 

 

If it does, click-on the Next> Button.

Cheap Web Hosting Articles - Web Site Design & Web Hosting Tutorials - Domain Hosting