Microsoft office 2010 introductory shelly cashman pdf free download.Download PDF Microsoft Office 2010 Introductory (Shelly Cashman)

This article shows how to create a database using Microsoft Access. However, you can encrypt a database with a password opening a database in exclusive mode and then 3. Microsoft Access is a relational database application. Database, and a hands-on introduction to tables, queries, forms, and reports. Newer versions of Access do have a Calculated field type for the table.

Post BUS Project Management and Planning Introductory Video. Microsoft Access is a database management system from Microsoft Important Terms and Basic Objects; MS Access Datatypes Let’s add some data in your table opening the Access database you have created earlier. An ACCDE file is a Microsoft Access Execute Only Database file used It replaces the MDE format which secures an MDB file used older versions of MS Access. If your ACCDE file isn’t opening like you think it should, Here you will find Microsoft Access Database examples and sample files available to download.

Free Trial Version available to download. An indispensable MS Access add-in for developers who use queries as the core of their applications.

Example of opening Microsoft Word documents from an Access Database. introduction to structured programming book and disk,microsoft project professional 14 0 microsoft office access step step,microsoft dynamics ax ,microsoft excel comprehensive concepts and techniques,microsurgery.

If loading fails, click here to try again. It is passed as a hidden argument to all function calls O b. Select all correct answers Pointers are addresses of locations in RAM. Which one is not a valid value for DataRowState? Source: When local variables name is same as members name, we can access member using this pointer.

人気ブログランキング 話題のタグを見る. 投稿内容 タグ ブログタイトル ウェブ全体. このブログの更新通知を受け取る場合は ここをクリック. Rosalva Mariotti cevbppcd. jp ブログトップ. Rosalva Mariotti by cevbppcd プロフィールを見る. A complete toolset Microsoft Visual Studio that simplifies application In this course, author Mark Long demonstrates and explains many of the new features and functionalities of Visual Studio Introduction Visual Basic Power Packs Programming with Visual Studio An Introduction to Programming Using Visual Basic , Ninth Edition consistently praised both students and instructors is designed for readers with no prior computer programming experience.

Now updated for Visual Basic , Schneider focuses on teaching problem-solving skills and sustainable programming skills. A broad range of Embedding the Windows Media Player Control in a Visual Basic Using the Player Control with Microsoft Unique book-and-DVD package for novice Visual Basic programmers Basic, you soon will with this thorough introduction to Visual Basic programming.

Introduce Windows Presentation Foundation WPF ; Compare declarative and procedural coding Debbie Macomber, simply visual basic is well grounded in the use of good introductory courses in visual basic programming offered in departments of build information visual studio window settings and any miscellaneous of tigers excel vba tutorials in this play simply visual basic with dvd The easiest and recommended way to install Visual Studio Code on Ubuntu machines is to without sudo Just Store it on the Home.

H Visual Basic can interface with code written in C, for efficiency. I just got a Visual Studio installer DVD from my friend, but when I launch Getting Started with Measurement Studio: Support for Visual Studio media that do not execute programming instructions if National Instruments receives Introduction to Measurement Studio designed for developers using Microsoft Visual NI Device Drivers DVD included with Measurement Studio.

Chapter 1 provides an overview of programming with Visual Basic The chapter defines a computer program, describes the role of a developer in creating computer programs, and discusses event-driven programs that have a graphical user interface GUI. Studio Express Unlimited 4th Edition Zak Diane at Go! with Micro.. at Zhongguo Gao D.. at Survival Chine..

at XML ATOM Powered by Excite Blog 会社概要.

Microsoft office 2010 introductory shelly cashman pdf free download

Он знал, что это трюк. Корпорация «Нуматек» сделала очень крупную ставку на новый алгоритм Танкадо, и теперь кто-то из конкурентов пытается выведать ее величину.

– У вас есть ключ? – сказал Нуматака с деланным интересом. – Да. Меня зовут Северная Дакота.

Microsoft Access Introductory Edition | dengurumushiのブログ – 楽天ブログ – Free PDF Microsoft Office 2013: Introductory (Shelly Cashman Series), by Misty E. Vermaat

The name and drive letter of your USB flash drive probably will be different. Why is the folder icon displayed differently on my computer? Figure 31 Windows might be configured to display contents differently on your computer. Recall that a folder is a specific named location on a storage medium that contains related files. Most users rely on folder windows for finding, viewing, and managing information on their computer.

Folder windows have common design elements, including the following Figure The arrows on the Address bar allow you to visit different locations on the computer.

Other buttons allow you to specify the size of the window. You can type a term in the search box for a list of files, folders, shortcuts, and elements containing that term within the location you are searching. A shortcut is an icon on the desktop that provides a user with immediate access to a program or file. By default, this list contains only links to your Desktop, Downloads, and Recent Places. A library helps you manage multiple folders and files stored in various locations on a computer.

It does not store the files and folders; rather, it displays links to them so that you can access them quickly. For example, you can save pictures from a digital camera in any folder on any storage location on a computer. Normally, this would make organizing the different folders difficult; however, if you add the folders to a library, you can access all the pictures from one location regardless of where they are stored.

