Exploring Microsoft Access Comprehensive , – replace.me

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Choosing Ignore will skip the word without changing it. Tell the students they need to set up a database for a softball league.
 
 

 

New Perspectives Microsoft® Office & Access Comprehensive, 1st Edition – Cengage.Microsoftoffice designs, themes, templates and downloadable graphic elements on Dribbble

 
Discuss why you would need to change the view of a document.

 
 

New perspectives microsoft office 365 & access 2019 comprehensive free download

 
 

What is MindTap? Before purchasing, make sure your instructor has assigned this online homework platform. What is SAM? No Longer Available. Available Study Tools. Error rating book. Refresh and try again. Open Preview See a Problem? Details if other :. Thanks for telling us about the problem. Return to Book Page. Sasha Vodnik. Updated with all-new case scenarios, this edition clearly applies the skills students are learning to real-world situations to make concepts even more relevant across the applications and reinforces critical skills to make them successful in their educational and professional careers.

Get A Copy. Paperback , pages. Sort order. Eileen rated it it was ok Jul 17, William Morrison marked it as to-read Jan 13, Ameenah added it Sep 25, Omer Abuzaid added it Sep 27, Kadiri Saliu added it Oct 02, Manmeet marked it as to-read Jun 14, There are no discussion topics on this book yet.

Be the first to start one ». About Mark Shellman. Click File and click Save. Because the file has already been saved, and the name and location are not changing, you use the Save command to save the changes. You will use a Dialog Box Launcher and More to expand the galleries to access the needed commands and features.

The Font dialog box displays. Instead, open a menu and select an option. Click the Small caps check box in the Effects section to select it and click OK.

The Small caps text effect is applied to the selected text. Place the insertion point immediately to the left of the text Discover the Artist in You! Hold the left mouse button down and drag the pointer to select the text up to and including the exclamation point. Otherwise, use the vertical scroll bar to bring the paragraph into view. Hands-On Exercise 1 21 d. Click More in the Styles group to display the Styles gallery. On a Mac, click the right gallery arrow or click the down arrow to view more options.

Point to Heading 1 style. Notice how Live Preview shows how that effect will look on the selected text. Click Intense Emphasis. The Intense Emphasis style is applied to the program name. You use the Undo button on the QAT to revert to the original word. You also anticipate checking the spelling on the letter before sending it out.

Finally, you realize that you could be saving the document more efficiently by using Save on the QAT. Double-click Please and press Delete on the keyboard. Please is deleted from the letter, but you decide to add it back in. Click Undo on the QAT. Please displays again. A list of commands that can be added to the QAT displays. Click Editor. Click Save on the QAT. Hernandez also extends the invitation to her coworkers. Hazelton has asked that you use a different word for coworkers, so you use a shortcut menu to find a synonym.

Point to and right-click the word coworkers in the first sentence of the letter that starts with We are pleased. A shortcut menu displays. Select Synonyms on the shortcut menu. A list of alternate words for coworkers displays.

Select colleagues from the list. The synonym colleagues replaces the word coworkers. You think there is a more efficient way of applying the same format to other text, but you do not know how to complete the task.

Therefore, you use the Tell me box to search for the command and then you apply the change. Click anywhere in the text Discover the Artist in You! Click the Tell me box and type apply format. The Tell me box displays a list of options related to apply format. Select Format Painter from the list of options in the Tell Me results. Notice that the Format Painter command in the Clipboard group is selected and a paintbrush is added to the insertion point.

Drag the pointer over the first instance of Discover the Artist in You! The Intense Emphasis style was applied to the selected text. You notice that to apply formatting to more than one selection, you must double-click Format Painter, but because you need to apply the format to only one more set of text, you will single-click the command.

Click Format Painter in the Clipboard group. Drag the pointer over the second instance of Discover the Artist in You! You used the Format Painter to copy the formatting applied to text to other text.

Save and close the document. You will submit this file to your instructor at the end of the last Hands-On Exercise. You might center a title, or format budget worksheet totals as currency.

You can change the font so that typed characters are larger or in a different style. You might even want to bold text to add emphasis. Sometimes, it may be more efficient to start with a document that has formatting already applied or apply a group of coordinated fonts, font styles, and colors. You might also want to add, delete, or reposition text. Inserting and formatting images can add interest to a document or illustrate content. Finally, no document is finished until all spelling and grammar has been checked and all errors removed.

In this section, you will explore themes and templates. You will learn to use the Mini Toolbar to quickly make formatting changes. You will learn how to select and edit text, as well as check your grammar and spelling.

You will learn how to move, copy, and paste text, and how to insert pictures. And, finally, you will learn how to resize and format pictures and graphics. Using Templates and Applying Themes You can enhance your documents by using a template or applying a theme.

