اموزش کامل Access 2010-En

[A M I R]

[h=2]Creating Reports

[h=4]To Create a Report:
Open the table or query you would like to use in your report. We want to print out a list of last month's orders, so we'll open up our Orders Query.

Select the Create tab on the Ribbon and locate the Reports group. Click the Report command.

Access will create a new report based on your object.

It's likely that some of your data will be located on the other side of the page break. To fix this, resize your

fields. Simply select a field, then click and drag its edge until the field is the desired size. Repeat with additional fields until all of your fields fit.

To save your report, click the Save command on the Quick Access Toolbar. When prompted, type a name for your report and then click OK.

Just like tables and queries, reports can be sorted and ******ed. Simply right-click the field you wish to sort or ******. Then, select the desired sorting or ******ing option.

​

 

[A M I R]

[h=2]Creating Reports

[h=4]Deleting Fields

You might find that your report contains some fields you don't really need to view. For instance, our report

contains the Zip Code field, which isn't really necessary in a list of orders. Fortunately, you can delete

fields in reports without affecting the table or query you got your data from.





​

 

[A M I R]

[h=2]Creating Reports

[h=4]To Delete a Field in a Report:


Click any cell in the field you would like to delete.

Press the delete key.

When you delete a field, be sure to delete its header as well. Simply select the header and press the delete key.

​

 

[A M I R]

[h=2]Creating Reports

[h=3]Printing and Saving Reports in Print Preview
While you can print reports using commands in the Backstage view, you can also use Print Preview. Print

Preview shows you how your report will appear on the printed page. It also allows you to modify the way

your report is displayed, print it, and even save it as a different file type.

​

 

[A M I R]

[h=2]Creating Reports

[h=3]Print

Click the Print command to print your report.

​

---

[h=3]Page Size Options

With the Page Size options, you can set the width of the margins on your report.

​

​

​

 

[A M I R]

[h=2]Creating Reports

[h=3]Page Layout Options

Here, you can change the orientation of your report. Select either portrait (tall) or landscape (wide). You

can also create columns or click the Page Setup command for more layout options.
​

​

 

[A M I R]

[h=2]Creating Reports

[h=3]Zoom

With the Zoom options, you can decide how much of the report you would like to see on screen. You

can also opt to view multiple pages at once.
​

​

 

[A M I R]

[h=2]Creating Reports

[h=3]Export Options

The Export Options allow you to save your report in another format. This makes it possible to view your report in other programs.

​

​

​

 

[A M I R]

[h=2]Creating Reports

[h=3]Close Print Preview

To exit the Print Preview, simply click the Close Print Preview command. You will be returned to the last view you used.

​

​

​

 

[A M I R]

[h=2]Creating Reports

[h=4]To Print a Report:

On the Home tab of the Ribbon, click the View command and select Print Preview from the drop-down

list. Your report will be shown as it will appear on the printed page.

If necessary, modify the page size, margin width, and page orientation using the related commands on the Ribbon.

Click the Print command.

The Print dialog box will appear. Set any desired print options, then click OK.
​

 

[A M I R]

[h=2]Creating Reports

[h=4]Saving Reports

You can save reports in other formats so that they'll be viewable outside of Access. This is called exporting

a file, and it allows you to view and even modify reports in other formats and programs.




Access offers options to save your report as an Excel file, a Text file, a PDF, an XPS file, an email attachment, a

Rich Text file, or an HTML document. Experiment with the different export options to find the one that best suits your needs.





​

 

[A M I R]

[h=2]Creating Reports

[h=4]To Export a Report:
On the Home tab of the Ribbon, click the View command and select Print Preview from the drop-down list.

Locate the Data group on the Ribbon.

Select one of the file type options on the Ribbon, or click More to see options to save your report as a Word or HTML file.

Save your file.

If you're saving the report as a PDF or XPS file:

