Installing Microsoft Office (Word, Excel, Access, Outlook, PowerPoint). Word, Outlook, Internet Explorer

MS Word provides a number of keyboard shortcuts to make your office work faster. If you need to use MS Word a lot, it is highly recommended that you learn a few useful keyboard shortcuts -It to help you get things done quickly. You can click Ctrl + B to make the text bold, Ctrl + U to underline the text. These keyboard shortcuts work in all parts of Microsoft Office like MS Excel, MS Outlook, MS PowerPoint, etc.

However, by default, MS Word does not provide shortcut for strikethrough command. Even though strikethrough is a commonly used command, it's surprising that Microsoft didn't create shortcut keys for strikethrough. But it's good that we can customize MS Word to create such a keyboard shortcut. Today I will teach you how to set up a quick way to make strikethrough text.

What is Strikethrough?

Sometimes in a document, you don’t need certain text, but you don’t want to delete it. In such cases, you can strikethrough text. A fragment of the text will remain in the document for later use (and even for subsequent inclusion) but at the same time, strikethrough will show the reader that the text is no longer relevant. It looks something like this: strikethrough

How to install Strikethrough shortcut in MS Word

You will need to do the following process only once and after that, you can cross out the text by pressing the combination of the selected key.

Open any MS Word document. You can even open a blank document as well.

Press Ctrl + D to open the Font dialog box. This window shows the font formatting options.

Now press Ctrl + Alt and while holding both of these keys down press plus key on the numeric keypad (Numpad).

The cursor will change to a stud in the shape of one. Release the Ctrl + Alt keys and click on the Strikethrough option in the Font dialog box (shown in the red circle in the image above).

Customize the Keyboard dialog box will open. Place the cursor in the field Key new print label and press the shortcut key combination you would like to set for the strikethrough option. I put it on Ctrl + Shift + S... you can also install it like that. Place the cursor in Press - new shortcut key and press Ctrl + Shift + S.

MS Word will automatically fix the keys you press. You can use any combination of Shift, Alt, Ctrl and key with letter. If you press a key combination that is already assigned to some other command, MS Word will show you this information. Better not to overwrite the existing shortcut. Ctrl + Shift + is a good combination.

Click on the button Assign to set the strikethrough shortcut.

Now, to check if it works or not, print something in your MS Word document. Select the text and press Ctrl + Shift + S (or whatever combination you have chosen). The selected text will immediately be strikethrough.

I hope you found this little customization tip strikethrough label in MS Word useful. If you have any questions about this topic, please feel free to ask me through the comments section of this page. I will try my best to be of service to you. Thank you for using TechWelkin!

Interaction between Outlook and Word is perhaps the most common example of collaboration. I have already mentioned above that the user can specify Microsoft Word as the message editor.

Example 18.1. Word as a message editor

(In Outlook app)

> Tools> Options Message

Use Microsoft Word as a message editor

Use Microsoft Word to read RTF messages

As an example of using Word, consider creating a message that contains curly text and a diagram that shows the structure of this book.

Create a message using Word

There are two ways to create a message using Word:

• Launch Word, create a document, and choose> File> Send> Message.
• Directly in the Outlook app by selecting the command > Actions> New message with> Microsoft Word (Fig. 18.1).

As you can see from the figure, the essence of the message has not changed, there are fields for entering recipients and the subject of the message, a signature and a panel have been automatically added Painting(Drawing), however, the toolbar has been significantly enriched Formatting(Formatting).

Rice. 18.1. Outlook Message (Microsoft Word Editor)

Insert curly text

So, let's first create a nice title for our message using WordArt.

Example 18.2. Insert WordArt

> Insert> Picture> WordArt

Select the desired lettering style OK

Text: = Book structure Bold OK

(Formatting Panel) Center

As a result of our actions, a beautifully designed text with a yellow gradient fill in the center will appear (Fig. 18.2).

To change the properties of this object, you can use the buttons of the toolbar of the same name. In our case, let's change the fill color from yellow to blue.

Rice. 18.2. WordArt text in message

Rice. 18.3. Dialog window Fill methods

Example 18.3. Change the properties of WordArt

(On the WordArt toolbar)

WordArt Format Color and Lines

Color Fill Methods ...

Gradient

One color Color1 Blue

Hatch type Center

Variants (Fig. 18.3)

Insert a chart

The next step we are considering is inserting a diagram, by the way, which is one of the innovations in Word.

Example 18.4. Insert a chart