To Create a Folder within a Folder With the class folder created, you can create folders that will store the files you create using each Office program. The following steps create a Word folder in the CIS folder or the folder identifying your class.

You might want to expand a drive in the navigation pane to view its contents, scroll through its contents, and collapse it when you are finished viewing its contents. When a folder is expanded, it lists all the folders it contains. By contrast, a collapsed folder does not list the folders it contains. The following steps expand, scroll through, and then collapse the folder identifying your class CIS , in this case. Why are the subject folders indented below the CIS folder in the navigation pane?

Why did a scroll bar appear in the navigation pane? When all contents cannot fit in a window or pane, a scroll bar appears. As described earlier, you can view areas currently not visible by 1 clicking the scroll arrows, 2 clicking above or below the scroll bar, and 3 dragging the scroll box. Point in navigation pane to display arrows, click white arrow to expand or click black arrow to collapse 2.

Figure 36 Copyright Cengage Learning, Inc. To Switch from One Program to Another The next step is to save the Word file containing the headline you typed earlier. Word, however, currently is not the active window. You can use the program button on the taskbar and live preview to switch to Word and then save the document in the Word document window. If Windows Aero is active on your computer, Windows displays a live preview window whenever you move your mouse on a button or click a button on the taskbar.

If Aero is not supported or enabled on your computer, you will see a window title instead of a live preview. The steps below use the Word program; however, the steps are the same for any active Office program currently displayed as a program button on the taskbar.

The following steps switch to the Word window. If Aero is enabled on your computer, click the desired live preview. If Aero is not supported or not enabled, click the window title. To Save a File in a Folder Now that you have created the folders for storing files, you can save the Word document.

Why does a file name already appear in the File name text box? Word automatically navigation pane your list suggests a file name may differ the first time you save a document. The file name normally consists of the first few words contained in the document.

Because the suggested file name is selected, you do not need to delete it; as soon as you begin typing, the new file name replaces the selected text. Do not press the ENTER key after typing the file name because you do not want to close the dialog box at this time Figure What characters can I use in a file name? Figure 40 Copyright Cengage Learning, Inc.

What if I do not want to save in a folder? Although storing files in folders is an effective technique for organizing files, some users prefer not to store files in folders. If you prefer not to save this file in a folder, skip all instructions in Step 3c and proceed to Step 4.

While an Office program is saving a file, it briefly displays a message on the status bar indicating the amount of the file saved. In addition, the USB flash drive may have a light that flashes during the save process. Figure 42 Other Ways 1. Click File on Ribbon, click Save, type file name, navigate to desired save location, click Save button 2.

While saving the Koala Exhibit file, for example, Steps 3a — 3c in the previous set of steps navigated to the Word folder located in the CIS folder. When performing certain functions in Windows programs, such as saving a file, opening a file, or inserting a picture in an existing document, you most likely will have to navigate to the location where you want to save the file or to the folder containing the file you want to open or insert.

Most dialog boxes in Windows programs requiring navigation follow a similar procedure; that is, the way you navigate to a folder in one dialog box, such as the Save As dialog box, is similar to how you might navigate in another dialog box, such as the Open dialog box.

If you chose to navigate to a specific location in a dialog box, you would follow the instructions in Steps 3a — 3c on pages OFF 28 and OFF To Minimize and Restore a Window Before continuing, you can verify that the Word file was saved properly. To do this, you will minimize the Word window and then open the USB flash drive window so that you can verify the file is stored on the USB flash drive. In the following example, Word is used to illustrate minimizing and restoring windows; however, you would follow the same steps regardless of the Office program you are using.

The following steps minimize the Word window, verify that the file is saved, and then restore the minimized window. Is the minimized window still available?

The minimized window, Word in this case, remains available but no longer is the active window. It is minimized as a program button on the taskbar. The button changes to reflect the status of the folder window in this case, the USB flash drive window. A selected button indicates that the folder window is active on the screen.

When the button is not selected, the window is open but not active. Right-click title bar, click Minimize on shortcut menu, click taskbar button in taskbar button area 2. When you increase the screen resolution, Windows displays more information on the screen, but the information decreases in size.

The reverse also is true: as you decrease the screen resolution, Windows displays less information on the screen, but the information increases in size. Changing the screen resolution affects how the Ribbon appears in Office programs. All of the same commands are available regardless of screen resolution. Word, however, makes changes to the groups and the buttons within the groups to accommodate the various screen resolutions.

The result is that certain commands may need to be accessed differently depending on the resolution chosen. A command that is visible on the Ribbon and available by clicking a button at one resolution may not be visible and may need to be accessed using its Dialog Box Launcher at a different resolution.

Comparing the two Ribbons in Figure 45, notice the changes in content and layout of the groups and galleries. In some cases, the content of a group is the same in each resolution, but the layout of the group differs.

For example, the same gallery and buttons appear in the Styles groups in the two resolutions, but the layouts differ. In other cases, the content and layout are the same across the resolution, but the level of detail differs with the resolution. At the lower resolution, only the buttons appear. Keep in mind that many computer labs prevent users from changing the screen resolution; in that case, read the following steps for illustration purposes.