A template is a predesigned file that incorporates formatting elements and layouts and may include content that can be modified. A theme is a collection of design choices that includes colors, fonts, and special effects used to give a consistent look to a document, workbook, or presentation. Microsoft provides high-quality templates and themes, designed to make it faster and easier to create professional-looking documents.

STEP 1 Open a Template When you launch any Office program and click New, the screen displays thumbnail images of a sampling of templates for that application see Figure 1.

One benefit of starting with a template is if you know only a little bit about the software, with only a few simple changes you would have a well-formatted document that represents your specific needs.

Even if you know a lot about the program, starting with a template can be much more efficient than if you designed it yourself from a blank file. Templates in Excel often use complex formulas and formatting to achieve a dynamic workbook that would automatically adjust with only a few inputs.

Using a resume template in Word greatly simplifies potentially complex formatting, enabling you to concentrate on just inputting your personal experiences.

PowerPoint templates can include single element slides such as organization charts but also include comprehensive presentations on topics such as Business Plans or a Quiz show game presentation similar to Jeopardy! The Templates list is composed of template groups available within each Office application.

The search box enables you to locate other templates that are available online. When you select a template, you can view more information about the template, including author information, a general overview about the template, and additional views if applicable. To search for and use a template, complete the following steps: 1.

Open the Microsoft Office application with which you will be working. Or, if the application is already open, click File and click New. Type a search term in the Search for online templates box or click one of the Suggested searches.

Scroll through the template options or after selecting a search term, use the list at the right to narrow your search further. Select a template and review its information in the window that opens. Click Create to open the template in the application. On a Mac, to search for and use a template, complete the following steps: 1. Or, if the application is already open, click the File menu and click New from Template.

Continue with steps 2 through 5 in the PC steps above. Themes are different for each of the Office applications. In Word, a theme is a set of coordinating fonts, colors, and special effects, such as shadowing or glows, that are combined into a package to provide a stylish appearance see Figure 1.

In PowerPoint, a theme is a file that includes the formatting elements such as a background, a color scheme, and slide layouts that position content placeholders. Themes in Excel are like those in Word in that they are a set of coordinating fonts, colors, and special effects.

Themes also affect any SmartArt or charts in a document, workbook, or presentation. Access also has a set of themes that coordinate the appearance of fonts and colors for objects such as Forms and Reports. In Word and PowerPoint, themes are accessed from the Design tab. In Excel, they are accessed from the Page Layout tab. In any application, themes can be modified with different fonts, colors, or effects, or you can design your own theme and set it as a default.

Centering a title, formatting cells, or changing the font color or size are tasks that occur frequently. In all Office applications, the Home tab provides tools for editing text. A common way to select text or numbers is to place the pointer before the first character of the text you want to select, hold down the left mouse button, and then drag to highlight the intended selection.

Note that in Word and PowerPoint when the pointer is used to select text in this manner, it takes on the shape of the letter I, called the I-beam.

Sometimes it can be difficult to precisely select a small amount of text, such as a few letters or a punctuation mark. Other times, the task can be overwhelmingly large, such as when selecting an entire multi-page document. Or, you might need to select a single word, sentence, or paragraph. In these situations, you should use one of the shortcuts to selecting large or small blocks of text. The shortcuts shown in Table 1.

When working with Excel, you will more often need to select multiple cells. To select multiple cells, drag the selection when the pointer displays as a large white plus sign. Once you have selected the text, besides applying formatting, you can delete or simply type over to replace the text. One line of text Place the pointer at the left of the line, in the margin area. When the pointer changes to an angled right-pointing arrow, click to select the line.

One sentence Press and hold Ctrl and click in the sentence to select it. One paragraph Triple-click in the paragraph.

One character to the left of the insertion point Press and hold Shift and press the left arrow on the keyboard. One character to the right of the insertion point Press and hold Shift and press the right arrow on the keyboard. Entire document Press and hold Ctrl and press A on the keyboard. Format Text At times, you will want to make the font size larger or smaller, change the font color, or apply other font attributes, for example, to emphasize key information such as titles, headers, dates, and times.

Because formatting text is commonplace, Office places formatting commands in many convenient places within each Office application. As noted earlier, Word, Excel, and PowerPoint all share very similar Font groups that provide access to tasks related to changing the font, size, and color.

If the font change that you plan to make is not included as a choice on the Home tab, you may find what you are looking for in the Font dialog box. If you are making many formatting choices at once, using the Font dialog box may be more efficient. Depending on the application, the contents of the Font dialog box vary slightly, but the purpose is consistent—providing access to choices related to modifying characters refer to Figure 1.

The way characters display onscreen or print in documents, including qualities such as size, spacing, and shape, is determined by the font. When you open a Blank document, you are opening the Normal template with an Office theme and the Normal style. The Office theme with Normal Style includes the following default settings: Calibri font, point font size, and black font color.