> Insert> Organization Chart ...

Select the type of chart (fig. 18.4)

Rice. 18.4. Dialog window Chart library

A placeholder appears in the message body to show the selected chart. But it consists of one "root" and only three "branches", while this book has four parts. Let's add one more branch and change the chart style.

Example 18.5. Adding a branch to a diagram

(Highlight the root of the diagram)

(In Organization Chart pane) Add Shape

AutoFormat

Select a Bump Gradient chart style

Now it remains to enter the text of the diagram. To do this, click once with the left mouse button on one of the plugs of the diagram and enter the appropriate text. The final version of the message, edited and formatted using Word, is shown in Fig. 18.5.

Rice. 18.5. The final version of the message

After the message is created, it remains to fill in the fields To whom(That) and Theme(Subject), then press the button send(Send).

Comment

Since our message is being saved and sent in HTML format, some formatting elements may be lost or altered. Keep this in mind when creating your messages in Word! Sometimes it’s better to just attach created messages as an attachment.

As a reminder, this is just a general understanding of how Outlook and other Office applications work together. In addition to inserting objects (there are many more than two), there are also forms, frames, styles, tables, fields ... The list goes on and on. The world of Microsoft Office applications is wide and truly multifunctional. Explore it in parallel with Outlook and other existing applications. In the end, the road will be mastered by the walking ...

Sending a document along the route

By sending a document along the route(Routing) refers to sending a document by email to colleagues in a specific sequence. The sending sequence is called the route of the document.

Having received the document, the addressee can make his changes and comments and send the document further along the route. At the end of the route, after all the addressees specified in the routing list have viewed the document, you can request the return of the document or indicate the user for whom it is intended, for example, the project manager.

Example 18.6. Sending a document along a route

> File> Open ... (open the required document)

> File> Send> Along Route. ... ...

Nashatyrev Anton To

Mokhovikov Oleg To whom

Message text: = Dear colleagues! Read the attached document and give your thoughts and comments on what was written. Thank you in advance, Yegor Usarov.

in turn

Return at the end

Track status

send

Comment

While running this program, Outlook security dialog boxes may appear warning of third-party tampering and access to Outlook data. In this case, always agree to allow access (after all, this request comes from your actions, and you expect it).

The assigned route can be attached to the document in order to send it not immediately, but to do it later. To do this, at the last step of the program, you need to press the button Add(Add Slip).

> File> Send> Next Destination ...

Send document Anton Nashatyrev

To refuse to send the document along the route and disconnect the route altogether, you need to press the button Clear(Clear).

Let's go back to the example. After the button is pressed send(Route), a message will be automatically generated with the text specified in the field Message text(Message Text), and with an attached document to be sent (Fig. 18.6). Suppose that the first addressee (in our example, this is Anton Nashatyrev) is configured responsibly, that is, he will not leave the received message unattended or delete it without reading it, but will react to it properly: he will not only read the mailing message, but and the attached document itself, and not only read it, but also enter its wishes and comments into it, and then send it to the next correspondent. Let's try to follow how this happens.

To open the forwarded document itself, the recipient just needs to double-click on the icon of the attached document in the message. Next, the recipient makes their changes to the document in the usual way. At the end of the work, he must send the document further along the route.

> File> Send> Next Destination ...

Send document "Oleg Mokhovikov"

Rice. 18.6. Document mailing message

What happens after that? First, the message will be sent to the next addressee on the mailing list - Oleg Mokhovikov. He will be able to read the document with the changes already made and make his own. Second, the original sender will be notified of the movement of the document through the mailing list, because the dialog box Route(Routing Slip) checkbox was checked Track status(Track Status).

If all goes well, the document will move up the mailing list until the entire mailing list for that document has been exhausted. The last addressee in the route will be asked to return the changed document to the initiator of the distribution, and thus the circle will close.

To speed up the process, you can send the document not one by one, but all at once. In this case, the merger of the changes falls on the shoulders of the sender.

Invites for cooperation on a contractual, hourly basis Teachers / Trainers on project management methodologies.

If you are well versed in methodologies - PMI PMBOK 6 and / or Agile(Scrum, Kanban or others). We are ready to share our knowledge. Want to "pump" your public speaking skill. Or you are interested in a flexible work schedule, then this work is for you!

What do we have to do:

