جاوا اسکریپت غیر فعال است برای تجربه بهتر، قبل از ادامه، جاوا اسکریپت را در مرورگر خود فعال کنید.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser .
آموزش کامل Access 2007-EN
[h=2]Using Queries to Make Data Meaningful - Part 2
To add a ****** to your query design:
Click the Criteria row in the query design.
Add your ****** criteria by typing the value in the cell, as we did in the following example:
Click Run! to see the results.
[h=2]Using Queries to Make Data Meaningful - Part 2
[h=3]Challenge!
If you haven't already done so, save the
sample Ready2Read database on your own computer.
Create a query that uses the Count and Group By options.Sort Criteria .
[h=2]Using Reports to Make Data Meaningful to Others
[h=3]Introduction Now that you know how to use queries to analyze the data in a database, it is time to find out how to
create a report
that will make the data meaningful to someone else. This lesson will show you how to create a report using the
Report command. It will also show you how to
use grouping options and
query limits to make the report easier to read, as
well as identify several
report formatting and
layout options that can be set in Layout View. Finally, you will see
how to use
Print Preview and how to
save the report .
[h=2]Using Reports to Make Data Meaningful to Others you report is an effective way to present your data using an attractive layout. TheReport Wizard walks you through Report command, however, is much easier to use, and all of the formatting options
[h=2]Using Reports to Make Data Meaningful to Others Report command makes this
[h=2]Using Reports to Make Data Meaningful to Others
[h=5]To Create a Report Based on a Table using the Report Command
Choose the table you wish to use as the source of your report. To do that, you can either open the table, or
just highlight the table name in the Navigation Pane. In our example, we used the open Books table to create the report.
Select the Report command on the Create tab in the Ribbon, as seen above.
The report is automatically generated and includes every field in the table in order of their appearance
in the table. This can be seen in the example below, which was created form the table above.
The layout and formatting of the report can be manipulated in Layout View.
[h=2]Using Reports to Make Data Meaningful to Others
[h=2]Using Reports to Make Data Meaningful to Others
It is possible to limit the number of records in a report, provided that the report was based
on a query. The limit is set in the query itself, using the query design screen.
To limit the records returned in a query:
Open the query in Design View
Use the Return option in the Query Setup command group to set the
number of records you want to see in the query results and the final report.
Click Run! to make sure the query results look like you want the report to look.
Create the report using the Report command on the Create tab
Format the report as desired.
[h=2]Using Reports to Make Data Meaningful to Others Grouping items on a report can make it much more readable. Microsoft Access 2007
[h=2]Using Reports to Make Data Meaningful to Others
[h=5]To Add Grouping to a Report
To add a level of grouping to a report:
With the report open, select the
Group & Sort command from the
Grouping & Totals
command group on the
Format tab in the Ribbon.
This opens a
Group, Sort, and Total dialog box in the lower portion of the window.
In the Group, Sort, and Total dialog box, select Add a group .
Select the field you wish to group by from the drop down list. We chose to group our list by Category .
When you release the mouse button, the report will now appear with items grouped. Our report is grouped on Category now, as seen below.
Group, Sort, and Total dialog box will remain open until you close it.
[h=2]Using Reports to Make Data Meaningful to Others
[h=3]Formatting a Report in Layout View
Access opens the created report in Layout View, so that you can easily make modifications. In
Layout View, you can change the look of your report in many different ways, including:
deleting columns and other report elements
moving and resizing columns
changing the title and other text on the report headings
applying a report style with AutoFormat
modifying the page layout
[h=2]Using Reports to Make Data Meaningful to Others
[h=5]To Delete a Column or Other Report Element
To delete a column or other report element:
Highlight the element by clicking on it.
Hit the Delete button on your keyboard.
[h=2]Using Reports to Make Data Meaningful to Others
[h=5]To Move a Column or Other Report Element
To move a column or other report element:
Highlight the element by clicking on it.
Drag and drop the element to a new location on the report.
[h=2]Using Reports to Make Data Meaningful to Others
[h=5]To Re-size a Column or Other Report Element
To re-size a column or other report element:
Highlight the element by clicking on it.
Drag and drop the edge of the element to the new size on the report.
[h=2]Using Reports to Make Data Meaningful to Others
[h=5]To Add a Logo to the Report
To add a custom picture or company logo to a report:
Click on the
Logo command on the
Format tab in the Ribbon.
When the
Insert Picture dialog box opens, find the picture file.
[h=2]Using Reports to Make Data Meaningful to Others
[h=5]To Modify the Title of the Report
To modify the title of a report:
Click on the
Title command on the
Format tab in the Ribbon.
When the highlight appears, type in the new title.
[h=2]Using Reports to Make Data Meaningful to Others
[h=5]To Modify Text in Report Headings
If you don't like the standard font face and size that Access used to create your report, you can modify
them using common Microsoft Office text formatting commands. You can modify the size, font face, font
color, alignment, and much more. They all work basically the same way:
Highlight the text you want to change
Select the formatting option you wish from the lists that appear when you click on a command.
The change appears when you release the mouse button.
[h=2]Using Reports to Make Data Meaningful to Others
[h=5]To Apply an AutoFormat Style
Like with forms, Microsoft Access 2007 offers a variety of report styles in the
AutoFormat command. To apply a style:
Click on the
AutoFormat command in the Ribbon.
Select a format from the drop down list. The change is applied instantly.
[h=2]Using Reports to Make Data Meaningful to Others
[h=5]To Change the Page Layout
When a report is created, it opens in Layout View, like the one in the picture below. The dotted lines
are showing where the edge of the page will be in Report View.
To change the page layout options:
Switch to
Print Preview using the
Views command in the Ribbon.
Select the layout option you wish to alter from the Page Layout command group on the Ribbon.
All of the standard Microsoft page layout options are available, including:
Page Layout Option Description Margins To set the margins for narrow, wide, or normal Orientation To select either a Portrait or Landscape orientation Size To set the paper size
[h=2]Using Reports to Make Data Meaningful to Others