What is a slider? A slider is an object that allows users to choose from multiple predetermined options. In most cases, these options represent some type of numeric value.

In most cases, one end of the slider usually the left or bottom represents the lowest of available values, and the opposite end usually the right or top represents the highest available value. Why does a message display stating that the image quality can be improved? Figure 49 Some computer monitors are designed to display contents better at a certain screen resolution, sometimes referred to as an optimal resolution.

To Quit an Office Program with One Document Open When you quit an Office program, such as Word, if you have made changes to a file since the last time the file was saved, the Office program displays a dialog box asking if you want save the changes you made to the file before it closes the program window.

If no changes have been made to an open document since the last time the file was saved, the Office program will close the window without displaying a dialog box. The following steps quit an Office program.

In the following example, Word is used to illustrate quitting an Office program; however, you would follow the same steps regardless of the Office program you were using. What is the Backstage view? Figure 50 You would click the Close button for each open document. As an alternative, you could click File on the Ribbon to open the Backstage view and then click Exit in the Backstage view to close all open documents and quit the Office program.

The Backstage view contains a set of commands that enable you to manage documents and data about the documents. The Backstage view is discussed in more depth later in this chapter. To resume at a later time, continue to follow the steps from this location forward. Additional Microsoft Office Programs The previous section used Word to illustrate common features of Office and some basic elements unique to Word.

The following sections present elements unique to PowerPoint, Excel, and Access, as well as illustrate additional common features of Office. In the following pages, you will learn how to do the following: 1. Start an Office program PowerPoint using the search box. Create two small documents in the same Office program PowerPoint. Close one of the documents. Reopen the document just closed. Create a document in a different Office program Excel.

Save the document with a new file name. Create a file in a different Office program Access. Close the file and then open the file. PowerPoint PowerPoint is a complete presentation program that allows you to produce professional-looking presentations Figure A PowerPoint presentation also is called a slide show. PowerPoint contains several features to simplify creating a slide show. To make presentations more impressive, you can add diagrams, tables, pictures, video, sound, and animation effects.

You also can import outlines from Microsoft Word or other word processing programs, including single-level and multilevel lists. Then, customize and add effects to the diagrams, and arrange these objects by sizing, scaling, and rotating them.

The Microsoft Clip Organizer, included with Office programs, contains hundreds of media files, including pictures, sounds, and movies. You can publish your slide show to the Internet or to an intranet. Ask them to review the slides and then insert comments that offer suggestions to enhance the presentation. You may need to ask your instructor how to start programs for your computer. No, just enough of it for the program name to appear on the Start menu.

The PowerPoint window consists of a variety of components to make your work more efficient and documents more professional: the window, Ribbon, Mini toolbar, shortcut menus, and Quick Access Toolbar. Many of these components are common to other Office programs and have been discussed earlier in this chapter. Other components, discussed in the following paragraphs and later in subsequent chapters, are unique to PowerPoint. The basic unit of a PowerPoint presentation is a slide.

A slide may contain text and objects, such as graphics, tables, charts, and drawings. Layouts are used to position this content on the slide. When you create a new presentation, the default Title Slide layout appears Figure The purpose of this layout is to introduce the presentation to the audience. PowerPoint includes eight other built-in standard layouts.

The default slide layouts are set up in landscape orientation, where the slide width is greater than its height. In landscape orientation, the slide size is preset to 10 inches wide and 7. To change the orientation to portrait, click the Slide Orientation button Design tab Page Setup group and then click Portrait. You can use both landscape and portrait orientation in the same slide show.

Slide pane Slides tab scroll box mouse pointer text typed in title and subtitle placeholders scroll bar scroll arrow splitter bar notes pane total number of slides Previous Slide button Normal view is default view Document theme identifier Next Slide button status bar Figure 54 Placeholders Placeholders are boxes with dotted or hatch-marked borders that are displayed when you create a new slide.

All layouts except the Blank slide layout contain placeholders. Depending on the particular slide layout selected, title and subtitle placeholders are displayed for the slide title and subtitle; a content text placeholder is displayed for text, art, or a table, chart, picture, graphic, or movie.

The title slide in Figure 53 has two text placeholders for the main heading, or title, of a new slide and the subtitle. To Enter Content in a Title Slide With the exception of a blank slide and a slide with a picture and caption, PowerPoint assumes every new slide has a title.

To make creating a presentation easier, any text you type after a new slide appears becomes title text in the title text placeholder. As you begin typing text in the title text placeholder, the title text also is displayed in the Slide 1 thumbnail in the Slides tab.

The presentation title for this presentation is Xanada Investments. The following steps enter a presentation title on the title slide. What are the white squares and circles that appear around the title text placeholder as I type the presentation title? Sizing handles also can be found around other placeholders and objects within a presentation.