• Train students of courses in the training center / conduct trainings for corporate customers on project management methodologies for ready-made programs (the list and program of courses can be viewed on the website);
• There is an opportunity to try yourself in the development of author's courses in this area (the terms of cooperation are discussed individually with the candidates);
• If necessary and available to you, go on business trips - provided that the corporate Customer is not in the territory of Saratov (we pay for travel, accommodation).

What do you need from you:

• Knowledge of the subject at the level required to train students in the volume of one of the courses - "Project Management" and / or "Agile: Agile Methods of Management".
• Competent, clear and structured speech.
• Practical work experience as a project manager at least 2 years (your experience in realizing real projects is valuable);
• Activity, ability to motivate, responsibility, ability to find an approach to different types of people.

Conditions:

• Flexible schedule that can be combined with the main job;
• Flexible system of payment for the conducted classes;
• Payment terms are discussed individually with each candidate and will depend on your qualifications and download capabilities.

Key skills:

• Project management
• Agile
• Project Management

In addition to Outlook, the Microsoft Office suite includes common applications such as the Word text editor, the Excel spreadsheet editor, the PowerPoint electronic presentation application, and the Access database application.

All of these applications are independent and self-contained, but their joint use opens up truly unlimited possibilities in organizing office work. Using Outlook along with other applications included with Microsoft Office allows you to:

• create messages using the full power of the Word text editor. Compared to the relatively poor (albeit sufficient) capabilities provided by the Outlook Formatting Bar, Word is capable of creating rich documents with a variety of styles and templates, containing embedded objects, etc. The interaction between Outlook and Word will be discussed in the first section of this chapter. ... Moreover, this section will cover a tool common to all Office applications - mailing along the route;
• create messages using the full power of the Excel spreadsheet editor. The created table can be easily sent not only as an attached file, but also saved as a message. This feature will be discussed in the second section of this chapter. Also, in this section, we will talk about a tool common to all Microsoft applications - placing documents in a shared folder;
• Create meetings to participate in a PowerPoint e-conferencing. The creation of an electronic conference is directly related to the use of the above Microsoft NetMeeting application (see section 11.5 "Net Meeting"). How PowerPoint works with Outlook will be covered in the third section;
• create messages using Microsoft Access capable of connecting to a remote database to display information. Using Outlook and Access together allows you to quickly export and import data from Outlook folders into Access tables. This possibility will be discussed in the fourth and final section of this chapter.

Outlook and Word

Interaction between Outlook and Word is perhaps the most common example of collaboration. I have already mentioned above that the user can specify Microsoft Word as the message editor.

Example 18.1. Word as a message editor

(In Outlook app)

> Tools> Options Message

Use Microsoft Word as a message editor

Use Microsoft Word to read RTF messages

As an example of using Word, consider creating a message that contains curly text and a diagram that shows the structure of this book.

Create a message using Word

There are two ways to create a message using Word:

• Launch Word, create a document, and choose> File> Send> Message.
• Directly in the Outlook app by selecting the command > Actions> New message with> Microsoft Word (Fig. 18.1).

As you can see from the figure, the essence of the message has not changed, there are fields for entering recipients and the subject of the message, a signature and a panel have been automatically added Painting(Drawing), however, the toolbar has been significantly enriched Formatting(Formatting).

Rice. 18.1. Outlook Message (Microsoft Word Editor)

Insert curly text

So, let's first create a nice title for our message using WordArt.

Example 18.2. Insert WordArt

> Insert> Picture> WordArt

Select the desired lettering style OK

Text: = Book structure Bold OK

(Formatting Panel) Center

As a result of our actions, a beautifully designed text with a yellow gradient fill in the center will appear (Fig. 18.2).

To change the properties of this object, you can use the buttons of the toolbar of the same name. In our case, let's change the fill color from yellow to blue.

Rice. 18.2. WordArt text in message

Rice. 18.3. Dialog window Fill methods

Example 18.3. Change the properties of WordArt

(On the WordArt toolbar)

WordArt Format Color and Lines

Color Fill Methods ...

Gradient

One color Color1 Blue

Hatch type Center

Variants (Fig. 18.3)

Insert a chart

The next step we are considering is inserting a diagram, by the way, which is one of the innovations in Word.

Example 18.4. Insert a chart

> Insert> Organization Chart ...

Select the type of chart (fig. 18.4)

Rice. 18.4. Dialog window Chart library

A placeholder appears in the message body to show the selected chart. But it consists of one "root" and only three "branches", while this book has four parts. Let's add one more branch and change the chart style.

Example 18.5. Adding a branch to a diagram

