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

[A M I R]

[h=2]Formatting Forms

[h=4]Command Buttons

If you want to create a way for users of your form to quickly perform specific actions and tasks, consider

adding command buttons. When you create a command button, you specify an action for it to carry out

when clicked. By including commands for common tasks right in your form, you're making the form easier to use.




Access offers many different types of command buttons, but they can be divided into a few main categories, including:

• Record Navigation command buttons, which easily allow your user to move among the records in your database.
• Record Operation command buttons, which let your user do things like save or print a record.
• Form Operation command buttons, which give your user the ability to quickly open or close a form, print the current form, and other actions.
• Report Operation command buttons, which offer the user a quick way to do things such as preview or mail a report from the current record.

​

 

[A M I R]

[h=2]Formatting Forms

[h=4]To Add a Command Button to a Form:

In Form Layout view, select the Form Layout Tools Design tab and locate the Controls group.


Select the Button command.

Your cursor will turn into a tiny crosshairs with a button icon

. Place it in the spot where you would like your command button to be, and click.

The Command Button Wizard will appear. In the Categories pane, select the category of button you

want to add. We want to find a way to move more quickly to specific records, so we'll choose the Record Navigation category.




The list in the Actions pane will update to reflect your chosen category. Select the action you

would like the button to perform, then click Next. For our example, we'll choose Find Record.

You can now decide whether you want your button to include text or a picture. A live preview of your button appears on the left.

To include text, select the Text option and type the desired word or phrase into the text box.

To include a picture, select the Picture option. You can decide to keep the default picture for that command button, or

select another picture. Click Show All Pictures to choose from another command button icon, or Browse... to choose a picture from your computer.

When you are satisfied with the appearance of your command button, click Next.



Type a name for the button. This name won't appear on the button, but knowing the name will help you quickly

identify the button if you ever want to modify it with the Property Sheet. After typing the button name, click Finish.

Switch to Form viewto test the new button. Our Find Record button opens the Find and Replace dialog box.

Some users report that Access malfunctions while formatting forms. If you have a

problem performing any of these tasks in Layout view, try switching to Design View.

​

 

[A M I R]

[h=2]Formatting Forms

[h=3]Modifying Form Layout

When you create a form, Access arranges the form components in a default layout where the fields are neatly

stacked up on top of each other, all exactly the same width. While this layout is functional, you might find that it

doesn't best fit your information. For instance, in the form below, most of the fields are almost completely empty, since

the data stored there doesn't take up much room.

The form would fit the data a little better if we made the fields and command buttons smaller, and even

put some of them side by side. However, with the default layout, you won't be able to put two fields next to

each other or resize one field or button without resizing them all. This is because Access lines up form

components in rows and columns. When you resize a field, you're really resizing the column that contains it.

To resize and rearrange our fields the way we want, we'll have to modify the form layout. For instance, since

the default layout for our form contains only two columns-- one for the field labels and another for the fields-- we

would have to create a new column to put two fields side by side.




We can do this using the command on the Arrange tab, which contains all the tools you need to customize your form's layout. If you've

ever built and modified tables in Microsoft Word, you already know how to use most of these tools

​

 

[A M I R]

[h=2]Formatting Forms

[h=4]To Resize Form Components:
Switch to Layout view.

Select the field or button you would like to resize, and hover your mouse over the edge. Your cursor will become a double-sided arrow

.

Click and drag the edge to resize, and release when the field or button is the desired size.

The field or button, as well as every other item in line with it, will be resized.

​

 

[A M I R]

[h=2]Formatting Forms

[h=4]To Move Form Components:
If necessary, add columns or rows to make room for the field or button you wish to move, by using the Insert commands in the Rows & Columns group.

In our example, we want to move the Last Name field to the right of to the First Name field, so we'll have to

create two new columns to the right: one for the field label, and one for the field itself. To do this, we'll

click the Insert Right command twice.

Click and drag the field or button to its new location. If you're moving a field, make sure to move the field label, as well.

Repeat steps 1-2 with any other fields or buttons you wish to move.

If you would like to make a field take up more or less space than one column, you can use the Merge and

Split commands. The Merge command combines two or more cells, while the Split command divides a cell.

​

 

[A M I R]

[h=2]Formatting Forms

[h=3]More Formatting Options
Adding logos and other images to your forms can greatly improve their appearance, as can applying theme

colors and fonts. To learn how to add images and theme elements to your forms,

​

 

[A M I R]

[h=2]Formatting Forms

[h=4]Modifying the Colors and Fonts of Form Components
To further customize the appearance of your forms, you can apply different colors and fonts to individual

fields, buttons, labels, and other form components. Modifying form appearance this way is useful if you want

to use a certain color or font scheme in a form, but don't want those design elements to apply to your entire database.




For instance, in the form below, we modified the font of our form title. We also applied a new fill and

border color to the form fields, and are doing the same with the command buttons.

You can make these changes using formatting techniques and tools similar to the ones you would use to modify

shapes in Word and other Office programs. Simply select the object you want to modify while in Layout or Design

view and use the formatting options on the Format tab to customize the its appearance. For more information

about making these types of modifications,
​

 

[A M I R]

[h=2]Formatting Forms

[h=3]Challenge!

If you haven't already, download our sample database and open it.


Open the Order Items form.


Add a command button that creates a new record.


Format the newly added command button with the colors and style of your choosing.


Change the theme colors and theme fonts.


Add a logo.

 

[A M I R]

[h=2]Designing Your Own Database

[h=3]Introduction

Now that you know how to use and modify existing databases, you might be interested in designing your own. Database

design can be very complicated-- so complicated, in fact, that people take extensive courses just to learn how to plan

databases. For that reason, we haven't focused on creating a database from scratch in this course. However, we can help you get started.


In this lesson, you will learn how to create a database from an existing template. You will also

learn about other resources you can use to learn database design.

​

 

[A M I R]

[h=2]Designing Your Own Database

[h=3]Creating a Database from a Template
Before deciding to build your own database, you may want to look at the templates included in Access to see if any

of them match your needs. When you select a template, Access creates a new database based on that template. Once it's

created, you can fill the database with your own information, or modify it to suit your needs.



​

 

[A M I R]

[h=2]Designing Your Own Database

[h=4]To Create a Database from a Template:
Select the File tab. This will take you to Backstage View.

On the sidebar, click New.

Template options will appear. Under the Office.com Templates heading, you can see a list of templates

grouped by type. Select the template type that best fits your needs.

Access will display all of the available templates of that type. Select a template to see

more information about it, including a visual preview, on the right.

When you have found the template you'd like to use, click Download. The template will open automatically once it's finished downloading.

​

 

[A M I R]

[h=2]Designing Your Own Database

[h=3]More Resources on Database Design
Unfortunately, it can be hard to find free, high-quality resources on database design. On this page, you'll find links

to online resources that can help you get started. You can also contact your local library for instructional books.




If you are willing to devote even more time and resources to learning about database design, you can also

search for Access 2010 Certification Classes online and in your community. However, as a rule, these classes are not free.





​

 

[A M I R]

[h=2]Designing Your Own Database

[h=4]Free Online Resources

Microsoft's Official Access 2010 Basics Training

This six-part series offers guidance on database design and creation. The course is self-paced and

includes examples and practice tasks for each lesson. When you are finished with a lesson, click

the Quick Reference Card link for a link to the next lesson.

---

About.com: Building an Access Database from the Ground Up


About.com's tutorial guides you through the process of creating a database for a small business. This tutorial

refers to an earlier version of Access, but a majority of the instructions are still relevant for Access 2010.

​