Welcome to RABBOTT.COM	How to Create Reports for a Database  File In Microsoft Access

Back

Here are the steps to follow to create reports for a file on Microsoft Access. Please read and follow the directions carefully.

1. Log in and choose Microsoft Access. Open the file you have created in Access.

2. In the window, click on the REPORTS box. Then click on the NEW box.

3. In the NEW REPORT window, click on the arrow in the small white box at the bottom and choose the table you want to use for the report.

4. Click on REPORT WIZARD in the large white box and click OK.

5. Move each field you want in the report to the SELECTED FIELD box. Highlight the field and click >. When all the fields you want are moved, click NEXT. NOTE: The order in which you move the fields is the order they will be in on the report. .

6. In the next box, click NEXT. (We usually skip any "grouping levels.")

7. The next box is for sorting your data. Choose the field(s) you wish to use to sort. Example: You could sort alphabetically by the field Last Name. Click NEXT when the sorting is complete. (To skip this step, just click NEXT.)

8. In the ORIENTATION box, choose PORTRAIT or LANDSCAPE. In the LAYOUT box, choose the way you want your report to look. Click NEXT when done.

9. Choose the style you want for your report. NOTE: There are only six choices. Then click NEXT.

10. Type in a title for your report. Then click FINISH.

11. Your report appears on the screen. You may print the report if you wish.

12. Close the report by clicking the X in the upper right corner. The program will automatically save the report for you.

 

1. Log in and choose Microsoft Access. Open the file you have created in Access.

2. In the window, click on the REPORTS box. Then click on the NEW box.

3. In the NEW REPORT window, click on the arrow in the small white box at the bottom and choose the table you want to use for the report.

4. Click on LABEL WIZARD in the large white box and click OK.

5. Click on kind of labels you will be using (example: Avery 5160) and click NEXT.

6. Choose the font and size for the print on the label. Keep the print small (14 point or less) or your work will not fit on the labels.

7. Set up your label. You must choose the fields to use on the label with the > button. You should put the fields on the proper line on the label (1^st, 2^nd, etc.) You must type in spaces between fields if you want spaces on the labels. You must type in any punctuation you want – example: the comma between City and State.

8. Click NEXT when the label is finished. Click NEXT on the next box.

9. Click FINISH on the last box. Your label report will appear on the screen. Be sure the labels are set up correctly. Go back to step 2 (above) and try again if changes are needed.

10. You may print your labels. Be sure to put label stock in the printer.

10. Close the report using the X in the upper right corner. (The computer will save your report for you.) You may now exit Microsoft Access.