اموزش کامل Access 2010-En

[A M I R]

[h=2]Getting Started in Access

[h=4]To Get to Backstage View:

Click the File tab.

You can choose an option on the left side of the page.

To get back to your database objects, just click any tab on the Ribbon.


Click the buttons in the interactive below to learn about the different things you can do in Backstage view.

​

 

[A M I R]

[h=2]Getting Started in Access

[h=3]The Navigation Pane


The Navigation Pane is a list containing every object in your database. For easier viewing, the

objects are organized into groups by type. You can open, rename, and delete objects using the Navigation Pane

​

 

[A M I R]

[h=2]Getting Started in Access

[h=4]To Minimize and Maximize the Navigation Pane:

The Navigation Pane is designed to help you manage all your objects, but if you feel

that it takes up too much of your screen space, you can minimize it.




Click the double arrow

in the upper-right corner of the Navigation Pane to minimize it.

To make the Navigation Pane visible again, click the double arrow

to maximize it.

If you would like to make the Navigation Pane smaller without fully minimizing it, you can resize it. Simply

click and drag the right border of the Navigation Pane. When it is the desired size, release your mouse.

​

 

[A M I R]

[h=2]Getting Started in Access

[h=4]To Sort the Objects in the Navigation Pane:
By default, your objects are sorted by type, with the tables in one group, the forms in another, and so on. However, if you

wish, you can sort the objects in the Navigation Pane into groups of your choosing.




Click the drop-down arrow to the right of the words All Access Objects.

In the drop-down menu, select the desired sort.

• Select Custom to create a custom group for sorting the objects. After applying the sort, simply drag the desired objects to the new group.

• Select Object Type to group the objects by type. This is the default setting.

• Select Tables and Related Views to group forms, queries, and reports together with the tables they refer to.

• Select Created Date or Modified Date to sort the objects from most to least recently created or modified.

The objects in the Navigation Pane will now be sorted to reflect your choice.

To further customize the appearance of the Navigation Pane, you can also minimize groups of objects you don't

want to see. Simply click the upward double arrow

next to the name of the group. To restore the group to its full size, click the downward double arrow

.

​

 

[A M I R]

[h=2]Getting Started in Access

[h=3]Databases with Navigation Forms

Some databases include a navigation form that opens automatically when the database is opened. Navigation

forms are designed as a user-friendly replacement for the Navigation Pane. They contain tabs that allow you

to view and work with common forms, queries, and reports. Having your frequently-used objects available to you

in one place lets you access them quickly and easily.




To open an object from a navigation form, simply click on its tab. The object will be displayed within the

navigation form. Once an object is open, you can work with it as you normally would.

Generally, navigation forms include only the objects a typical user will need to work with fairly regularly, which

is why your navigation form may not include every single form, query, or report. This makes it easier to navigate

around the database. By hiding tables and rarely used forms, queries, and reports, it also reduces the chance of

the database being damaged by users accidentally editing or deleting necessary data.




For this reason, it's important to ask your database designer or administrator before you work with objects

that are not available in your navigation form. Once you have the go-ahead, you can simply maximize

the Navigation Pane and open the objects from there.

​

 

[A M I R]

[h=2]Getting Started in Access

[h=3]Challenge!
Open Access 2010 on your computer. Open an existing database. If you would like, you can use our example.

Try minimizing and maximizing the Ribbon.

Click through all of the tabs and notice how the Ribbon options change.

Resize the Navigation Pane to make it take up less room.

Re-sort the objects in the Navigation Pane.

​

 

[A M I R]

[h=2]Managing Databases and Objects

[h=3]Introduction

Each Access database consists of multiple objects that let you interact with data. Databases can include forms for entering data, queries

for searching within it, reports for analyzing it, and of course, tables for storing it. Whenever you work with your database, you are

working with many of these objects at once. Fortunately, Access makes managing these objects pretty easy.


In this lesson, you will learn how to to open and close databases, as well as how to open, close, and save objects.

​

 

[A M I R]

[h=2]Managing Databases and Objects

[h=3]Opening and Closing Databases

Before you enter data or otherwise modify your objects, you

will have to open your database.

​

 

[A M I R]

[h=2]Managing Databases and Objects

[h=4]To Open an Existing Database:


Click the File tab. This takes you to Backstage view.

Select Open. A dialog box will appear.

Locate and select the desired database, then click Open.

One or more warning messages may appear when you open your database.

If the database contains customized functions, a yellow bar with a security warning may appear below

the Ribbon. If you trust the source of your database, click Enable Content for your database to display correctly.

After enabling all content in the database, you may see a message asking if you want to

make the database a Trusted Document. Click yes if you would like all content to be automatically enabled each time you open the database.