These settings remain in effect unless you change them. Some formatting commands, such as Bold and Italic, are called toggle commands. They act somewhat like a light switch that you can turn on and off. Once you have applied bold formatting to text, the Bold command is highlighted on the ribbon when that text is selected.

To undo bold formatting, select the bold formatted text and click Bold again. Use the Mini Toolbar You have learned that you can always use commands on the Home tab of the ribbon to change selected text within a document, worksheet, or presentation. Although using the ribbon to select commands is simple enough, the Mini Toolbar provides another convenient way to accomplish some of the same formatting changes.

When you select or right-click any amount of text within a worksheet, document, or presentation, the Mini Toolbar displays see Figure 1. The Mini Toolbar provides access to the most common formatting selections, as well as access to styles and list options. To temporarily remove the Mini Toolbar from view, press Esc. You can permanently disable the Mini Toolbar so that it does not display in any open file when text is selected by selecting Options on the File tab.

Or suppose that you have included text on a PowerPoint slide that you believe would be more appropriate on a different slide. Or perhaps an Excel formula should be copied from one cell to another because both cells should show totals in a similar manner. In all these instances, you would use the cut, copy, and paste features found in the Clipboard group on the Home tab.

The Office Clipboard is an area of memory reserved to temporarily hold selections that have been cut or copied and enables you to paste the selections to another location. To copy means to duplicate a selection from the original location and place a copy in the Office Clipboard. To paste means to place a cut or copied selection into another location in a document.

It is important to understand that cut or copied text remains in the Office Clipboard even after you paste it to another location. The Office Clipboard can hold up to 24 items at one time.

To cut or copy text, and paste to a new location, complete the following steps: 1. Select the text you want to cut or copy. Click the appropriate command in the Clipboard group either to cut or copy the selection.

Click the location where you want the cut or copied text to be placed. The location can be in the current file or in another open file within most Office applications. Click Paste in the Clipboard group on the Home tab. You can paste the same item multiple times, because it will remain in the Office Clipboard until you power down your computer or until the Office Clipboard exceeds 24 items. It is best practice to complete the paste process as soon after you have cut or copied text.

In addition to using the commands in the Clipboard group, you can also cut, copy, and paste by using the Mini Toolbar, a shortcut menu right-clicking , or by keyboard shortcuts. These methods are listed in Table 1. Click in destination location. With Clipboard pane open, click the arrow beside the intended selection and select Paste. In some instances, you may want to paste only the text, unformatted, so that special effects such as hyperlinks are not copied.

In other instances, you might want to paste and match the formatting in the destination location or keep the current formatting in the new location. Paste Options commands are displayed when you click the Paste arrow or use the shortcut menu. Paste Options are different in each application, but in general, they include pasting contents without any formatting applied, pasting contents using the source formats, or pasting contents using the destination formats.

In Excel, Paste Options also include pasting values to replace formulas, and transposing columns and rows to rows and columns. There are also options related to pasting pictures. Regardless of which Office application you are using, you can view the Office Clipboard by clicking the Clipboard Dialog Box Launcher, as shown in Figure 1.

If you know you will be cutting or copying and then pasting several items, rather than doing each individually, you can cut or copy all the items to the Office Clipboard, and then paste each or all Office Clipboard items to the new location. This is especially helpful if you are pasting the Office Clipboard items to a different Office file. Just open the new file, display the Clipboard pane, and select the item in the list to paste it into the document.

The Office Clipboard also stores graphics that have been cut or copied. You can delete items from the Office Clipboard by clicking the arrow next to the selection in the Clipboard pane and selecting Delete.

You can remove all items from the Office Clipboard by clicking Clear All. The Options button at the bottom of the Clipboard pane enables you to control when and where the Office Clipboard is displayed. Close the Clipboard pane by clicking the Close button in the top-right corner of the pane or by clicking the arrow in the title bar of the Clipboard pane and selecting Close.

It is important that you carefully review your document for any spelling or punctuation errors, as well as any poor word choices before you send it along to someone else to read. Word, Excel, and PowerPoint all provide standard tools for proofreading, including a spelling and grammar checker and a thesaurus.

If a word is unrecognized, it is flagged as misspelled or grammatically incorrect. Misspellings are identified with a red wavy underline, and grammatical or word-usage errors such as using bear instead of bare have a blue double underline. Excel does not check spelling as you type, so it is important to run the spelling checker in Excel.

Although spelling and grammar is checked along the way, you may find it more efficient to use the spelling and grammar feature when you are finished with the document. When it is selected, the Editor pane will open on the right. For each error, you are offered one or more suggestions as a correction.

You can select a suggestion and click Change, or if it is an error that is made more than one time throughout the document, you can select Change All see Figure 1. If an appropriate suggestion is not made, you can always enter a correction manually. For example, you might have a word that is truly misspelled in its context, but perhaps is still a valid word in the dictionary.

