آموزش کامل Access 2003-En

[A M I R]

[h=2]Identifying the basic parts of the Access window

[h=3]The Main Access Window
When you open Microsoft Access, many items you see are standard in

most Microsoft software programs like Word, Excel, and PowerPoint.

[h=5]Menu bar

The Menu bar displays all the menus available for use in Access 2003. The contents of any menu

can be displayed by clicking on the menu with the left mouse button.



​

 

[A M I R]

[h=2]Identifying the basic parts of the Access window

[h=3]The Main Access Window (continued) [h=5]Toolbar

The pictured buttons in the toolbar are quick and easy shortcuts to specific actions. For example, if you want

to save a spreadsheet using the menus then you would first click File and then click Save. Using the toolbar

to perform this save operation actually saves you a click. Click the save button once to save the spreadsheet.

Some commands in the menus have pictures or icons associated with them. These pictures may also appear as shortcuts in the Toolbar.

​

 

[A M I R]

[h=2]Identifying the basic parts of the Access window

[h=3]The Database window [h=5]Database Toolbar

The Database toolbar presents operations that can be performed against different database

objects, including buttons to open an object, design an object, create a new object and delete an object.




​

 

[A M I R]

[h=2]Identifying the basic parts of the Access window

[h=5]Left Pane

Database objects are created and opened by choosing any of the buttons listed in the left pane of the database window.



[h=5]Right Pane

Any of the first four options -- Tables, Queries, Forms, or Reports -- opens additional choices related to that selection in the right pane.


Choosing the Tables button, for example, displays at least three options in the right

pane: 1) Create a table in Design view, 2) Create a table by using wizard, and 3) Create

table by entering data. It also shows any objects that you created in the database.







​

 

[A M I R]

[h=2]Identifying the basic parts of the Access window

[h=3]Challenge!


Display the contents of the File, Edit, View, Insert, Tools, Window, and Help menus in the main Access

menu bar. As each menu is displayed, you may want to write down all the contents listed under each.

Identify the operation performed by each button in the main Access toolbar.

Some buttons in the toolbar also appear alongside options listed in a menu. For each button in

the main Access toolbar, identify the menu where that operation can be performed.

​

 

[A M I R]

[h=2]Database Tables

[h=3]Introduction [h=4]By the end of this lesson, learners should be able to

• Understand datasheet basics

• Understand field properties

• Understand table relationships

• Understand the role of the primary key

​

 

[A M I R]

[h=2]Database Tables

[h=3]Datasheet basics


The core component of a database is a table. Data is defined and stored in a table. Multiple

tables -- each consisting of different types of data -- can be created in a database.

Each row in the database is called a record. The entry for John Smith is called a record. The entry

for Martha Tompkins is also a record. Each row or record is made up of columns

or fields -- L.Name, F.Name, Phone, Address, City, State, Zip -- which contain a particular piece of information.

L.Name	F.Name	Phone	Address	City	State	Zip
Smith	John	919.555.6320	100 Paramount Parkway	Morrisville	NC	27560
Tompkins	Martha	919.555.6427	97 Hummingbird Court	Cary	NC	27513

In a Contact Management database, a list of names -- those contacts to whom you

have sent resumes or have met through your personal network -- might be maintained

in a table, along with address, phone number, and other personal information.


​

 

[A M I R]

[h=2]Database Tables

[h=3]Field Properties
Every table contains a number of columns called fields or datatypes. Fields are unique pieces

of information that make up the information in a table. Tables usually contain multiple fields.


In a previous example we mentioned that a table might consist of the

fields: Last Name, First Name, Phone, Address, City, State, and Zip. Each field

has unique properties. Some contain characters. Others contain numbers. These

Field Properties are defined when the table is created.

​

 

[A M I R]

[h=2]Database Tables

[h=3]Understanding Table Relationships

Databases can be simple -- consisting of a single table -- or made up of many different

tables. If you were to convert your resume into a database, for example, you might

have a table that contains your name and personal mailing address. We might call

this the Contact_Information table.

Your work experience is a different kind of information. Instead of identifying who you are or

where you live, it identifies the companies you worked for, their addresses, your job title, and

responsibilities. Because this set of information is independent from the contact information, we

might instead create a second table called the Work_Experience table.



The same is true of your educational background. It has no direct bearing on your contact

information or the companies where you worked. A third table might be created called the Education table to save this kind of data.


The database contains three tables, each independent of the other, and all containing different

types of information. The database needs a way to connect these three tables.
​

 

[A M I R]

[h=2]Database Tables

[h=3]Primary Keys
Every table in Microsoft Access must have at least one field that uniquely identifies each