Select the location where you wish to save the report.
Place your cursor in the file name text box and type a name for your report if you wish to name it something other than the report title.
In the Save as Type drop-down menu, select either PDF or XPS.
Select the file quality by clicking either Standard for reports you plan on printing or Optimized for reports you plan to share primarily online.
Once you are satisfied with your settings, click Publish to save your report.

If you're saving the report as any other type of file:


Click Browse to specify your file location and name, then click Save.

In the Export dialog box, click the checkboxes to select desired saving options where applicable,

Click OK to export your report.

A dialog box will appear to notify you that your file has been successfully saved. Click Close to return to your report





​

 

[A M I R]

[h=2]Creating Reports

[h=3]Challenge!
If you haven't already, download our sample database and open it.

Open the Customers Who Live Nearby query and use it to create a report.

Resize the fields and rows so that all of the information is visible.

Move any fields located on the right side of a page break onto the same page as the other fields.

Export the report as a PDF file.

​

 

[A M I R]

[h=2]Advanced Report Options

[h=3]Introduction

Access 2010 offers several advanced options for creating and modifying reports. The Report Wizard is a tool that guides

you through the process of creating complex reports. Once you've created a report, whether through the Report Wizard or the

Report command, you can then format it to make it look exactly how you want.


In this lesson, you'll learn how to use the Report Wizard to create complex reports. You'll also learn how to use

Access's formatting options to format text, change report colors and fonts, and add a logo.

​

 

[A M I R]

[h=2]Advanced Report Options

[h=3]The Report Wizard

While using the Report command is a quick way to create reports from the current object, it's not as helpful if

you want to create a report with data from multiple objects. The Report Wizard makes it easy to create reports

using fields from multiple tables or queries. It even lets you choose how your data will be organized.





​

 

[A M I R]

[h=2]Advanced Report Options

[h=4]To Create a Report using the Report Wizard:

Select the Create tab and locate the Reports group. Click the Report Wizard command.

The Report Wizard dialog box will appear.

​

 

[A M I R]

[h=2]Advanced Report Options

[h=4]Step 1: Select the Fields to Include in your Report


Click the drop-down arrow to select the table or query that contains the desired field or fields.

Select a field from the list on the left and click the right arrow

to add it to the report.

You can add fields from more than one table or query by repeating the above steps. Once you've added the desired fields, click Next.

​

 

[A M I R]

[h=2]Advanced Report Options

[h=4]Step 2: Organize the Report

The Report Wizard will provide you with options that let you choose how to view and organize your

data. These options group like data within your fields and organize those fields into multiple levels, like in an outline or bulleted list.




If you are building a report from only one table or query, you can skip to #3 in this section.

Access will offer a list of several organization options. Select an option from the list to preview it.

Click Next when you are satisfied with the basic organization of your data.

If you're not satisfied with the way your data is organized, you can now modify the grouping levels.

Select a field from the list and click the right arrow

to add it as a new level.

If necessary, modify the order of your grouped fields by selecting a field and clicking the up or down Priority arrow to move it up or down a level.

Once you are satisfied with the organization of your report, click Next.
​

 

[A M I R]

[h=2]Advanced Report Options


[h=4]Step 3: Sort your Report Data

Click the top drop-down arrow, and select the name of the first field you wish to sort.

Click the button on the right to change the sort to ascending or descending.

Add any additional sorts. You may sort up to four fields. The sort will be applied from top to bottom, meaning that the sort at the top of the list will be the main sort.

When you are satisfied with the way your data is sorted, click Next.


Depending on the grouping you have chosen for your data, your sorting options may be limited.

​

 

[A M I R]

[h=2]Advanced Report Options

[h=4]Step 4: Select a Layout and Title



Click the various layout options to see how they look, then select one to use in your report.


Select either a portrait (tall) or landscape (wide) orientation for your report.

Once you are satisfied with your report layout, click Next.
Place your cursor in the text box and type the title you would like for your report.
Select whether you want to preview the report or modify its design, then click Finish.

Your report will be created and saved.

Just as with other reports, you may have to adjust your field and row size and location to make sure that all your data fits the way you want it to.




​