How can I make report using MS Access?

Asked By Labu07 100 points N/A Posted on - 05/08/2011

Dear all,

I'm using MS Access 2003. I have a large database with lots of information. I can input data in MS Access but I don't know how to make a compiled report. Most importantly, I want to make a report with the exact requirements that I need in my report.

Please let me know if anyone has any instructions which will be most helpful for me. Thanks.

Labu

• Status: Open
• Question Views: 976
• Answer Count: 5
• Vote Up 10 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by bappy

Go To Solution

Best Answer

Best Answer

Answered By bappy 0 points N/A #91033

How can I make report using MS Access?

To make a report using Access you have to follow some specific procedures. You can make your report as per your requirements. Here is the procedure which you have follow:

1. Open your Access Database and click on Reports located under the Objects field on the left hand side.
2. On the top toolbar click on the New button to start a new report.
3. In the report window select Report Wizard and below that choose from the drop down list which query or table you want to gather data to create the report.
4. After selecting correct data click Ok.

Now as you mentioned that you need a specific requirement which you need in your report. This part will allow you select the various fields from the table or query you selected.

1. Highlight the information in the available fields and press the arrow button to move it into the selected fields.
2. Click on next.
3. After clicking you will see a window where you can select to add grouping to various parts of your data.
4. After adding data then just click next. Now you will see a dialog box where you will find which order you want to make your data. Now clicking next you will see a dialog box where you can choose the layout of the report like Layout= Tabular, Orientation=portrait.
5. After adjusting then click next.
6. Next you will choose the style or appearance of the report. Once again use your best creative judgment.

You are almost done. 

       7. Choose a name for your report. Make sure you have given good name of your report and other database user can find your report easily.

How's that? Hope you can able to do it. Let me know whether you can do it or not. 

Cheers!

Be Happy!

About bappy

Questions
0

Answers
55

Best Answers
14

• Vote Up 0 Vote Down

• Posted on - 05/08/2011
• Question Category: MS Access

Answered By Labu07 100 points N/A #91034

How can I make report using MS Access?

Thanks. It was really helpful and I can be able to do it. I can make my report with specific queries as per your instruction.

Could you please give more information whether it is possible to publish my MS Access report using my network. Thanks.

Labu

About Labu07

Questions
1

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/08/2011
• Question Category: MS Access

Answered By bappy 0 points N/A #91035

How can I make report using MS Access?

Excellent. Now you are able to make your own queries and also able to make constructive reports.

Yes, you can also publish your MS Access report. But for that, you need a file server where there would be a share drive or public drive.

In this public drive you have to put your MS Access software from this public drive so that other users are able to access.
Also be sure that the users should have access permission to access the software and see your report.

Cheers!

Bappy

About bappy

Questions
0

Answers
55

Best Answers
14

• Vote Up 0 Vote Down

• Posted on - 05/08/2011
• Question Category: MS Access

Answered By Labu07 100 points N/A #91036

How can I make report using MS Access?

Thanks for your information. We already have a file server, so I think it would be easier for me. Regards.

Labu

About Labu07

Questions
1

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 05/08/2011
• Question Category: MS Access

Answered By sumya 0 points N/A #91037

How can I make report using MS Access?

Hello Labu,

Could you please try the following instructions?

1. Open the database window press F11 and click on the Report tab
2, Click New. A dialog box appears,
3. Choose between columnar and Tabular
4. Select the table or query that you want to use for your report.
5 Click OK.

Then repeat the first two steps above. Then you will see a dialog box; click design view; then select the table or query that you intend to use. Click ok. Here is your report.

Thanks.

Sumya

About sumya

Questions
0

Answers
28

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 05/08/2011
• Question Category: MS Access