Figure 56 Copyright Cengage Learning, Inc. Do not press the ENTER key after typing the file name because you do not want to close the dialog box at this time. For specific instructions, perform the tasks in Steps 3a through 3g. To Create a New Office Document from the Backstage View As discussed earlier, the Backstage view contains a set of commands that enable you to manage documents and data about the documents.

From the Backstage view in PowerPoint, for example, you can create, open, print, and save presentations. You also can share documents, manage versions, set permissions, and modify document properties. In other Office programs, the Backstage view may contain features specific to those programs. The steps on the following pages create a file, a blank presentation in this case, from the Backstage view.

What is the purpose of the File tab? Can I create documents through the Backstage view in other Office programs? New gallery Create button New tab Yes. If the Office program has a New tab in the Backstage view, the New gallery displays various options for creating a new file.

Figure 58 Copyright Cengage Learning, Inc. Save button 1 Click the title text placeholder shown in Figure 59 to select it. You also may want to close a file when you are finished working with it so that you can begin a new file.

The following steps close the current active Office file, that is, the Koala Exhibit Gala presentation, without quitting the active program PowerPoint in this case. Close command What if the Office program displays a dialog box about saving? Figure 61 Copyright Cengage Learning, Inc. You may have more changes to make such as adding more content or correcting errors.

The Backstage view allows you to access recent files easily. The following steps reopen the Koala Exhibit Gala file just closed. Yes, as long as the file name appears in the list of recent files in the Recent gallery. Exit command Figure 62 Other Ways 1. Click Start button, point to program name, click file name on submenu 2. Thus, you should quit this Office program.

The following steps quit PowerPoint. Inside the workbook are sheets, each of which is called a worksheet. In other words, a workbook is a collection of worksheets.

Worksheets allow users to enter, calculate, manipulate, and analyze data such as numbers and text. The terms worksheet and spreadsheet are interchangeable. For example, once a user enters data into a worksheet, an Excel table can sort the data, search for specific data, and select data that satisfies defined criteria.

Excel Web support also provides access to real-time data, such as stock quotes, using Web queries. The following steps use Windows Explorer to create a blank Excel document. Another way start an Office program is to open an existing file from Windows Explorer, which causes the program in which the file was created to start and then open the selected file.

The following steps, which assume Windows 7 is running, use Windows Explorer to start the Excel Office program based on a typical installation. Yes, you can use any method of starting an Office program to start Excel. The Formulas and Data tabs are specific to Excel. The Formulas tab allows you to work with Excel formulas, and the Data tab allows you to work with data processing features such as importing and sorting data.

BTW The Worksheet The worksheet is organized into a rectangular grid containing vertical columns and horizontal rows. A column letter above the grid, also called the column heading, identifies each column. A row number on the left side of the grid, also called the row heading, identifies each row. The intersection of each column and row is a cell. A cell is the basic unit of a worksheet into which you enter data. Each worksheet in a workbook has 16, columns and 1,, rows for a total of 17,,, cells.

Only a small fraction of the active worksheet appears on the screen at one time. A cell is referred to by its unique address, or cell reference, which is the coordinates of the intersection of a column and a row. To identify a cell, specify the column letter first, followed by the row number.

For example, cell reference E2 refers to the cell located at the intersection of column E and row 2 Figure One cell on the worksheet, designated the active cell, is the one into which you can enter data. The active cell in Figure 68 is A1. The active cell is identified in three ways. First, a heavy border surrounds the cell; second, the active cell reference shows immediately above column A in the Name box; and third, the column heading A and row heading 1 are highlighted so it is easy to see which cell is active Figure The horizontal and vertical lines on the worksheet itself are called gridlines.

Gridlines make it easier to see and identify each cell in the worksheet. If desired, you can turn the gridlines off so that they do not show on the worksheet, but it is recommended that you leave them on for now.

The mouse pointer in Figure 68 has the shape of a block plus sign. The mouse pointer appears as a block plus sign whenever it is located in a cell on the worksheet. Another common shape of the mouse pointer is the block arrow. The mouse pointer turns into the block arrow when you move it outside the worksheet or when you drag cell contents between rows or columns. The other mouse pointer shapes are described when they appear on the screen. The Worksheet Size and Window The 16, columns and 1,, rows in Excel make for a huge worksheet that — if you could imagine — takes up the entire side of a building to display in its entirety.

Your computer screen, by comparison, is a small window that allows you to view only a minute area of the worksheet at one time. While you cannot see the entire worksheet, you can move the window over the worksheet to view any part of it.

BTW The Excel window consists of a variety of components to make your work more efficient and worksheets more professional. These include the document window, Ribbon, Mini toolbar and shortcut menus, Quick Access Toolbar, and the Backstage view.

Some of these components are common to other Microsoft Office programs; others are unique to Excel. Excel opens a new workbook with three worksheets. If necessary, you can add additional worksheets as long as your computer has enough memory to accommodate them. Each worksheet has a sheet name that appears on a sheet tab at the bottom of the workbook.

For example, Sheet1 is the name of the active worksheet displayed in the Brain Busters workbook. If you click the sheet tab labeled Sheet2, Excel displays the Sheet2 worksheet. Customizing the Ribbon In addition to customizing the Quick Access Toolbar, you can add items to and remove items from the Ribbon.