(Highlight the root of the diagram)

(In Organization Chart pane) Add Shape

AutoFormat

Select a Bump Gradient chart style

Now it remains to enter the text of the diagram. To do this, click once with the left mouse button on one of the plugs of the diagram and enter the appropriate text. The final version of the message, edited and formatted using Word, is shown in Fig. 18.5.

Rice. 18.5. The final version of the message

After the message is created, it remains to fill in the fields To whom(That) and Theme(Subject), then press the button send(Send).

Comment

Since our message is being saved and sent in HTML format, some formatting elements may be lost or altered. Keep this in mind when creating your messages in Word! Sometimes it’s better to just attach created messages as an attachment.

As a reminder, this is just a general understanding of how Outlook and other Office applications work together. In addition to inserting objects (which are much more than two), there are also forms, frames, styles, tables, fields ... The list goes on and on. The world of Microsoft Office applications is wide and truly multifunctional. Explore it in parallel with Outlook and other existing applications. In the end, the road will be mastered by the walking ...

Sending a document along the route

By sending a document along the route(Routing) refers to sending a document by email to colleagues in a specific sequence. The sending sequence is called the route of the document.

Having received the document, the addressee can make his changes and comments and send the document further along the route. At the end of the route, after all the addressees specified in the routing list have viewed the document, you can request the return of the document or indicate the user for whom it is intended, for example, the project manager.

Example 18.6. Sending a document along a route

> File> Open ... (open the required document)

> File> Send> Along Route. ... ...

Nashatyrev Anton To

Mokhovikov Oleg To whom

Message text: = Dear colleagues! Read the attached document and give your thoughts and comments on what was written. Thank you in advance, Yegor Usarov.

in turn

Return at the end

Track status

send

Comment

While running this program, Outlook security dialog boxes may appear warning of third-party tampering and access to Outlook data. In this case, always agree to allow access (after all, this request comes from your actions, and you expect it).

The assigned route can be attached to the document in order to send it not immediately, but to do it later. To do this, at the last step of the program, you need to press the button Add(Add Slip).

> File> Send> Next Destination ...

Send document Anton Nashatyrev

To refuse to send the document along the route and disconnect the route altogether, you need to press the button Clear(Clear).

Let's go back to the example. After the button is pressed send(Route), a message will be automatically generated with the text specified in the field Message text(Message Text), and with an attached document to be sent (Fig. 18.6). Suppose that the first addressee (in our example, this is Anton Nashatyrev) is configured responsibly, that is, he will not leave the received message unattended or delete it without reading it, but will react to it properly: he will not only read the mailing message, but and the attached document itself, and not only read it, but also enter its wishes and comments into it, and then send it to the next correspondent. Let's try to follow how this happens.

To open the forwarded document itself, the recipient just needs to double-click on the icon of the attached document in the message. Next, the recipient makes their changes to the document in the usual way. At the end of the work, he must send the document further along the route.

> File> Send> Next Destination ...

Send the document "Oleg Mokhovikov"

Rice. 18.6. Document mailing message

What happens after that? First, the message will be sent to the next addressee on the mailing list - Oleg Mokhovikov. He will be able to read the document with the changes already made and make his own. Second, the original sender will be notified of the movement of the document through the mailing list, because the dialog box Route(Routing Slip) checkbox was checked Track status(Track Status).

If all goes well, the document will move up the mailing list until the entire mailing list for that document has been exhausted. The last addressee in the route will be asked to return the changed document to the initiator of the distribution, and thus the circle will close.

To speed up the process, you can send the document not one by one, but all at once. In this case, the merger of the changes falls on the shoulders of the sender.

Outlook and Excel

From the very beginning of the book, when creating a message, we set ourselves the goal of transferring not just text, but a table as the body of the message. Using Excel tools allows you to easily solve not only the problem of inserting tables, but also related components (for example, Excel charts).

As an example of how Outlook and Excel can work together, consider sending a message that contains a table showing the number of pages for each part of a workbook, and an Excel chart that graphically displays the percentage of each part in the workbook.

Create a message using Excel

As with Word, there are two ways to create a message. But if in Word we chose the second option (composing a message from Outlook), now let's look at sending the spreadsheet directly from Excel.

Rice. 18.7. Outlook Message (Microsoft Excel Editor)

Example 18.9. Create a message using Excel

> File> Send> Message

Include the current sheet in the message text

Subject: = Statistics

Introduction: = This message contains ...

Comment

