Easy Microsoft Office Access 2003
Authors: Oap]Hara S.
Published year: 2003
Pages: 66-67/174
Buy this book on amazon.com >>

Applying a Smart Tag

graphics/04inf15.jpg

graphics/one_icon.jpg

After you've opened the table you want to change in Design view, click in the field to which you want to apply a Smart Tag (in this example, the Artist field).

graphics/two_icon.jpg

In the property sheet, click in the Smart Tags field. A button featuring an ellipsis appears to the right of the field.

graphics/three_icon.jpg

Click the ellipsis button.

graphics/four_icon.jpg

The Smart Tags dialog box opens. In the Available Smart Tags list, click the check box next to the type of Smart Tag you want to apply (in this example, Person Name ) and click OK .

INTRODUCTION

One new feature of Office 2003 is Smart Tags, which enables you to use data from several applications at once. In many Office 2003 applications, Smart Tags appear when you complete an action that commonly occurs in conjunction with another action. For example, if you type a person's name, a Smart Tag appears; you can click it to select any number of options, such as sending an email, scheduling a meeting, and so on. In this task, you'll learn how to add Smart Tags to your database so that users can take advantage of the flexibility they offer.

graphics/04inf16.jpg

graphics/five_icon.jpg

Click the View button on the Standard toolbar in the main Access window to toggle to Datasheet view.

graphics/six_icon.jpg

Before it changes to Datasheet view, Access prompts you to save the changes to the table; click Yes to do so.

graphics/seven_icon.jpg

When you click the field in the table to which the Smart Tag was applied, a Smart Tag appears; click the down arrow to display the list of available actions.

HINT

Actions Vary

The Smart Tag's available actions vary depending on the type of Smart Tag you select in the Smart Tags dialog box (refer to step 4). Common data table field Smart Tags include Date, Financial Symbols (in various styles), and Person Name.

TIP

Displaying Additional Smart Tags

To view other available Smart Tags, click the More Smart Tags button in the Smart Tags dialog box.


Creating a Yes/No Field

graphics/04inf17.jpg

graphics/one_icon.jpg

After you've opened the table you want to change in Design view, click in the first empty row or insert a new row.

graphics/two_icon.jpg

Type a name for the field (in this example, Mailing List) and press Tab to move the insertion point to the Data Type column.

graphics/three_icon.jpg

Click the down arrow that appears in the Data Type column and click the Yes/No option in the list that appears.

INTRODUCTION

In Part 2, you learned how to create a table, but not about all the different types of fields you can add to a table. One such field type is the Yes/No field, useful for situations in which there are only two possible valid entries for a field: yes or no, true or false, or on or off. For example, you might use a Yes/No field to indicate whether a customer wants to be on a mailing list. You can add this type of field when you first create your table or later (as covered here).

graphics/04inf18.jpg

graphics/four_icon.jpg

Make changes as needed to the field properties in the property sheet. For example, change the Format property from Yes/No to True/False or On/Off.

graphics/five_icon.jpg

Click the View button on the Standard toolbar in the main Access window to toggle to Datasheet view.

graphics/six_icon.jpg

Before it changes to Datasheet view, Access prompts you to save the changes to the table; click Yes to do so.

graphics/seven_icon.jpg

The Yes/No field is added. Here it is formatted as a check box; click the check box to select it for Yes , or leave it blank for No .

TIP

Yes/No Field Displays

To change how a Yes/No field is displayed in the Datasheet and forms, click the Lookup tab in the property sheet, open the Display Control drop-down list, and choose Check Box, Text Box , or Combo Box .

Easy Microsoft Office Access 2003
Authors: Oap]Hara S.
Published year: 2003
Pages: 66-67/174
Buy this book on amazon.com >>