record in the table. This field is known as a primary key. This primary key essentially

opens the door to the table and allows you to retrieve information from the table.


The primary key is the mechanism by which you relate different tables and combine

information for viewing (query) or printing (report).

​

 

[A M I R]

[h=2]Database Tables

[h=3]Challenge!
Let us pretend that you are going to start your own home business. You are going

to need to prepare a database for your business and the first step is to design a

table that will contain a list of all your contacts that may one day be your clients or suppliers.


Let us assume that a database table called Business Contacts contains all the fields

listed in the first column of the following chart. The chart also contains four other columns:

• Text, Numbers or Both -- should the field accept data entry input in the form of text, numbers, or both?

• Field Size -- the number of spaces you think the field should have.

• Required Entry -- should the field be required entry (the record cannot be added to the
• database without the information) or optional entry (a record can be added without entry in the field)

• Allow Duplicates -- should the database allow duplicate entries for the field (e.g., can several people in the database share the same zip code)?

Practice designing fields by filling out the following table

.

	Text, Numbers, or Both?	Field Size	Required Entry?	Allow Duplicates?
First Name
Last Name
Company
Company Type
Address
City
State
Zip Code
Contact Id
Title
Work phone
Fax Number

​

 

[A M I R]

[h=2]Getting to know the Contact Management database

[h=3]Introduction [h=4]By the end of this lesson, learners should be able to:

• Download a database from the Web

• Open a database in Microsoft Access 2003

• Understand the tables, forms, and reports in the Contact Management database

​

 

[A M I R]

[h=2]Getting to know the Contact Management database

[h=3]Download the Contact Management Database

The Contact Management database used in this course can be downloaded

from the GCFLearnFree.org® Web site and installed on your computer.

GCFLearnFree.org's Access 2003 lessons all use examples from the Contact Management

Database. However, if you'd rather work with another existing database, you should have little problem following our lessons.
​

 

[A M I R]

[h=2]Getting to know the Contact Management database

[h=5]To Download the Contact Management Database:

• Click the link, and download and save the Contact Management database (992k).
  
  (Note, you must have an open connection to the Internet in order to download the database).
• The following dialog box appears:
  
  
  
• Click the Save button.

• You are prompted to save the database in some location on your computer. You will want to save the database in the c:\My Documents folder.
  
  
  
• Click the Save button to download the database.

​

 

[A M I R]

[h=2]Getting to know the Contact Management database

[h=3]Open the Contact Management database

Now that you've downloaded the Contact Management database, let us open and become familiar

with it. We will briefly discuss how it was created and look at some of its database components.


If properly downloaded, the Contact Management database will be present in the c:\My Documents folder

on your computer. It is recommended that you do not move the database from this location until after

you have completed the Access 2003 course.

​

 

[A M I R]

[h=2]Getting to know the Contact Management database

[h=5]To Open the Contact Management database:

• Open Microsoft Access by selecting its associated icon on the Windows desktop.

• Choose File
  
  Open from the menu bar.
  
  
  
• The Look In box in Microsoft Access 2003 defaults to the c:\My Documents when the application is first opened.
  
  If the My Documents folder does not appear in the Look In box, then click in the Look In drop-down box, and locate and select the My Documents folder.

• Select the Contact Management.mdb file.
  
  
  
• Click the Open button to open the Contact Management database.

The main Contact Management database screen appears on your computer screen:

​

 

[A M I R]

[h=2]Getting to know the Contact Management database

[h=3]Reviewing the Contact Management Tables

Tables are found in the database Object called Tables. The Contact Management database

contains four tables: Calls, Contact Types, Contacts, and Switchboard Items.

​

 

[A M I R]

[h=2]Getting to know the Contact Management database

[h=3]Reviewing the Contact Management Forms

Forms are found in the database Object called Forms. The Contact Management database

has seven forms that are used as both menus and data entry screens. These forms are Call

Details Subform, Call Listing Subform, Calls, Contact Types, Contacts, Report Date Range, and

Switchboard. You can define additional forms to meet your data entry needs.

​

 

[A M I R]

[h=2]Getting to know the Contact Management database

[h=3]Reviewing the Contact Management Reports
Reports are found in the database Object called Reports. The Contact Management database has

two reports defined to it: Alphabetical Contact Listing and Weekly Call Summary reports. You can

define additional reports in the database depending on your reporting needs.

​

 

[A M I R]

[h=2]Getting to know the Contact Management database

[h=3]Challenge!

If you haven't already done so, download and save the Contact Management database. (Note, you

must have an open connection to the Internet in order to download the database).

• Open the Contact Management database and view each of the following:

• • Tables object
  • Queries object
  • Forms object
  • Reports object

​