In the Introduction field, the user can enter a text message (comment) preceding the table.

As mentioned above, we will consider sending the table shown in Fig. 18.10. At this stage, the table contains only text and has no additional formatting.

Working with a table

Before sending a message containing a table, it is advisable to format it: highlight the header, underline borders, etc. But Outlook's capabilities allow you not only to format the table, but also to work on its logic. In Example 18-10, we added another row, "Total," containing the sum of all the pages in the book, and then styled the table accordingly.

If the text of the message does not fit in the cell, you can expand its borders. To do this, move the mouse pointer to the junction with the name or numbering of cells (the pointer will take the form of a double-headed arrow) and, while holding down the left mouse button, move the column or row boundaries to the required distance.

Example 18.10. Working with an Excel spreadsheet

(Editing)

A6: = Total

Wb Autosum (Formatting)

A1: Wb (Select while holding down the left mouse button)

> Format > Autoformat ...

Rice. 18.8. Formatted message with Excel spreadsheet

Comment

In addition to using the automatic style, you can apply additional formatting using the buttons of the toolbar of the same name.

Insert an Excel chart

The next step, demonstrating the capabilities of Excel and using it with Outlook, is to create a chart that graphically represents the data on the worksheet.

Example 18.11. Insert an Excel chart

> Insert> Chart ... Standard

Type Circular

Chart title: = Outlook in original

Data Signature Shares

Rice. 18.9. The plotted diagram

Comment

If we had not selected the A2: B6 range before starting the chart creation, we could have set it later, at the second step of the Chart Wizard. It is not at all necessary to manually enter a complex formula in the Data Range field. It is enough to select the desired range on the worksheet with the mouse, and the wizard's dialog box will collapse so as not to interfere with the selection, and the formula will appear automatically.

After inserting a chart, it can overlap the table in use. In order to move the diagram, it is enough to select it and, holding the left mouse button, drag it to the required place.

Now let's turn directly to the diagram itself. All elements are displayed clearly and beautifully, with the exception of the data circle itself, which turned out to be very small. To increase the plotting area of ​​the diagram, you must click on the invisible square in which a circle and text explanations are inscribed (Fig. 18.9). A square box appears with selection handles in the corners. Hook these handles and drag, stretching the selection box until the circle is the size you want.

So, the message is completely ready for sending, it remains to enter the address of the recipient of the message and press the button Send sheet(Send this Sheet).

Of particular interest is how our message will be displayed to the user, because, firstly, it is converted to HTML format, and secondly, not every recipient can have Excel installed. After sending and receiving messages, go to v folder Inbox(Inbox) and open the created message (Fig. 18.10).

Rice. 18.10. Received message with table and chart

First, as you can see, the text entered in the field Introduction(Introduction) precedes the table and is separated from it by a bar. Secondly, the format of the table is preserved. And finally, we are proud of the fact that the diagram is exactly the same as the created one (format, data, etc.). The only thing missing is there is no signature as we created our message from Excel and not from Outlook. This flaw could be corrected by executing the command> Insert> Signature> Regards before sending.

Example 18.12. Insert signature

> Insert> Signature> Regards

Comment

Generally speaking, additional editing and formatting of messages is sometimes necessary, if not required. After creating a table (using Excel), the user can always open the message and edit: insert a signature or a number of additional notes, as well as add a background, add a picture, etc.

Exchange folder

Working with Exchange folders is as common to all Office applications as route mailing. The essence of this feature is in the placement of the active document in the public folders of the Microsoft Exchange server. Thus, the user, as it were, opens access to this document to all members of the working group.

Example 18.13. Send to Exchange folder

> File> Send> Exchange Folder ...

Select a folder < Общая папка>

After the document is placed in the shared folder, each of the users can open it by clicking on the corresponding link in the information viewing window (Fig. 18.11).

Outlook and PowerPoint

Microsoft PowerPoint is a versatile presentation preparation tool. After creating a presentation, the user can demonstrate it both on a local computer and make a presentation on the network for the entire working group. The PowerPoint presentation is in HTML format and therefore only Internet Explorer 4.0 is required to view the PowerPoint presentation. Thus, the presentation can be carried out both company-wide and between members of a small group located in different locations. The number of participants is not limited, but if the presentation is attended by more than 16 listeners, you must use a special server application Microsoft NetShow Server to conduct it.