To customize the Ribbon, click File on the Ribbon to open the Backstage view, click Options in the Backstage view, and then click Customize Ribbon in the left pane of the Options dialog box. More information about customizing the Ribbon is presented in a later chapter.

As you type, Excel displays the entry in the formula bar. You can make the formula bar larger by dragging the sizing handle at the bottom of the formula bar or clicking the expand button to the right of the formula bar.

Excel also displays the active cell reference in the Name box on the left side of the formula bar. The easiest way to select a cell make it active is to use the mouse to move the block plus sign mouse pointer to the cell and then click. An alternative method is to use the arrow keys that are located just to the right of the typewriter keys on the keyboard. An arrow key selects the cell adjacent to the active cell in the direction of the arrow on the key.

In Excel, any set of characters containing a letter, hyphen as in a telephone number , or space is considered text. Text is used to place titles, such as worksheet titles, column titles, and row titles, on the worksheet. The following steps enter the worksheet title in cell A1.

Cancel box Why did the appearance of the formula bar change? Excel displays the title in the formula bar and in cell A1. When you begin typing a cell entry, Excel displays two additional boxes in the formula bar: the Cancel box and the Enter box.

Clicking the Enter box completes an entry. Clicking the Cancel box cancels an entry. To complete entry, click any cell other than active cell 2. You have made modifications to the file spreadsheet since you created it. Thus, you should save again. Similarly, you should continue saving files frequently so that you do not lose your changes since the time you last saved the file.

You can use the same file name, such as Brain Busters, to save the changes made to the document. The following step saves a file again. Office programs, including Excel, overwrite the document using the setting specified the first time you saved the document. Figure 73 Other Ways 1. For example, you might start a homework assignment with a data file and then save it with a final file name for submitting to your instructor, saving it to a location designated by your instructor.

The following steps save a file with a different file name. For specific instructions, perform the tasks in steps 4a through 4g. The following steps quit Excel. Access The term database describes a collection of data organized in a manner that allows access, retrieval, and use of that data. Microsoft Access , usually referred to as simply Access, is a database management system.

A database management system is software that allows you to use a computer to create a database; add, change, and delete data in the database; create queries that allow you to ask questions concerning the data in the database; and create forms and reports using the data in the database. To Start a Program The following steps, which assume Windows 7 is running, start the Access program based on a typical installation.

Do I have to start Access using these steps? You can use any previously discussed method of starting an Office program to start Access. In Figure 74, the Access window contains no open objects. Figure 75 shows a work area with multiple objects open. Object tabs for the open objects appear at the top of the work area.

You select an open object by clicking its tab. In the figure, the Suppliers Split Form is the selected object. To the left of the work area is the Navigation Pane, which contains a list of all the objects in the database.

You use this pane to open an object. You also can customize the way objects are displayed in the Navigation Pane. Because the Navigation Pane can take up space in the window, you may not have as much open space for working as you would with Word or Excel. Many of the formatting options are reserved for the tool tabs that appear when you are working with forms and reports. When working in Access, you will add data to an Access database. As you add data to a database, Access automatically saves your changes rather than waiting until you manually save the database or quit Access.

Recall that in Word and Excel, you entered the data first and then saved it. Because Access automatically saves the database as you add and change data, you do not have to always click the Save button. In fact, the Save button in Access is used for saving the objects including tables, queries, forms, reports, and other database objects a database contains. You can use either the Blank Database option or a template to create a new database. If you already know the organization of your database, you would use the Blank Database option.

If not, you can use a template. Templates can guide you by suggesting some commonly used database organizations. Do not press the ENTER key after typing the file name because you do not want to create the database at this time Figure Unlike other Office programs, you first must save a database before adding any data.

For this reason, the Backstage view opens automatically when you start Access. Access folder selected file name displayed in File name text box OK button Microsoft Access database formats change with some new versions of Microsoft Access.

The most recent format is the Microsoft Access Databases format, which was released with Access Figure 77 Copyright Cengage Learning, Inc. The name of the database appears on the title bar. Datasheet View button is selected when you first install Access Windows 7 taskbar displays Access program button, indicating Access is running Figure 79 To Close an Office File Assume you need to close the Access database and return to it later.

The following step closes an Office file. If necessary, click the Enable Content button Figure Why is Access still on the screen? When you close a database, the program remains open. To Open an Existing Office File Assume you wish to continue working on an existing file, that is, a file you previously saved.

Earlier in this chapter, you learned how to open a recently used file through the Backstage view. The following steps open a database, specifically the Charmed Excursions database, from the USB flash drive. What if I did not save my file in a folder? If you did not save your file in a folder, the file you wish to open should be displayed in the Open dialog box before navigating to any folders.

Click File on the Ribbon, click Recent in Backstage view, double-click file 2. The following step quits Access. Other Office Programs In addition to the Office programs discussed thus far, three other programs are useful when collaborating and communicating with others: Outlook, Publisher, and OneNote. Outlook Outlook is a powerful communications and scheduling program that helps you communicate with others, keep track of contacts, and organize your calendar.

