-
توجه: در صورتی که از کاربران قدیمی ایران انجمن هستید و امکان ورود به سایت را ندارید، میتوانید با آیدی altin_admin@ در تلگرام تماس حاصل نمایید.
آموزش کامل Access 2000 -EN
- شروع کننده موضوع A M I R
- تاریخ شروع
[h=2]******ing Records
[h=3]******ing Records
At times, you might want to view only those records that match a specific criterion. A ****** is a
technique that lets you view and work with a subset of data. Applying a ****** to an Access
table, form, or query temporarily hides records that don't meet your search criteria. For
example, you may only want to work with data pertaining to a specific zip code.
[h=3]******ing Records
At times, you might want to view only those records that match a specific criterion. A ****** is a
technique that lets you view and work with a subset of data. Applying a ****** to an Access
table, form, or query temporarily hides records that don't meet your search criteria. For
example, you may only want to work with data pertaining to a specific zip code.
[h=2]******ing Records
[h=5]To ****** By Selection:
Click in the field that contains the type of data you're looking for. For example, if you are
working with the Great Lake Elementary database's Students table (Datasheet View), and
you want to see a list of all students who live in Some City, go to the City column and click
in a field that contains Some City.
Click the ****** by Selection button.
The type of data you ******ed will be visible. For example, only the students who live in Some City will be visible.
[h=5]To ****** By Selection:
Click in the field that contains the type of data you're looking for. For example, if you are
working with the Great Lake Elementary database's Students table (Datasheet View), and
you want to see a list of all students who live in Some City, go to the City column and click
in a field that contains Some City.
Click the ****** by Selection button.
The type of data you ******ed will be visible. For example, only the students who live in Some City will be visible.
- The status area shows only the ******ed records.
[h=2]******ing Records
[h=3]Removing a ******
[h=5]To Remove a ******:
Click the Remove ****** button.
You can apply ******s to ******ed data to narrow your search even further.
[h=3]Removing a ******
[h=5]To Remove a ******:
Click the Remove ****** button.
- If you wish to reapply the ******, click the Apply ****** button (hover your mouse pointer over the button to observe the tooltip).
[h=2]******ing Records
[h=5]If you have created a ****** that you know you'll reuse at a later date,
Apply this ****** just before closing the object.
Access asks if you want to save changes to the design.
Click Yes to automatically save the ******.
When you reopen the table or form, all the records will be visible. Click the
Apply ****** button to reapply the ******. However, Access only saves the last ****** you create.
[h=5]If you have created a ****** that you know you'll reuse at a later date,
Apply this ****** just before closing the object.
Access asks if you want to save changes to the design.
Click Yes to automatically save the ******.
When you reopen the table or form, all the records will be visible. Click the
Apply ****** button to reapply the ******. However, Access only saves the last ****** you create.
[h=2]******ing Records
[h=5]To Apply ****** Excluding Selection:
****** Excluding Selection or right-click and choose ****** Excluding Selection from the shortcut menu.
Remove this ****** by clicking the Remove/Apply ****** button.
All sorting and ******ing commands are available in the Records menu (on the menu bar) and the shortcut menu.
[h=5]To Apply ****** Excluding Selection:
- Locate a record with the criterion you want to exclude. For example, you may want to exclude a particular zip code.
- All records except the criterion you excluded are now visible.
- The status area shows only ******ed records.
[h=2]******ing Records
[h=5]To ****** by Form:
[h=5]To ****** by Form:
- In Form or Datasheet View, click the New Record button. This creates a blank form or datasheet.
- Click the ****** By Form button.
- When you click in a field, a drop-down list containing all the criteria in the field (****** values) appears.
- Select a ****** value from the drop down list in one or more fields.
- To display records meeting more than one search criteria, click the Or tab.
- Click the Apply ****** button to view the ******ed records.
[h=2]******ing Records
[h=3]Challenge!
[h=3]Challenge!
- Open the Great Lake Elementary database.
- Double click the Students table. The Students table (in Datasheet View) opens.
- Spend some time familiarizing yourself with the data in the table, and experiment using the skills learned in this lesson:
- Perform a ****** By Selection.
- Remove the ******.
- Perform a ****** Excluding Selection.
- Perform a ****** By Form.
- Close the table.
- Do not save changes.
Queries
What is a Query?
In the preceding Access 2000 lessons, you learned to work with database
objects such as tables and forms. A query is another type of database object.
A query is data resulting from questions you ask of one or more tables. For example, let's say
you want to find out how many male students are in Mr. Emerson's class.
What is a Query?
In the preceding Access 2000 lessons, you learned to work with database
objects such as tables and forms. A query is another type of database object.
A query is data resulting from questions you ask of one or more tables. For example, let's say
you want to find out how many male students are in Mr. Emerson's class.
[h=2]Queries
[h=3]Run an Existing Query
[h=5]To Run an Existing Query:
Open the Great Lake Elementary database.
In the database window, choose the Queries tab from the Object palette.
[h=3]Run an Existing Query
[h=5]To Run an Existing Query:
Open the Great Lake Elementary database.
In the database window, choose the Queries tab from the Object palette.
- To open a query, double-click the title, select the title and click the Open button,
or right-click the title and choose Open from the shortcut menu.
[h=2]Queries
[h=3]Creating a Simple Query [h=5]To Create a Simple Query:
Open the Great Lake Elementary database.
In the database window, choose the Queries tab from the Object palette.
Select
and click the Open
button,
double-click it, or right-click it and choose Open from the shortcut menu.
The Simple Query Wizard opens.
From the Tables/Queries drop-down list, choose the table/query containing the fields you want to include in the query.
In the Available Fields text box, select the fields you want to include and click
the right arrow or double-click the field to move the fields into the Selected Fields text box.
Select any additional tables/queries from the Tables/Queries drop down list and repeat. Click Next when all fields have been selected.
If the fields you selected include a number field, you're asked to select a summary or detail query. To see each record, choose Detail. To see sums, averages, etc, choose Summary and set the summary options. Click Next.
[h=3]Creating a Simple Query [h=5]To Create a Simple Query:
Open the Great Lake Elementary database.
In the database window, choose the Queries tab from the Object palette.
Select
button,
The Simple Query Wizard opens.
From the Tables/Queries drop-down list, choose the table/query containing the fields you want to include in the query.
In the Available Fields text box, select the fields you want to include and click
the right arrow or double-click the field to move the fields into the Selected Fields text box.
Select any additional tables/queries from the Tables/Queries drop down list and repeat. Click Next when all fields have been selected.
If the fields you selected include a number field, you're asked to select a summary or detail query. To see each record, choose Detail. To see sums, averages, etc, choose Summary and set the summary options. Click Next.
- Provide a name for the query. Click Finish to run the query.
[h=2]Queries
[h=3]Sorting, Finding, and ******ing Query Results
You can sort, find, and ****** the results of a query just as you would other records. See Access 2000 lessons 9-12 for further details.
When you sort a query, and then close it, you are asked if you wish to save
the changes to the query design. If you save the changes, the query will still
be sorted the next time you open it. If you choose not to save changes, the
query returns to the original order.
If you ******ed a query and know you want to re-use it, remember to apply the ****** just
before closing it. Access will ask if you want to save changes to the design of the
query. If you answer yes to save changes, the last ****** is saved. When you open
the form again, ALL records will be visible. To view your ******, click the Apply
****** button to reapply the ******. However, Access only saves the last ****** you create.
[h=3]Sorting, Finding, and ******ing Query Results
You can sort, find, and ****** the results of a query just as you would other records. See Access 2000 lessons 9-12 for further details.
When you sort a query, and then close it, you are asked if you wish to save
the changes to the query design. If you save the changes, the query will still
be sorted the next time you open it. If you choose not to save changes, the
query returns to the original order.
If you ******ed a query and know you want to re-use it, remember to apply the ****** just
before closing it. Access will ask if you want to save changes to the design of the
query. If you answer yes to save changes, the last ****** is saved. When you open
the form again, ALL records will be visible. To view your ******, click the Apply
****** button to reapply the ******. However, Access only saves the last ****** you create.
[h=2]Creating a Report
[h=3]Reports
In the preceding Access 2000 lessons, you learned about tables, forms, and
queries. In this lesson, you'll learn about another database object, reports.
Although you can print datasheets and forms in Access, creating a report
makes your data more presentable and meaningful. Using Access, you can
report your data in variety of ways to make it more accessible to those who need it.
Most reports are either columnar or tabular (as shown below) in design.
[h=3]Reports
In the preceding Access 2000 lessons, you learned about tables, forms, and
queries. In this lesson, you'll learn about another database object, reports.
Although you can print datasheets and forms in Access, creating a report
makes your data more presentable and meaningful. Using Access, you can
report your data in variety of ways to make it more accessible to those who need it.
Most reports are either columnar or tabular (as shown below) in design.
[h=2]Creating a Report
[h=3]AutoReport
You can develop reports many ways, but in this lesson, we'll discuss how to create a report using AutoReport and the Report Wizard.
Some of the simplest reports to produce, AutoReports are
extremely useful; especially if all the data you want is in one table or query.
[h=3]AutoReport
You can develop reports many ways, but in this lesson, we'll discuss how to create a report using AutoReport and the Report Wizard.
Some of the simplest reports to produce, AutoReports are
extremely useful; especially if all the data you want is in one table or query.
[h=2]Creating a Report
[h=5]To Create an AutoReport:
Open the database window. Choose Report from the Object palette.
Click OK to create the report and open it in Print Preview. Your mouse pointer
changes to the magnifying glass. Remember, you cannot edit data in print preview.
When you save a report, only the structure of the report is saved, not the underlying
data you see in the preview. Data shown in the preview is always as current as the records in the database.
[h=5]To Create an AutoReport:
Open the database window. Choose Report from the Object palette.
- Click New to open the New Reports dialog box.
- Choose AutoReport: Columnar or AutoReport: Tabular.
- Click the drop-down list and choose the table or query on which the report or query is based.
- If you forget this step, the Office Assistant gives you the following error message:
Click OK to create the report and open it in Print Preview. Your mouse pointer
changes to the magnifying glass. Remember, you cannot edit data in print preview.
data you see in the preview. Data shown in the preview is always as current as the records in the database.