The problem with any meeting is planning. Of course, for the conference, in addition to the speaker's desire, the consent of the participants is also required. In the case of a regular conference, the participation of all the actors is confirmed by the fact that they all gather together and at approximately the same time in the room designated for the conference. The presenter can schedule a PowerPoint e-meeting like any other meeting using Outlook.

Rice. 18.12. Presentation and dialog Scheduling a broadcast presentation

Example 18.14. Scheduling a Broadcast PowerPoint Presentation

> Slide Show> Live Streaming> Set Up & Schedule ...

Description: = "Microsoft Outlook 2002 in original"(fig. 18.12)

Parameters ... Broadcast settings (Fig. 18.13)

Display mode Resizable

Assign ...

Enter or select a name:< participants in the presentation

Mandatory

send

(A dialog box will appear notifying that the broadcast is scheduled)

Rice. 18.13. Dialog window Broadcast parameters

Comment

Switches Sound only(Audio only) and Video and sound It makes sense to install (Video and Audio) if the presenter's computer is equipped with a microphone and a video camera, and the participants' computers are equipped with equipment for playing audio and video. In our example, we do not assume this, so the checkbox is checked No(None).

The automatically filled-in meeting form (Fig. 18.14) is identical to those discussed earlier, For more information, see Chapter 2, Calendar, and Chapter 10, Teamwork in Outlook.

Comment

The only prerequisite for direct broadcasting of a presentation to a wide audience is the presence of a computer connection to the network (global or local). Additional features may not be used if technical conditions do not allow it.

After agreeing on the time and composition of the participants, you can proceed directly to the demonstration itself.

Rice. 18.14. Assembly form

Example 18.15. Live broadcast of the presentation

> Slide show> Live broadcast> Start broadcast ...

When holding a scheduled conference, the presenter plans to broadcast it using the meeting scheduling interface in Outlook 2002. At the specified time, a meeting reminder window will appear on the participants' computers, where the participant will see a button, after clicking on which the introduction page of the presentation will be loaded (Fig. 18.15 ). The presenter controls the slide change. Participants' computer screens display the slides in the same way as in a normal slide show.

Rice. 18.15. The main page of the live broadcast of the presentation

During the presentation, attendees can have private discussions, pose questions to the moderator, and receive responses via email via Outlook.

Outlook and Access

Microsoft Access is a universal database management system, and Outlook is a universal information management system. Based on these definitions, it is natural to assume that these applications have certain means for exchanging information with each other. But besides the exchange of information, Outlook, like Word or Excel, is capable of creating messages using Microsoft Access tools. Only in this case, these tools are not in the field of formatting or editing, but in the field of providing data for sending and publishing them.

In this section, we will walk you through an example of importing information from an Outlook address book into an Access database, and also creating a message containing the information you just imported.

Information exchange

First of all open Access and create a database. After that, our goal will be to create a table containing data from the Outlook address book.

Example 18.16. Import data from Outlook to Access

> File> External Data> Import ...

Outlook File Type (The Import from Exchange / Outlook Wizard will automatically start)

> Address Books> Outlook Contacts Address Book

In the new table

(At this step, it is proposed to determine the parameters of the imported data, to find out whether it is necessary to import them at all)

He import

Import to table: = Contacts

Rice. 18.16. Microsoft Access table with imported data

After import, as expected, a new table will appear in Access Contacts, containing information from the Outlook address book. The import result is shown in Fig. 18.16.

Working with Access Data Page

Consider the following example. Let's say that one of the project participants has created a database, the information of which is interesting, and maybe needed by other team members. There are several solutions for this problem, but we will focus on the option of sending a message containing an Access Data Page. In fact, the message contains just an HTML page with an ActiveX object that connects to the database and displays the data.

Example 18.17. Create message with Access Data Page

> Actions> New Message Using…> Microsoft Office> Microsoft Access Data Page

(Access opens with the New Data Access Page wizard)

Constructor

Data source selection: =< Database>

After the performed procedures, a page with a data grid will open. So, first of all, you need to place the information fields that will be on the page. To do this, drag the required fields onto the table grid and replace its name, for example, Contacts. Then enter the name of the recipients of the message and click the button Send a copy.

Before sending a message, the user can see how it will be displayed to the recipient. To do this, select the command> File> Web Page Preview. A web browser opens with a loaded page, which will be displayed in the same way to the recipient of the message.

Rice. 18.23. Web page with data from Access

Using the buttons Back and Next, you can navigate the table data Contacts. Also, if you specify the appropriate access parameters, you can edit the table (add or delete records), organize data filtering, etc. But this is beyond the scope of this book.