Personal information manager PIM programs such as Outlook provide a way for individuals and workgroups to organize, find, view, and share information easily. Outlook allows you to send and receive electronic mail e-mail and permits you to engage in real-time messaging with family, friends, or coworkers using instant messaging. Outlook also provides a means to organize contacts. Users can track e-mail messages, meetings, and notes related to a particular contact.

Contact information readily is available from the Outlook Calendar, Mail, Contacts, and Task components by accessing the Find a Contact feature. Electronic mail e-mail is the transmission of messages and files over a computer network. E-mail has become an important means of exchanging information and files between business associates, classmates and instructors, friends, and family. Businesses find that using e-mail to send documents electronically saves both time and money.

Parents with students away at college or relatives who live across the country find that communicating by e-mail is an inexpensive and easy way to stay in touch with their family members.

Exchanging e-mail messages is one of the more widely used features of the Internet. The Outlook Window Figure 82 shows an Outlook window, which is divided into six panes: the Favorites folder pane, Mail folder pane, and Navigation Pane on the left side of the window, the Inbox message pane to the left of center, the Reading Pane to the right of center, and the People Pane just below the Reading Pane. When an e-mail message is open in Outlook, it is displayed in a Message window Figure When you open a message, the Message window Ribbon displays the Message tab, which contains the more frequently used commands.

DTP software provides additional tools beyond those typically found in word processing programs, including design templates, graphic manipulation tools, color schemes or libraries, advanced layout and printing tools, and Web components.

For large jobs, businesses use DTP software to design publications that are camera ready, which means the files are suitable for outside commercial printing. OFF 60 Office and Windows 7 Chapter Essential Concepts and Skills BTW Publisher is used by people who regularly produce high-quality color publications, such as newsletters, brochures, flyers, logos, signs, catalogs, cards, and business forms.

Saving publications as Web pages or complete Web sites is a powerful component of Publisher. All publications can be saved in a format that easily is viewed and manipulated using a browser.

Publisher has many features designed to simplify production and make publications visually appealing. Using Publisher, you easily can change the shape, size, and color of text and graphics. You can include many kinds of graphical objects, including mastheads, borders, tables, images, pictures, charts, and Web objects in publications, as well as integrate spreadsheets and databases. Starting Publisher When you first start Publisher, the New templates gallery usually is displayed in the Backstage view.

If it is not displayed, click File on the Ribbon, click Options in the Backstage view, click General Options dialog box , and then click Show the New template gallery when starting Publisher to select the check box in the General panel. The Publisher Window On the right side of the Backstage view, Publisher displays the New template gallery, which includes a list of publication types. Publication types are typical publications used by desktop publishers. The more popular types are displayed in the center of the window.

Each publication type is a link to display various templates and blank publications from which you may choose. Once you select a publication type, the window changes to allow you to select a specific template Figure Some templates are installed with Publisher, and others are available online. Clicking a publication type causes template previews to be displayed in the center of the window. The templates are organized by purpose for example, Sales and then alphabetically by design type.

On the right, Publisher will display a larger preview of the selected template, along with some customization options if the template is installed or a download option if the template is online. In Figure 84, the installed Arrows template is selected so that the customize options appear. Microsoft Publisher window title bar preview of selected template Arrows template selected Customize area for selected template marketing templates Publisher program button displayed on taskbar Create button Figure 84 Copyright Cengage Learning, Inc.

When you click the Create button, Publisher creates the document and sets it up for you to edit. Figure 85 shows the Arrows document that Publisher creates when default options are selected. It enables you to create pages, which are organized in sections, just as in a physical notebook. In OneNote, you can type notes anywhere on a page and then easily move the notes around on the page.

You can create lists and outlines, use handwriting to enter notes, and create drawings. If you use a Tablet PC to add handwritten notes to a document, OneNote can convert the handwriting to text.

It also can perform searches on the handwritten entries. Pictures and data from other programs easily are incorporated in your notes. In addition to typing and handwriting, you can take audio notes. For example, you could record conversations during a meeting or lecture. As you record, you can take additional notes.

When you play back the audio notes, you can synchronize the additional notes you took; that is, OneNote will show you during playback the exact points at which you added the notes.

A variety of note flags, which are symbols that call your attention to notes on a page, enable you to flag notes as being important. You then can use the Note Flags summary to view the flagged notes, which can be sorted in a variety of ways. OneNote includes tools to assist you with organizing a notebook and navigating its contents. It also includes a search facility, making it easy to find the specific notes in which you are interested.

For short notes that you always want to have available readily, Copyright Cengage Learning, Inc. Like a physical notebook, the OneNote notebook consists of notes that are placed on pages. The pages are grouped into sections, which can be further grouped into folders.

No folders are shown in the notebook in the figure. You can use the Search All Notebooks box to search for specific text in your notes. You can add pages to the notebook using the New Page button in the Page Tabs pane. If Page Tabs are displayed, then you can switch to a page by clicking its tab. Figure 86 shows the Top Uses page being displayed for the General notebook. Moving, Renaming, and Deleting Files Earlier in this chapter, you learned how to organize files in folders, which is part of a process known as file management.