Spell check might not pick it up as a misspelled word, but a careful read through would probably pick it up. There are times when the spelling and grammar check will indicate a word is misspelled and it really is not.

In these instances, you can choose to Ignore, Ignore All, or Add. Choosing Ignore will skip the word without changing it. If you know there are multiple instances of that word throughout the document, you can choose Ignore All, and it will skip all instances of the word. Finally, if it is a word that is spelled correctly and that you use it often, you can choose to Add it to the dictionary, so it will not be flagged as an error in future spell checks.

If you right-click a word or phrase that is identified as a potential error, you will see a shortcut menu similar to that shown in Figure 1. The top of the shortcut menu will identify the type of error, whether it is spelling or grammar.

A pane opens next to the shortcut menu with a list of options to correct the misspelling. Click on any option to insert it into the document. Similarly, you have the choices to Add to Dictionary or Ignore All.

There is a standard list of common errors and suggested replacements that is used in Excel, Word, and PowerPoint. So, if you type a word that is found in the Replace column, it will automatically be replaced with the replacement in the With column. For example, if you typed accross it would automatically correct to across. You can add or delete terms and manage AutoCorrect by selecting Options from the File tab, and then in the Options dialog box, select Proofing and then click AutoCorrect Options.

You can add energy and additional description to a project by including pictures and other graphic elements. A picture is just that—a digital photo. A picture can also be considered an illustration. Illustrations can also be shapes, icons, SmartArt, and Charts.

While each of these types of illustrative objects have definitive differences, they are all handled basically the same when it comes to inserting and resizing. For the purposes of simplicity, the following discussion focuses on pictures, but the same information can be applied to any illustrative object you include in your document, worksheet, or presentation.

If you want a wider variety of pictures to choose from, you can search directly inside the Office program you are using for an online picture using Bing. Pictures and Online Pictures are found on the Insert tab. Click in the file where you want the picture to be placed. Click the Insert tab. Click Online Pictures in the Illustrations group. Type a search term in the Bing search box and press Enter. Select an image and click Insert. When the picture is inserted into a document, the Picture Tools Format tab displays.

You can use these tools to modify the picture as needed. These are images and drawings that can be used more freely than images found directly on websites.

Because there are different levels of Creative Commons licenses, you should read the Creative Commons license for each image you use to avoid copyright infringement. Before you make any changes to a picture, you must first select it. When the picture is selected, eight sizing handles display on the corners and in the middle of each edge see Figure 1. To adjust the size while maintaining the proportions, place your pointer on one of the corner sizing handles, and while holding the left mouse button down, drag the pointer on an angle upward or downward to increase or decrease the size, respectively.

In addition to sizing handles, a rotation handle displays at the top of the selected image. Use this to turn the image. When a picture is selected, the Picture Tools Format tab includes options for modifying a picture. You can apply a picture style or effect, as well as add a picture border, from selections in the Picture Styles group. Click More to view a gallery of picture styles.

As you point to a style, the style is shown in Live Preview, but the style is not applied until you select it. Options in the Adjust group simplify changing a color scheme, applying creative artistic effects, and even adjusting the brightness, contrast, and sharpness of an image refer to Figure 1.

If a picture contains areas that are not necessary, you can crop it, which is the process of trimming edges that you do not want to display.

Even though cropping enables you to adjust the amount of a picture that displays, it does not actually delete the portions that are cropped out. Therefore, you can later recover parts of the picture, if necessary. Cropping a picture does not reduce the file size of the picture or the document in which it displays. If you want to permanently remove the cropped portions of a figure and reduce the file size, you must compress the picture.

Quick Concepts 5. Discuss the differences between themes and templates. Discuss several ways text can be modified. Explain how the Office Clipboard is used when relocating text. Explain how to review a document for spelling and grammar. Explain why it is important to use the corner sizing handles of a picture when resizing. You decide to use a template to help you get started more quickly and to take advantage of having a professionally formatted document without knowing much about Word.

You will modify the flyer created with the template by adding and formatting your own content and changing out the photo. You search for flyers and finally choose one that is appropriate for the event, knowing that you will be able to replace the photo with your own. Ensure Word is open. Click File and click New. Type the search term seasonal event flyer in the Search for online templates box to search for event flyer templates. Click Start searching. Your search results in a selection of event flyer templates.

Locate the Seasonal event flyer template as shown in Figure 1. The template displays in a preview. Click Create to open the flyer template. The flyer template that you selected opens in Word. Because this is the first time you save the flyer file, clicking Save on the QAT opens the Save As window, in which you must indicate the location of the file and the file name.

Click Browse to navigate to where you save your files. Click the Design tab and click Themes in the Document Formatting group. The Themes gallery displays. Point to a few themes and notice how the template changes with each different theme. Click Gallery.