-
توجه: در صورتی که از کاربران قدیمی ایران انجمن هستید و امکان ورود به سایت را ندارید، میتوانید با آیدی altin_admin@ در تلگرام تماس حاصل نمایید.
آموزش کامل Access 2003-En
- شروع کننده موضوع A M I R
- تاریخ شروع
[h=2]Using a Wizard to Create the Contact Management Database
[h=3]Launching the Database Wizard
The Contact Management database was created using the Microsoft Access Database
Wizard. We will briefly review the steps involved in creating this database.
Microsoft Access 2003 is equipped with a database wizard that can be used to create any of ten simple
databases: Asset Tracking, Contact Management, Event Management, Expenses, Inventory Control, Ledger, Order Entry, Resource
Scheduling, Service Call Management, and Time and Billing.
In this lesson we will briefly review the steps involved in creating the Contact Management database.
[h=3]Launching the Database Wizard
The Contact Management database was created using the Microsoft Access Database
Wizard. We will briefly review the steps involved in creating this database.
Microsoft Access 2003 is equipped with a database wizard that can be used to create any of ten simple
databases: Asset Tracking, Contact Management, Event Management, Expenses, Inventory Control, Ledger, Order Entry, Resource
Scheduling, Service Call Management, and Time and Billing.
In this lesson we will briefly review the steps involved in creating the Contact Management database.
[h=2]Using a Wizard to Create the Contact Management Database
[h=5]How the Contact Management Database was Created Using the Database Wizard:
[h=5]How the Contact Management Database was Created Using the Database Wizard:
- Choose File
New from the menu bar.
- Click once on the Databases tab near the top of the New window.
- If the Templates window does not show, you may need to select On my computer from the task pane on the right side of your screen.
- Click once to select on the Contact Management icon.
- Click the OK button to launch the wizard.
- Specify the location where the database will be saved.
[h=2]Using a Wizard to Create the Contact Management Database
[h=3]Verifying the Intent of the Contact Management Database
The first screen of the wizard verifies the type of information that will be stored in the
Contact Management database: Contact information and Call information.
[h=3]Verifying the Intent of the Contact Management Database
The first screen of the wizard verifies the type of information that will be stored in the
Contact Management database: Contact information and Call information.
- Click the Next button to continue.
[h=2]Using a Wizard to Create the Contact Management Database
[h=3]Selecting the Tables and Fields to be included in the Contact Management Database
The second screen of the wizard identifies the tables to be created. Three tables were
created: Contact information, Call information, and Contact Types.
Click on any table to display the fields contained to it in the Fields in the table column. Click
on a different table and other fields used by that table will replace the ones displayed for the table selected.
[h=3]Selecting the Tables and Fields to be included in the Contact Management Database
The second screen of the wizard identifies the tables to be created. Three tables were
created: Contact information, Call information, and Contact Types.
Click on any table to display the fields contained to it in the Fields in the table column. Click
on a different table and other fields used by that table will replace the ones displayed for the table selected.
- Accept all other default field selections by leaving those checkboxes marked by a check.
- Click the Next button to continue.
[h=2]Using a Wizard to Create the Contact Management Database
[h=3]Defining the Format of the Screen Display
The third screen asks the question, What style would you like for screen displays? Microsoft
Access provides ten different screen displays for your use. A thumbnail picture is also provided for each format listed.
[h=3]Defining the Format of the Screen Display
The third screen asks the question, What style would you like for screen displays? Microsoft
Access provides ten different screen displays for your use. A thumbnail picture is also provided for each format listed.
- Click through the different format options displayed on the screen -- Blends, Blueprint, Expedition, etc. -- to display a picture of
- each format on the left side of the wizard screen. Highlight the desired format -- the Contact Management database used the
- Standard format -- to be used.
- Click the Next button to continue.
[h=2]Using a Wizard to Create the Contact Management Database
[h=3]Defining the Format of the Report Display
The third screen asks the question, What style would you like for printed reports? Microsoft Access
provides six different report displays for your use. A thumbnail picture is also provided for each format listed.
[h=3]Defining the Format of the Report Display
The third screen asks the question, What style would you like for printed reports? Microsoft Access
provides six different report displays for your use. A thumbnail picture is also provided for each format listed.
- Click through the different format options displayed on the screen -- Bold, Casual, Compact, etc. -- to display a picture of each
- format on the left side of the wizard screen. Highlight the desired format -- the Contact Management database used the
- Corporate format -- to be used.
- Click the Next button to continue.
[h=2]Using a Wizard to Create the Contact Management Database
[h=3]Naming the DatabaseThe next step is to assign a name to the database.
Assign a name to the database by typing a file name in the What would you like the title of the database to be field.
Click the Next button to continue.
[h=3]Naming the DatabaseThe next step is to assign a name to the database.
Assign a name to the database by typing a file name in the What would you like the title of the database to be field.
Click the Next button to continue.
[h=2]Using a Wizard to Create the Contact Management Database
[h=3]Finishing the Wizard
The final step asks whether the database being created is to be opened after it is built
by the wizard? It has no bearing whatsoever on the actual building of the database. If
you don't want to open the new database at this point then you can always return to
it later and open it in Microsoft Access.
[h=3]Finishing the Wizard
The final step asks whether the database being created is to be opened after it is built
by the wizard? It has no bearing whatsoever on the actual building of the database. If
you don't want to open the new database at this point then you can always return to
it later and open it in Microsoft Access.
- Leave or remove the checkmark that appears in the checkbox associated with the Yes, start the database prompt.
- Click the Finish button to initiate the database build.
[h=2]Using a Wizard to Create the Contact Management Database
[h=3]Challenge!
Review the Database Wizard screens shown in this lesson. These are the same screens used to create the Contact Management database.
Save and close the database.
[h=3]Challenge!
Review the Database Wizard screens shown in this lesson. These are the same screens used to create the Contact Management database.
- Open Microsoft Access.
- Choose File and then New from the menu bar.
- Select On my computer... under the Templates section of the Task Pane.
- Select the Expenses database. This is a good example of a database that could be used by a business to track expenses.
- Follow the steps indicated by the wizard to create the database. Make sure the box beside Yes, start the database is checked on the screen of the wizard.
- Navigate through the database by selecting various forms, tables, etc.
-
Save and close the database.
[h=2]Opening a Table and Learning to Navigate Records
[h=3]Opening an Existing Table in Datasheet View
Tables are created and maintained in the Tables tab of the Objects palette in Microsoft
Access. The Contact Management database contains four tables: Calls, Contact Types, Contacts, and
Switchboard Items. We will discuss the Contacts table in this lesson.
A table opened in Datasheet View resembles a Microsoft Excel
spreadsheet. It is used to input records into the database and will be discussed in this lesson.
[h=3]Opening an Existing Table in Datasheet View
Tables are created and maintained in the Tables tab of the Objects palette in Microsoft
Access. The Contact Management database contains four tables: Calls, Contact Types, Contacts, and
Switchboard Items. We will discuss the Contacts table in this lesson.
A table opened in Datasheet View resembles a Microsoft Excel
spreadsheet. It is used to input records into the database and will be discussed in this lesson.
[h=2]Opening a Table and Learning to Navigate Records
[h=5]To Open an Existing Table (Contacts) from the Tables Object:
[h=5]To Open an Existing Table (Contacts) from the Tables Object:
- Open the Contact Management database.
- In the database window, click on the Tables tab from the Object palette.
(If the database window is not displayed, then choose WindowContact Management: Database from the menu bar.)
- To open the table in Datasheet View, double-click the Contacts table in the right window pane.
(You could also either click once on the Contacts form and then click the Open button, or you could right-click on the Contacts form and select Open from the shortcut menu.
[h=2]Opening a Table and Learning to Navigate Records
[h=3]Using the Status Area to Navigate through the Records in a Table
The Datasheet View looks like an Excel spreadsheet. It consists of columns and rows. Field
names -- Contact ID, First Name, Last Name, Dear, Address, City, State, etc. -- appear as column
headings. Records represent rows with data input into the fields. The number of rows that appear
in the table will equal the number of records that have been added to the table. One blank row always
appears as the last row of the database. This blank row is used to add a new record the table.
The status area in the lower left area of the window indicates the number of records in
the table as well as the record number displayed in the window.
[h=3]Using the Status Area to Navigate through the Records in a Table
The Datasheet View looks like an Excel spreadsheet. It consists of columns and rows. Field
names -- Contact ID, First Name, Last Name, Dear, Address, City, State, etc. -- appear as column
headings. Records represent rows with data input into the fields. The number of rows that appear
in the table will equal the number of records that have been added to the table. One blank row always
appears as the last row of the database. This blank row is used to add a new record the table.
The status area in the lower left area of the window indicates the number of records in
the table as well as the record number displayed in the window.
[h=2]Opening a Table and Learning to Navigate Records
[h=5]To Navigate Using the Status Area:
[h=5]To Navigate Using the Status Area:
- Click the arrows in the status area to move to the first record, previous record, next record, or last record in the table.
- The new record button displays a blank row into which information for a new record can be added to the table.
[h=2]Opening a Table and Learning to Navigate Records
[h=3]Displaying Records by Scrolling Through the Table
The vertical scroll bar is located along the right edge of the screen and can be used to
move up or down the table if the total number of records exceed the records shown on
the screen. Similarly, the horizontal scroll bar located at the bottom of the screen can
be used to move left or right across the window if the fields in a table exceed the
number of fields displayed on the screen.
[h=5]Using the Vertical Scroll Bar:
[h=3]Displaying Records by Scrolling Through the Table
The vertical scroll bar is located along the right edge of the screen and can be used to
move up or down the table if the total number of records exceed the records shown on
the screen. Similarly, the horizontal scroll bar located at the bottom of the screen can
be used to move left or right across the window if the fields in a table exceed the
number of fields displayed on the screen.
[h=5]Using the Vertical Scroll Bar:
- Click the up or down arrows in the scroll bar to move up or down through the table records.
- Click the left or right arrows in the scroll bar to move left or right through the fields in a table.
[h=2]Opening a Table and Learning to Navigate Records
[h=3]Using the Keyboard to Navigate Table Records
Another way to navigate records in a table is to scroll up and down one screen at a time using the
PageUp and PageDown keys on the keyboard. Other keys also provide shortcuts to move through fields and records, including:
[h=3]Using the Keyboard to Navigate Table Records
Another way to navigate records in a table is to scroll up and down one screen at a time using the
PageUp and PageDown keys on the keyboard. Other keys also provide shortcuts to move through fields and records, including:
| Key: | Selects the: |
| Tab | Next field to the right |
| Shift + Tab | Next field to the left |
| End | Last field of the record |
| Home | First field of the record |
| Down Arrow | Same field in the next record |
| Up Arrow | Same field in the previous record |
| Page Down | Next screen of table records |
| Page Up | Previous screen of table records |
| Ctrl + End | Last field of the last record in the table |
| Ctrl + Home | First field in the first record in the table |
[h=2]Opening a Table and Learning to Navigate Records
[h=3]The Record Selector
The Record Selector located to the left of each record in Datasheet View identifies the operation being performed against a selected record at any given time.
The Record Selector can display any of the following symbols:
indicates the current record. The record is saved with the information displayed on the screen.
A blank record row always appears as the last row in a table. You must add new table records using this row.
[h=3]The Record Selector
The Record Selector located to the left of each record in Datasheet View identifies the operation being performed against a selected record at any given time.
The Record Selector can display any of the following symbols:
-
indicates the selected record is being edited and the changes have not yet been saved.
-
indicates a blank record into which information for a new record can be added to the table.
[h=2]Opening a Table and Learning to Navigate Records
[h=3]Challenge!
[h=3]Challenge!
- Open the Contact Management database.
- Open the Contacts table in Datasheet View.
- Click through each of the following buttons in the Status Area: Next Record, Last Record, Previous Record, and First Record.
- Practice scrolling through the table using the horizontal and vertical scroll bars.
- Take a screen print of the window showing the horizontal and vertical scroll bars.
- Practice using the keyboard to navigate through table records. Notice how the cursor moves from record to record for each of the following keys:
- Tab
- Shift + Tab
- End
- Home
- Page Down
- Page Up
- Down Arrow
- Up Arrow
- Ctrl + End
- Ctrl + Home