-
توجه: در صورتی که از کاربران قدیمی ایران انجمن هستید و امکان ورود به سایت را ندارید، میتوانید با آیدی altin_admin@ در تلگرام تماس حاصل نمایید.
اموزش کامل Access 2010-En
- شروع کننده موضوع A M I R
- تاریخ شروع
[h=2]Working with Tables
[h=3]Table Formatting Options
[h=3]Table Formatting Options
These Formatting Options allow you to make your table easier to read by adding an
alternate row color or modifying the gridlines that separate individual rows and columns. You
can access even more formatting options by clicking the arrow in the bottom right corner.
alternate row color or modifying the gridlines that separate individual rows and columns. You
can access even more formatting options by clicking the arrow in the bottom right corner.
[h=2]Working with Tables
[h=3]Field
[h=3]Field
In Access, columns are referred to as fields. When you organize your data by entering it
into different fields, you are organizing it by type. Each field contains one type of data. The
type of data contained within a field is described by the title at the top of each field.
into different fields, you are organizing it by type. Each field contains one type of data. The
type of data contained within a field is described by the title at the top of each field.
[h=2]Working with Tables
[h=3]Record Navigation Bar
[h=3]Record Navigation Bar
The Record Navigation bar allows you to navigate through records on at a time. Click the
arrows to move from record to record, navigate directly to a record by searching for it with the
record search box. You can also use the Record Navigation bar to add a new record to the
current table.
arrows to move from record to record, navigate directly to a record by searching for it with the
record search box. You can also use the Record Navigation bar to add a new record to the
current table.
[h=2]Working with Tables
[h=4]Navigating Within Tables
To navigate through records in a table, you can use the up and down arrow keys, scroll
up and down, or use the arrows in the record navigation bar located at the bottom of your table. You can
also find any record in the currently open table by searching for it using the record search box. Simply
place your cursor in the search box, type any word that appears in the record you would like to find, and
press the enter key. To view additional records that match your search, press enter again.
To navigate between fields, you can use the left and right arrow keys or scroll left and right.
[h=4]Navigating Within Tables
To navigate through records in a table, you can use the up and down arrow keys, scroll
up and down, or use the arrows in the record navigation bar located at the bottom of your table. You can
also find any record in the currently open table by searching for it using the record search box. Simply
place your cursor in the search box, type any word that appears in the record you would like to find, and
press the enter key. To view additional records that match your search, press enter again.
To navigate between fields, you can use the left and right arrow keys or scroll left and right.
[h=2]Working with Tables
[h=4]To Add a New Record:
There are three ways to add a new record to a table:
In the Records group on the Home tab, click the New command.
On the Record Navigation bar at the bottom of the window, click the New Record button.
Simply begin typing in the row below your last added record.
Occasionally when you enter information into a record, a window will pop up to tell you that the
information you've entered is invalid. That means the field you're working with has a
validation rule, which is a rule about the type of data that can appear in that field. Click
OK, then follow the instructions in the pop-up windowto re-enter your data.
[h=4]To Add a New Record:
There are three ways to add a new record to a table:
In the Records group on the Home tab, click the New command.
On the Record Navigation bar at the bottom of the window, click the New Record button.
Simply begin typing in the row below your last added record.
Occasionally when you enter information into a record, a window will pop up to tell you that the
information you've entered is invalid. That means the field you're working with has a
validation rule, which is a rule about the type of data that can appear in that field. Click
OK, then follow the instructions in the pop-up windowto re-enter your data.
[h=2]Working with Tables
[h=4]To Replace a Word within a Record:
You can edit multiple occurrences of the same word by using
Find and Replace, which searches for a term and replaces it with another term.
Select the Home tab and locate the Find group.
Select the Replace command. The Find and Replace dialog box will appear.
Click the Find What: box and type the word you would like to find.
Click the Replace With: box and type the word you would like to replace the original word.
Click the Look In: drop-down arrow to select the area you would like to search.
Select Current Field to limit your search to the currently selected field.
Select Current Document to search within the entire table.
Click the Match: drop-down arrow to select how closely you'd like results to match your search.
Click Find Next to find the next occurrence of your search term.
Click Replace to replace the original word with the new one.
While you can use Replace All to replace every instance of a term, replacing them one at a time
allows you to be absolutely certain that you edit only the data you want. Replacing data
unintentionally can have a negative impact on your database.
[h=4]To Replace a Word within a Record:
You can edit multiple occurrences of the same word by using
Find and Replace, which searches for a term and replaces it with another term.
Select the Home tab and locate the Find group.
Select the Replace command. The Find and Replace dialog box will appear.
Click the Find What: box and type the word you would like to find.
Click the Replace With: box and type the word you would like to replace the original word.
Click the Look In: drop-down arrow to select the area you would like to search.
Select Current Field to limit your search to the currently selected field.
Select Current Document to search within the entire table.
Click the Match: drop-down arrow to select how closely you'd like results to match your search.
- Select Any Part of Field to search for your search term in any part of a cell.
- Select Whole Field to search only for cells that match your search term exactly.
- Select Beginning of Field to search only for cells that start with your search term.
Click Find Next to find the next occurrence of your search term.
Click Replace to replace the original word with the new one.
While you can use Replace All to replace every instance of a term, replacing them one at a time
allows you to be absolutely certain that you edit only the data you want. Replacing data
unintentionally can have a negative impact on your database.
[h=2]Working with Tables
[h=4]To Delete a Record:
Select the entire record by clicking the gray border at the left side of the record.
Select the Home tab and locate the Records group.
Click the Delete command. The record will be permanently deleted.
The ID numbers assigned to records stay the same even after you delete a record. For example, if you
delete the 34th record in a table, the sequence of record ID numbers will read "...32, 33, 35, 36...", rather than "...32, 33, 34, 35, 36...".
[h=4]To Delete a Record:
Select the entire record by clicking the gray border at the left side of the record.
Select the Home tab and locate the Records group.
Click the Delete command. The record will be permanently deleted.
The ID numbers assigned to records stay the same even after you delete a record. For example, if you
delete the 34th record in a table, the sequence of record ID numbers will read "...32, 33, 35, 36...", rather than "...32, 33, 34, 35, 36...".
[h=2]Working with Tables
[h=4]To Resize a Field:
Place your cursor over the right gridline in the field title. Your mouse will become a double arrow
.
Click and drag the gridline to the right to increase the field width or to the left to decrease the field width.
Release the mouse. The field width will be changed.
[h=4]To Resize a Field:
Place your cursor over the right gridline in the field title. Your mouse will become a double arrow
Click and drag the gridline to the right to increase the field width or to the left to decrease the field width.
Release the mouse. The field width will be changed.
[h=2]Working with Tables
[h=4]To Resize a Row:
Place your cursor over the bottom gridline in the gray area to the left of the row. Your mouse will become a double arrow
.
Click and drag the gridline downward to increase the row height or upward to decrease the row height.
Release the mouse. The row height will be changed.
[h=4]To Resize a Row:
Place your cursor over the bottom gridline in the gray area to the left of the row. Your mouse will become a double arrow
Click and drag the gridline downward to increase the row height or upward to decrease the row height.
Release the mouse. The row height will be changed.
[h=2]Working with Tables
[h=4]Hiding Fields
If you have a field that you don't plan on editing or don't want other people to edit, you can
hide it. A hidden field is invisible but is still part of your database. Data within a hidden field
can still be accessed from forms, queries, reports, and any related tables.
[h=4]Hiding Fields
If you have a field that you don't plan on editing or don't want other people to edit, you can
hide it. A hidden field is invisible but is still part of your database. Data within a hidden field
can still be accessed from forms, queries, reports, and any related tables.
[h=2]Working with Tables
[h=4]To Hide a Field:
Right-click the field title.
From the drop-down menu, select Hide Fields.
The field will be hidden.
If you decide you would like the field to be visible again, you can unhide it. Simply right-click any field title, then
select Unhide Fields. In the dialog box, click the checkboxes of any fields you would like to be visible again, then click OK.
[h=4]To Hide a Field:
Right-click the field title.
From the drop-down menu, select Hide Fields.
The field will be hidden.
If you decide you would like the field to be visible again, you can unhide it. Simply right-click any field title, then
select Unhide Fields. In the dialog box, click the checkboxes of any fields you would like to be visible again, then click OK.
[h=2]Working with Tables
[h=3]Table Formatting Options [h=4]Alternate Row Color
By default, the background of every other row in an Access table is a few shades darker than the background
of the rest of the table. This darker alternate row color makes your table easier to read by offering a
visual distinction between each record and the records directly above and below it.
By default, the background of every other row in an Access table is a few shades darker than the background
of the rest of the table. This darker alternate row color makes your table easier to read by offering a
visual distinction between each record and the records directly above and below it.