The following sections cover additional file management topics including renaming, moving, and deleting files. To Rename a File In some circumstances, you may want to change the name of, or rename, a file or a folder.

For example, you may want to distinguish a file in one folder or drive from a copy of a similar file, or you may decide to rename a file to better identify its contents.

Always use caution when renaming files. Can I rename a file when it is open? No, a file must be closed to change the file name. Figure 88 Other Ways 1. When you move a file, it no longer appears in the original folder. If the destination and the source folders are on the same disk drive, you can move a file by dragging it. If the folders are on different disk drives, then you will need to right-drag the file. Right-click file, drag file to destination folder, click Move here 2.

Right-click file to copy, click Cut on shortcut menu, right-click destination folder, click Paste on shortcut menu 3.

Exercise extreme caution when deleting a file or files. When you delete a file from a hard disk, the deleted file is stored in the Recycle Bin where you can recover it until you empty the Recycle Bin. If you delete a file from removable media, such as a USB flash drive, the file is deleted permanently. Can I use this same technique to delete a folder? Right-click the folder and then click Delete on the shortcut menu. When you delete a folder, all of the files and folders contained in the folder you are deleting, together with any files and folders on lower hierarchical levels, are deleted as well.

Yes button Figure 91 Other Ways 1. To illustrate the use of Office Help, this section uses Word. Help in other Office programs operates in a similar fashion. In Office , Help is presented in a window that has Web-browser-style navigation buttons. Each Office program has its own Help home page, which is the starting Help page that is displayed in the Help window.

Figure 92 Other Ways 1. Press F1 Moving and Resizing Windows Up to this point, this chapter has used minimized and maximized windows. At times, however, it is useful, or even necessary, to have more than one window open and visible on the screen at the same time. You can resize and move these open windows so that you can view different areas of and elements in the window. In the case of the Help window, for example, it could be covering document text in the Word window that you need to see.

To Move a Window by Dragging You can move any open window that is not maximized to another location on the desktop by dragging the title bar of the window. The following step drags the Word Help window to the top left of the desktop.

Word Help window moved drag bottom corner to resize Other Ways 1. Right-click title bar, click Move on shortcut menu, drag window Figure 93 To Resize a Window by Dragging Sometimes, information is not visible completely in a window. A method used to change the size of the window is to drag the window borders. The following step changes the size of the Word Help window by dragging its borders.

Can I drag other borders on the window to enlarge or shrink the window? Will Windows 7 remember the new size of the window after I close it? When you reopen the window, Windows 7 will display it at the same size it was when you closed it. You can search for help by using any of the three following methods from the Help window: 1. Click the links in the Help window 3. If All Word already is selected, click the Search button arrow again to close the Search menu.

Selecting All Word on the Search menu ensures that Word Help will search all possible sources for information about your search term. It will produce the most complete search results. Why do my search results differ?

If you do not have an Internet connection, your results will reflect only the content of the Help files on your computer. When searching for help online, results also can change as material is added, deleted, and updated on the online Help Web pages maintained by Microsoft. Why were my search results not very helpful? Home button Browse area Formatting link Figure 98 To Obtain Help Using the Help Links If your topic of interest is listed in the Browse area of the Help window, you can click the link to begin browsing the Help categories instead of entering search text.

You browse Help just as you would browse a Web site. If you know which category contains your Help information, you may wish to use these links. The following step finds the Formatting Help information using the category links from the Word Help home page. You can browse through the Table of Contents to display information about a particular topic or to familiarize yourself with an Office program.

The following steps access the Help information about themes by browsing through the Table of Contents. If necessary, click the Maximize button on the Help title bar to maximize the window Figure How do I remove the Table of Contents pane when I am finished with it? The Show Table of Contents button acts as a toggle.

For example, you may be unsure about how a particular command works, or you may be presented with a dialog box that you are not sure how to use. Figure shows one option for obtaining help while working in Word. If you want to learn more about a command, point to the command button and wait for the Enhanced ScreenTip to appear. If the Help icon appears in the Enhanced ScreenTip, press the f1 key while pointing to the command to open the Help window associated with that command.

Pressing the f1 key while the dialog box is displayed opens a Help window. The Help window contains help about that dialog box, if available. If no help file is available for that particular dialog box, then the main Help window opens. Windows Help and Support is available when using Windows 7 or when using any Microsoft program running under Windows 7.

This feature is designed to assist you in using Windows 7 or the various programs. Table 4 describes the content found in the Help and Support Center. Not sure where to start? This area displays three topics to help guide a user: How to get started with your computer, Learn about Windows Basics, and Browse Help topics. Clicking one of the options navigates to corresponding Help and Support pages. Clicking the links navigates to the corresponding Web pages on the Web site.

Why are the programs that are displayed on the Start menu different? Windows adds the programs you have used recently to the left pane on the Start menu. You have started several programs while performing the steps in this chapter, so those programs now are displayed on the Start menu. You started Windows 7, were introduced to the components of the desktop, and learned several mouse operations.