Summary

So, in this chapter, we looked at how Office and Outlook can work together. Truly, when Outlook works with the tools provided by Word, Excel, PowerPoint, and Access, you can create rich messages and organize more comfortable sharing and access to information.

• Word. Formatting the message. Using Word as your default editor. Sending a document along the route.
• Excel. Create message with table and chart. Placing documents in public folders on the Exchange server.
• PowerPoint. Organize an online meeting to showcase your presentation.
• Access. Import data from Outlook into Access. Create a message that contains an Access Data Page.

Word, Outlook and Internet Explorer are probably the most commonly used programs on a personal computer. Almost all PC owners are able to work with these applications, but most of them are familiar with only a small fraction of their capabilities. Consequently, the losses from ineffective use of these programs are very high. Hopefully the tips below will give you tips on how to get up and running faster and save you valuable time.

Word

Side by side document comparison

You have probably encountered the problem of how difficult it is to compare two versions of the same document. In Word 2003, the ability to compare documents in side by side mode has appeared, which allows you to call two documents at once and scroll them simultaneously and separately, comparing certain sections of two documents.

Open two documents and choose the command Window => Compare Side By Side With ..... If you have only two documents open, they will be compared, otherwise the program will ask you to specify which documents need to be compared.

A floating panel appears to manage documents (Fig. 1). Pressing the left button changes the scrolling mode (turns on / off the simultaneous scrolling mode), and the right button allows you to return the window position to the position from which you started comparing documents.

Web pages with a minimum of redundant tags

When you save Web pages or send e-mails in HTML format using Microsoft Word, additional tags are added to the document, allowing you to use all the functionality of Word for further work on the document.

In order to reduce the size of the Web page and e-mail messages in HTML format, you can save data in a special filtered format (filtered HTML) - in this case, unnecessary tags will be removed.

If you open a Web page saved in filtered HTML mode in Word, some of the functionality for further editing this document may be lost. For example, bulleted lists and numbered lists will appear, but you will no longer be able to modify them with Word.

Therefore, you should use filtered HTML mode only at the final stage - before direct translation into HTML.

All elements of a website in one file

Word 2003 introduces the ability to save all elements of a Web site, including text and graphics, in a single file. In order to use this feature, it is enough to execute the command Save as and select item Single file Web page... In this mode, encapsulation is performed, which allows, for example, to send the entire Web site as an e-mail message or an e-mail attachment. This format is supported in Internet Explorer 4.0 and later.

How to add a title to a Web page

The title appears in the title bar at the top of the window, as well as, for example, in the browsing history of a Web browser. If someone saves a link to your Web page, the title title appears in the person "s favorites list. To set a title, you must issue the command File => Save as Web Page, click on the label Change Title(fig. 2) and type in the desired name.

How to optimize web pages for a specific browser

By saving a Word document as a Web page, you can optimize it for a specific browser.

Run the command Tools => Options and in the panel of the same name, select the tab General, and in it - the panel Web Option s. In the tab Browsers in field People who view this Web page will be using select the required browser version (fig. 3). In the list Options allow (or deny) the listed features.

Reusing the Format Painter function

When you click on the icon Format Painter(copy format), the text formatting of the area where the cursor is located is copied. Now, if you select any area of ​​text, Format Painter applies the above formatting to it.

Many users are familiar with this function, but most do not know that if you double-click the Format Painter icon, you can reapply the copied format as many times as necessary and this function will remain active until the Esc key is pressed.

Save All / Close All

If you hold Shift key when selecting an item File menu in the Word program, the composition of the menu changes. Instead of Close function appears Close All, and instead of Save — Save all(fig. 4).

Line without bullet

When creating a bulleted list in Word, a situation often arises when you need to leave the next item without a bullet. To do this, press the key combination Shift + Enter... On the next line when you press Enter, the new line will again be with a bullet.

For example:

How to use the formatting you want when pasting

In the case of copying text from any document into Word, the latter automatically transfers the text with the formatting that took place in the document from which the copy is made. In order for the pasted text to have the same formatting as the Word document, use the command Edit => Paste Special => Unformatted Text(fig. 5).

Formatting with a smart tag

After pasting text into any Office application, clicking a smart tag opens a menu with a choice of formatting types, including the following options:

• Keep Source Formatting - this will preserve the format that the text in the original document had;
• Match Destination Formatting - the formatting of the inserted data will take place according to the principle of the formatting of the document into which the insertion is carried out (Fig. 6).

