-
توجه: در صورتی که از کاربران قدیمی ایران انجمن هستید و امکان ورود به سایت را ندارید، میتوانید با آیدی altin_admin@ در تلگرام تماس حاصل نمایید.
اموزش کامل Access 2010-En
- شروع کننده موضوع A M I R
- تاریخ شروع
[h=2]Working with Forms
[h=3]Drop-Down List
[h=3]Drop-Down List
Instead of typing the customer name into a text box, anyone using this form must select a
name from this drop-down list. This means that we can only record orders from customers whose information
we've already entered into our database. Requiring that each order is linked to an actual
customer record helps preserve the integrity of our database.
name from this drop-down list. This means that we can only record orders from customers whose information
we've already entered into our database. Requiring that each order is linked to an actual
customer record helps preserve the integrity of our database.
[h=2]Working with Forms
[h=3]Calendar Button
[h=3]Calendar Button
Since the Pickup Date field on the related form only accepts information formatted as a date, the
Pickup Date text box includes a calendar button to ensure that users can only enter a date in the desired format. Requiring
dates to be entered in a consistent format ensures that the database will recognize each entry in this field as a date.
Pickup Date text box includes a calendar button to ensure that users can only enter a date in the desired format. Requiring
dates to be entered in a consistent format ensures that the database will recognize each entry in this field as a date.
[h=2]Working with Forms
[h=3]Add Item to Sub-Form
[h=3]Add Item to Sub-Form
This button launches the sub-form that allows you to add a new record to the embedded table. When
using a sub-form like this, enter
the data as you would in a normal form, then click Save and Close. The new record will be displayed in the embedded table.using a sub-form like this, enter
[h=2]Working with Forms
[h=3]Sub-Form and Embedded Table
[h=3]Sub-Form and Embedded Table
In our database, order items are stored in a separate table from the orders themselves. In order
to enter and display order data, this form includes an embedded sub-form and table. This orders
table can be viewed and searched like a normal table, but it only includes data linked to this particular order.
to enter and display order data, this form includes an embedded sub-form and table. This orders
table can be viewed and searched like a normal table, but it only includes data linked to this particular order.
[h=2]Working with Forms
[h=3]Challenge!
If you haven't already, download our sample database and open it.
Open the Orders Form.
Create a new record with the following data:
Open the Customers Form.
Find the record for customer Dwight Parker and make the following changes:
[h=3]Challenge!
If you haven't already, download our sample database and open it.
Open the Orders Form.
Create a new record with the following data:
- Customer: Eric Oglesby
- Pickup date: February 14, 2011
- Order items: Fudge Marble Cake (1)
- Notes: Write "Happy *********'s Day!" with pink frosting.
- Pre Order: Yes
- Paid: Yes
Open the Customers Form.
Find the record for customer Dwight Parker and make the following changes:
- Street Address: 190 Cook Street
- City: Chapel Hill
- Zip Code: 27514
- Email: dwightp@email.com
[h=2]Sorting and ******ing Records
[h=3]Introduction
Access 2010 gives you the ability to work with enormous amounts of data, which means it can be hard to learn anything
about your database just by glancing at it. Sorting and ******ing are two tools that let you customize how you organize
and view your data making it more convenient to work with.
In this lesson, you'll learn how to sort and ****** records.
[h=3]Introduction
Access 2010 gives you the ability to work with enormous amounts of data, which means it can be hard to learn anything
about your database just by glancing at it. Sorting and ******ing are two tools that let you customize how you organize
and view your data making it more convenient to work with.
In this lesson, you'll learn how to sort and ****** records.
[h=2]Sorting and ******ing Records
[h=3]About Sorting and ******ing
Essentially, sorting and ******ing are tools that let you organize your data. When you sort data, you
are putting it in order. ******ing data lets you hide unimportant data and focus only on the data you're interested in.
[h=3]About Sorting and ******ing
Essentially, sorting and ******ing are tools that let you organize your data. When you sort data, you
are putting it in order. ******ing data lets you hide unimportant data and focus only on the data you're interested in.
[h=2]Sorting and ******ing Records
[h=4]Sorting Records
When you sort records, you are putting them into a logical order, with like data grouped together. As a
result, sorted data is often simpler to read and understand than unsorted data. By default, Access sorts records
by their ID numbers. However, there are many other ways records can be sorted. For example, the information
in a database belonging to a bakery could be sorted in a number of ways:
You can sort both text and numbers in two ways: in ascending order or descending order. "Ascending" means "going up," so an
ascending sort will arrange numbers from smallest to largest and text from A to Z. "Descending" means "going down," or
largest to smallest for numbers and Z to A for text. The default ID number sort that appears in your tables is an
ascending sort, which is why the lowest ID numbers appear first.
In our example, we will be performing a sort on a table. However, you can sort records in any Access object. The procedure is largely the same.
[h=4]Sorting Records
When you sort records, you are putting them into a logical order, with like data grouped together. As a
result, sorted data is often simpler to read and understand than unsorted data. By default, Access sorts records
by their ID numbers. However, there are many other ways records can be sorted. For example, the information
in a database belonging to a bakery could be sorted in a number of ways:
- Orders could be sorted by order date or by the last name of the customers who placed the orders.
- Customers could be sorted by name or by the city or zip code where they live.
- Products could be sorted by name, category (e.g., pies, cakes, cupcakes, etc.), or price.
You can sort both text and numbers in two ways: in ascending order or descending order. "Ascending" means "going up," so an
ascending sort will arrange numbers from smallest to largest and text from A to Z. "Descending" means "going down," or
largest to smallest for numbers and Z to A for text. The default ID number sort that appears in your tables is an
ascending sort, which is why the lowest ID numbers appear first.
In our example, we will be performing a sort on a table. However, you can sort records in any Access object. The procedure is largely the same.
[h=2]Sorting and ******ing Records
[h=4]To Sort Records:
Select a field in the cell you wish to sort by. In this example, we will sort by customers' last names.
Click the Home tab on the Ribbon and locate the Sort & ****** group.
Sort the field by selecting the Ascending or Descending command.
Select Ascending to sort text A to Z or to sort numbers from smallest to largest. We will select this in our example, since we want the last names to be in A to Z order.
The table will now be sorted by the selected field.
To save the new sort, click the Save command on the Quick Access toolbar.
After you save the sort, the records will stay sorted that way until you perform another sort or
remove the current one. To remove a sort, simply click the Remove Sort command.
[h=4]To Sort Records:
Select a field in the cell you wish to sort by. In this example, we will sort by customers' last names.
Click the Home tab on the Ribbon and locate the Sort & ****** group.
Sort the field by selecting the Ascending or Descending command.
Select Ascending to sort text A to Z or to sort numbers from smallest to largest. We will select this in our example, since we want the last names to be in A to Z order.
- Select Descending to sort text Z to A or to sort numbers from largest to smallest.
The table will now be sorted by the selected field.
To save the new sort, click the Save command on the Quick Access toolbar.
After you save the sort, the records will stay sorted that way until you perform another sort or
remove the current one. To remove a sort, simply click the Remove Sort command.
[h=2]Sorting and ******ing Records
[h=3]******ing Records
Filters allow you to view only the data you want to see. When you create a ******, you set criteria
for the data you want to display. The ****** then searches all of the records in the table, finds the
ones that meet your search criteria, and temporarily hides the ones that don't.
******s are useful, as they allow you to focus in on specific records without being distracted by the data you're
uninterested in. For instance, if you had a database that included customer and order information, you could
create a ****** to display only customers living within a certain city, or only orders that contain a certain
product. Viewing this data with a ****** would be far more convenient than searching for it in a large table.
In our examples and explanations, we will be applying ******s to tables. However, you can apply ******s to any Access object. The procedure is largely the same.
[h=3]******ing Records
Filters allow you to view only the data you want to see. When you create a ******, you set criteria
for the data you want to display. The ****** then searches all of the records in the table, finds the
ones that meet your search criteria, and temporarily hides the ones that don't.
******s are useful, as they allow you to focus in on specific records without being distracted by the data you're
uninterested in. For instance, if you had a database that included customer and order information, you could
create a ****** to display only customers living within a certain city, or only orders that contain a certain
product. Viewing this data with a ****** would be far more convenient than searching for it in a large table.
In our examples and explanations, we will be applying ******s to tables. However, you can apply ******s to any Access object. The procedure is largely the same.
[h=2]Sorting and ******ing Records
[h=4]To Create a Simple ******:
Click the drop-down arrow next to the field you would like to ****** by. We will ****** by city, as we want to see a list of customers who live in a certain city.
A drop-down menu with a checklist will appear. Only checked items will be included in the ******ed
results. Use the following options to determine which items will be included in your ******:
Click OK. The ****** will be applied. Our customers table now displays only customers who live in Cary.
Toggling your ****** allows you to turn it on and off. To view the records without the ******, simply
click the Toggle ****** command. To restore the ******, simply click it again.
[h=4]To Create a Simple ******:
Click the drop-down arrow next to the field you would like to ****** by. We will ****** by city, as we want to see a list of customers who live in a certain city.
A drop-down menu with a checklist will appear. Only checked items will be included in the ******ed
results. Use the following options to determine which items will be included in your ******:
- Select and deselect items one at a time by clicking their checkboxes. Here, we will deselect all of the options except for Cary.
- Click Select All to include every item in the ******. Clicking Select All a second time will deselect all items.
- Click Blank to set the ****** to find only the records with no data in the selected field.
Click OK. The ****** will be applied. Our customers table now displays only customers who live in Cary.
Toggling your ****** allows you to turn it on and off. To view the records without the ******, simply
click the Toggle ****** command. To restore the ******, simply click it again.
[h=2]Sorting and ******ing Records
[h=4]Creating a ****** from a Selection
******ing by selection allows you to select specific data from your table and find data that is
similar or dissimilar to it. For instance, if you were working with a bakery's database and wanted to search
for all products whose names contained the word "chocolate," you could select that word in one product
name and create a ****** with that selection. Creating a ****** with a selection can be more convenient
than setting up a simple ****** if the field you're working with contains many items.
[h=4]Creating a ****** from a Selection
******ing by selection allows you to select specific data from your table and find data that is
similar or dissimilar to it. For instance, if you were working with a bakery's database and wanted to search
for all products whose names contained the word "chocolate," you could select that word in one product
name and create a ****** with that selection. Creating a ****** with a selection can be more convenient
than setting up a simple ****** if the field you're working with contains many items.
[h=2]Sorting and ******ing Records
[h=4]To Create a ****** from a Selection:
Select the cell or data you would like to create a ****** with. We want to see a list of all of our products
that contain the word "chocolate" in their names, so we'll select the word "chocolate" in the Product Name field.
Select the Home tab on the Ribbon and locate the Sort & ****** gro
Click the Selection drop-down arrow.
Select the type of ****** you would like to set up:
The ****** will be applied. Our table now displays only products with the word "chocolate" in their names.
[h=4]To Create a ****** from a Selection:
Select the cell or data you would like to create a ****** with. We want to see a list of all of our products
that contain the word "chocolate" in their names, so we'll select the word "chocolate" in the Product Name field.
Select the Home tab on the Ribbon and locate the Sort & ****** gro
Click the Selection drop-down arrow.
Select the type of ****** you would like to set up:
- Selecting Equals will include only records with data that is identical to the selected data.
- Selecting Does Not Equal will include all records except the data that is identical to the selection..
- Selecting Contains will include only records with cells that contain the selected data. We'll
- select this, since we want to see records that contain the word "chocolate" anywhere in the title.
- Selecting Does Not Contain will include all records except those with cells that contain the selected data.
The ****** will be applied. Our table now displays only products with the word "chocolate" in their names.
[h=2]Sorting and ******ing Records
[h=3]Creating a ****** from a Search Term
You can also create a ****** by entering a search term and specifying the way Access should match data to
that term. Creating a ****** from a search term is similar to creating a ****** from a selection.
[h=3]Creating a ****** from a Search Term
You can also create a ****** by entering a search term and specifying the way Access should match data to
that term. Creating a ****** from a search term is similar to creating a ****** from a selection.
Sorting and ******ing Records
******ing Text by a Search Term
When ******ing text by entering a search term, you can use some of the same options you use
when ******ing by a selection, like Equals, Does not Equal,Contains, and
Does Not Contain. You can also choose from the following options:
******ing Text by a Search Term
When ******ing text by entering a search term, you can use some of the same options you use
when ******ing by a selection, like Equals, Does not Equal,Contains, and
Does Not Contain. You can also choose from the following options:
- Begins With, which includes only records whose data for the selected field begins with the search term
- Does Not Begin With, which includes all records except those whose data for the selected field begins with the search term
- Ends With, which includes only records whose data for the selected field ends with the search term
- Does Not End With, which includes all records except those whose data for the selected field ends with the search term
[h=2]Sorting and ******ing Records
[h=4]To ****** Text by a Search Term:
Click the drop-down arrow next to the field you would like to ****** by. We want to ****** the records in
our orders table to display only those that contain notes with certain information, so we'll click the arrow in the Notes field.
In the drop-down menu, hover your mouse over the words Text ******s. From the list that appears, select the
way you would like the ****** to match the term you enter. In this example, we want to view only records whose
notes indicate the order was placed for a party. We'll select Contains, so that we can search for records that contain the word "party."
The Custom ****** dialog box will appear. Type in the word you would like to use in your ******.
Click OK. The ****** will be applied.
[h=4]To ****** Text by a Search Term:
Click the drop-down arrow next to the field you would like to ****** by. We want to ****** the records in
our orders table to display only those that contain notes with certain information, so we'll click the arrow in the Notes field.
In the drop-down menu, hover your mouse over the words Text ******s. From the list that appears, select the
way you would like the ****** to match the term you enter. In this example, we want to view only records whose
notes indicate the order was placed for a party. We'll select Contains, so that we can search for records that contain the word "party."
The Custom ****** dialog box will appear. Type in the word you would like to use in your ******.
Click OK. The ****** will be applied.
[h=2]Sorting and ******ing Records
[h=4]******ing Numbers with a Search Term
The process for ******ing numbers with a search term is very similar to the process for ******ing text. However, different
******ing options are available to you when working with numbers. In addition to the Equals and Does not Equal, you can also choose:
[h=4]******ing Numbers with a Search Term
The process for ******ing numbers with a search term is very similar to the process for ******ing text. However, different
******ing options are available to you when working with numbers. In addition to the Equals and Does not Equal, you can also choose:
- Greater Than to include only records with numbers in that field greater than or equal to the number you enter
- Less Than to include only records with numbers in that field less than or equal to the number you enter
- Between to include records with numbers that fall within a certain range