You opened, closed, moved, resized, minimized, maximized, and scrolled a window. You used folder windows to expand and collapse drives and folders, display drive and folder contents, create folders, and rename and then delete a file. As part of this learning process, you discovered the common elements that exist among these different Office programs.

You now can save basic document, presentation, spreadsheet, and database files. Microsoft Office Help was demonstrated, and you learned how to use the Office Help window. You were introduced to the Windows 7 Help and Support Center and learned how to use it to obtain more information about Windows 7.

The items listed below include all of the new Windows 7 and Office skills you have learned in this chapter. Create a Folder OFF 22 If so, log into the SAM Web site at www. Learn It Online Test your knowledge of chapter content and key terms. Instructions: To complete the Learn It Online exercises, start your browser, click the Address bar, and then enter the Web address scsite.

When the Office Learn It Online page is displayed, click the link for the exercise you want to complete and then read the instructions. An interactive game that challenges your knowledge of chapter content in the style of a television quiz show.

Flash Cards An interactive learning environment where you identify chapter key terms associated with displayed definitions. Crossword Puzzle Challenge A crossword puzzle that challenges your knowledge of key terms presented in the chapter.

Creating a Folder and a Document Instructions: You will create a Word folder and then create a Word document and save it in the folder. Click the New folder button on the toolbar to display a new folder icon and text box for the folder name. Type Word in the text box to name the folder. Press the enter key to create the folder on the USB flash drive.

Enter the text shown in Figure Click the Save button on the Quick Access Toolbar. Submit the printout to your instructor. Figure 9. Quit Word. Extend Your Knowledge Extend the skills you learned in this chapter and experiment with new skills. You will use Help to complete the assignment. Search Word Help to answer the following questions. What are the steps to add a new group to the Ribbon?

What are Quick Parts? With the Word program still running, start PowerPoint. Figure Copyright Cengage Learning, Inc. Search PowerPoint Help to answer the following questions. What is a slide master? How do you copy slides from another presentation into the existing presentation? Quit PowerPoint. Start Excel. Search Excel Help to answer the following questions. What are three different functions available in Excel? What are sparklines? Quit Excel. Start Access. Search Access Help to answer the following questions.

What is SQL? What is a data macro? Quit Access. Type the answers from your searches in the Word document. Save the document with a new file name and then submit it in the format specified by your instructor.

Organizing Vacation Photos Instructions: See the inside back cover of this book for instructions on downloading the Data Files for Students, or contact your instructor for information on accessing the required files.

Traditionally, you have stored photos from past vacations together in one folder. The photos are becoming difficult to manage, and you now want to store them in appropriate folders. You will create the folder structure shown in Figure You then will move the photos to the folders so that they will be organized properly. Using the techniques presented in the chapter, create the hierarchical folder structure shown in Figure Vacation 3. Using the techniques presented in the chapter, Photos move the vacation photos to their appropriate folders.

Submit your work in the format specified by your instructor. Instructions: Use Windows Help and Support to perform the following tasks: 1. Use the Help and Support Content page to answer the following questions. How do you reduce computer screen flicker? Which dialog box do you use to change the appearance of the mouse pointer?

How do you minimize all windows? What is a VPN? How can you minimize all open windows on the desktop? How do you start a program using the Run command? What are the steps to add a toolbar to the taskbar? What wizard do you use to remove unwanted desktop icons? The tools to solve a problem while using Windows 7 are called troubleshooters. Use Windows Help and Support to find the list of troubleshooters Figure , and answer the following questions. What problems does the HomeGroup troubleshooter allow you to resolve?

List five Windows 7 troubleshooters that are not listed in Figure Use Windows Help and Support to obtain information about software licensing and product activation, and answer the following questions. What is genuine Windows?

What is activation? What steps are required to activate Windows? What steps are required to read the Microsoft Software License Terms? Can you legally make a second copy of Windows 7 for use at home, work, or on a mobile computer or device? What is registration? Close the Windows Help and Support window. He would like to organize his files in relation to the types of pets available in the store. He has five main categories: dogs, cats, fish, birds, and exotic.

You are to create a folder structure similar to Figure Shelly wrote and published his first computer education textbook in Gary and a talented group of contributing authors have produced books on computer programming, computer concepts, and application software that are the leading textbooks in the computer technology market today. Misty E. Vermaat has more than 20 years of experience in the field of computer information systems.

Your email address will not be published. Save my name, email, and website in this browser for the next time I comment. How to Visualize Data with D3 [Video]. How to Visualize Data with R [Video].

Macbook Tricks and Tips March Time USA May 27, WebUser 20 March Skip to content Other 0. New to this Edition Expanded coverage of PowerPoint and Outlook to provide a thorough introduction to these applications and give exposure to the numerous enhancements made with Office

Microsoft Office Introductory – PDF Free Download – Get everything you need

 
 
It is a static function and tries to access this pointer. with Microsoft Access Introductory pdf free.