How to add a description to your Word document

Document Properties are information that Microsoft Word allows you to add to each document. Few people use this useful feature, but meanwhile, with its help, you can add a number of descriptions and instructions, which will be especially valuable if you work in a team. To add a description of a Word document, you need to call the Document Properties panel by the command File => Properties(fig. 7).

Quick access to selected documents

Do you want to have quick access to a range of Word documents? It couldn't be easier! Run the command View => Toolbars => Customize, select the tab Commands, chapter Built-in menus and drag the icon Work on the panel as shown in fig. eight.

Now, in order to add the current document to the Work menu, just open it and click on the item Add to work menu(fig. 9) - the current document will be added to the menu. You can delete it using the keyboard shortcut Ctrl + Alt + Minus.

Insert line into document

Do you want to separate a paragraph with a line? Press the hyphen key three times and the Enter and you will get a thin line. Press the underscore key and the Enter- get a bold line. And when you press three times the equal sign keys and the Enter you get a double line.

Calculator in Word

Did you know you can add a calculator to the Word pane?

Run the command View => Toolbars => Customize => Commands tab and place the Tools Calculate icon on the toolbar (Figure 10). Now, by typing some expression, highlighting it and clicking on the Tools Calculate button, you can get the result (Fig. 11).

To replace the expression with the result of the count, press the keyboard shortcut Ctrl + V.

Continuous zoom

Press the key to change the scale of the document. Ctrl and use the mouse wheel to change the scale until the desired resolution is obtained. This is much more convenient than accessing the menu.

Outlook

Control spam filter in Outlook 2003

The mail client Microsoft Outlook 2003 has a built-in spam filter, which is designed to filter out unwanted messages and place them in a separate folder.

However, this folder must be checked and monitored from time to time so that a useful email is not recognized as spam.

The filter in Microsoft Outlook 2003 analyzes the formal attributes of a message and its body. The filter uses black and white lists to parse the formal attributes of a message.

If you received an unwanted e-mail message, right-click on it and in the drop-down menu (Fig. 12) run the command Junk Email => Add sender to the Blocked Senders List... E-mail messages from subscribers that are placed in Blocked Senders list, will be blocked and sent to the folder Junk E-Mail folder.

If, on the contrary, the program mistakenly places the letter you need in the folder Junk E-Mail folder, add this user to the whitelist by command Add sender to the Safe Senders List- henceforth it will not be blocked.

Message thread in Outlook 2003

Outlook 2003 ability to sort mail by discussion ( View => Arrange By => Conversation) allows you to quickly view messages and quickly delete junk mail. Organize your mail browsing in the same way (Figure 13), and you will see that many topics have a thread of earlier emails. This method of displaying correspondence makes it easier to find and delete obsolete letters.

Save documents wherever you like

When you receive a message with an attachment and you want to save it to disk, by default Outlook will prompt you to save the attachment in a folder My Documents... If you save attachment files to a different location, then you need to change the destination each time. Adding a shortcut to a folder will help speed up the procedure. My Documents sending to the desired folder.

Internet Explorer

How to restrict children's access to unwanted Internet resources

If you are faced with the task of restricting children's access to unwanted Web resources, then using Internet Explorer 6 you can set an access password to such resources, as well as write a list of allowed and prohibited sites. In order to put a ban on uncontrolled access to Internet resources in

Internet Explorer, run the command Tools => Internet Options and select the tab Content(fig. 14).

Activate the button Turn on and in the panel that appears, select the tab General... In this tab, use the function Create a password... From now on, a password will be required to access prohibited resources.

Change font size in IE

Simple but very useful advice. Not all Web pages offer optimal font sizes, and it can be tedious to go into font settings every time. Press the key Ctrl, and by moving the mouse wheel you can increase or decrease the font size of the displayed text.

Open link in a new window

What if you don't want to leave the current page, but at the same time want to see the link on it? When you click on Url hold the key Shift- in this case, the page will open in a new window.

How to change home page

Some programs set their page as their home page. To change the page from which to start browsing, you need to run the command Tools => Internet Options and in the Home page section (Fig. 15) specify the desired address or select the item With empty.

Speed ​​dial URL

If the URL that you need to enter in the address bar looks like www.name.com, then you just need to type this name and press the key combination Ctrl + Enter.

Move quickly between web pages

It is convenient to quickly move between multiple web pages by holding down the key Shift and a mouse wheel.