You may be prompted to Log In to the database. Select your name from the log in list. If your name does not appear, click Add User to enter your information.

If you have opened the existing database recently, it may be easier to look for your database in the short list

that appears in the sidebar or to select Recent and choose a database from the list that appears.

​

 

[A M I R]

[h=2]Managing Databases and Objects

[h=4]To Close a Database:

Click the File tab to go to Backstage View.



Select Close Database.

If you have any unsaved objects, a dialog box will pop up for each one asking if you would like to

save it. Select Yes to save the object, No to close it without saving, or Cancel to leave your database open.

​

 

[A M I R]

[h=2]Managing Databases and Objects

[h=3]Working with Objects

It's helpful to think of your database as a large binder or folder in which you store your data. The data itself

is contained in database objects. Access 2010 treats each of these objects as separate documents, which

means that you will have to open and save them individually in order to work with them.




You may have noticed that this lesson contains no instructions for saving a database. That's because you

cannot save an entire database at once. Rather, you must individually save the objects contained within the database.

​

 

[A M I R]

[h=2]Managing Databases and Objects

[h=4]To Open an Object:
In the Navigation Pane, locate the object you would like to open.

Double-click the desired object. It will open and appear as a tab in the Document Tabs bar.

By default, the most recently opened object will display in the main window as the current object. To view

another open object, simply click its tab in the Document Tabs bar.

​

 

[A M I R]

[h=2]Managing Databases and Objects

[h=4]Saving Objects

As in other Microsoft Office programs, you will be prompted to save any unsaved work when you

attempt to close your database. However, it is a good idea to save your work as you go along. Saving

your work often is the best way to ensure that you don't lose any information if your computer crashes.



​

 

[A M I R]

[h=2]Managing Databases and Objects

[h=4]To Save a New Object:

Select the object you wish to save by clicking its tab in the Document Tabs bar.

Select the File tab to navigate to Backstage View.

Click Save.

The first time you save an object, you will be prompted to name it. Enter the desired object name, and click OK.

To save an existing object, select save in Backstage View, or simply click the Save command in the Quick Access Toolbar.

​

 

[A M I R]

[h=2]Managing Databases and Objects

[h=4]To Close an Object:
Select the object you wish to close on the Document Tabs bar.

Click the

on the far right of the Document Tabs bar.

If there are any unsaved changes to the object, you will be prompted to save it. Select Yes to

save, No to close it without saving your changes, or Cancel to leave the object open.

You can also close an object by right-clicking its tab on the Document Tabs bar. A drop-down menu will

appear. Select Close to close that object, or Close All to close all open objects.

​

 

[A M I R]

[h=2]Managing Databases and Objects

[h=4]To Rename an Object:


If the object you wish to rename is open, close it.

In the Navigation Pane, right-click the object you would like to rename.

Select Rename.

Type the new name, then press the Enter key.

 

[A M I R]

[h=2]Managing Databases and Objects

[h=3]Challenge!
Open Access 2010 on your computer, and open an existing database. If you want, you can use our sample database.

Open an object.

Close the object.

Rename the object.

Close the database without saving your changes.

​

 

[A M I R]

[h=2]Working with Tables

[h=3]Introduction

While there are four types of database objects in Access 2010, tables are arguably the most important. Even when you're using

forms, queries, and reports, you're still working with tables, since that's where all your data is stored. Tables are at the heart of

any database, so it's important to understand how to use them.


In this lesson, you will learn how to open tables, create and edit records, and modify

the appearance of your table to make it easier to view and work with.

​

 

[A M I R]

[h=2]Working with Tables

[h=3]Table Basics
[h=4]To Open an Existing Table:



Open your database and locate the Navigation Pane.

In the Navigation Pane, locate the table you would like to open. Tables are marked with the

icon.

Double-click the name of the table. It will open and appear as a tab in the Document Tabs bar.

 

[A M I R]

[h=2]Working with Tables

[h=4]Understanding Tables
All tables are composed of horizontal rows and vertical columns, with small rectangles called cells in

the places where rows and columns intersect. In Access, rows and columns are referred to as records and fields.

A field is a way of organizing information by type. Think of the field name as a

question, and every cell within that field as a response to that question.

A record is one unit of information. Every cell on a given row is part of that row's record. Each record has its

own ID number. Within a table, each ID number is unique to its record, and refers to all the information

within that record. The ID number for a record cannot be changed.

Each cell of data in your table is part of both a field and a record. For instance, if you had a table of names and

contact information, each person would be represented by a record, and each piece of information about them-- their

name, phone number, address, and so on-- would be contained within a distinct field on that record's row.

[h=4]

​