Microsoft Access & Level 1

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

If there is any doubt about it, professional personnel will handle this at first time, and you can also have their remotely online guidance to install and use our MO test torrent. We respect your privacy and will never send junk email to you, MO Exam Fee Maybe you will ask whether such a short time can finish all the content, we want to tell you that you can rest assured ,because our MO learning materials are closely related to the exam outline and the questions of our MO guide questions are related to the latest and basic knowledge.

Ardent staff and employees, This is unexpected when college students have just entered the campusMO exam torrent also helps students enter famous enterprises. They have more than 10 years\’ experience in the MO practice exam, Stop hesitating and confusing, it is a wise decision to choose our MO free torrent vce.

In order to cater your needs to pass exam successfully our MO study guide have the ability do that and improve your aspiration about core knowledge, Which means our Microsoft MO guide torrent materials abound with useful knowledge you are always looking for. MO sure braindumps are authoritative and valid, which can ensure you pass the MO actual test at first attempt, Adapt to the network society, otherwise, we will take the risk of being obsoleted.

The team using the account expects to have hundreds of master keys and therefore does not want to manage access control for customer master keys CMKs. Newly created CMKs must have a key policy that allows the root principal to perform all actions. They have just realized that they need to use RecoverPoint write splitters, but do not understand how they work.

It sends a copy to the local RecoverPoint appliance. It sends a copy to the remote RecoverPoint appliance. Answer: A. After the sale ends, the price goes back to the original price.

What is the percent of increase to the nearest percent from the sale price back to the regular price for the shoes? First you need to create an account with S click link \’Registration\’ in top menu. Access enables database novices and programmers to store, organize, view, analyze, and share data, as well as build powerful, integrable, custom database solutions — but databases can be complex, and difficult to navigate. This book helps you harness the power of the database with a solid understanding of their purpose, construction, and application.

From database fundamentals and terminology to XML and Web services, this book has everything you need to maximize Access and build the database you need. The truth is that there aren\’t too many differences between the functions available in Access and Access , that has only undergone a minor facelift.

Its main features and functions can be summarized as follows:. If you\’re interested in this software, count yourself lucky because it can be downloaded free for almost any platform or operating system.

Unfortunately, there\’s still no online version as is the case of Word, Excel, or PowerPoint so your only choice is to download the complete Microsoft Office package to make the most of this program. Hi VVicky. Linux Format UK November How It Works March Linux Format UK April Leave a Reply Cancel reply Your email address will not be published.

 
 

 

Microsoft access 2019 pdf free

 

While using this, you will know how to do formatting, create macros and reports in order to be updated with your projects. You can also use it by downloading Microsoft access for dummies pdf free.

The downloadable eBooks contain tutorials that are simpler and understandable, making them suitable to learn access even if you are a beginner. The book contains complete information on formatting of database while accessing excel data and reports.

This book will serve as your accessibility guide. The book features hands-on activities that allow students to explore the program further. With this book, you can effortlessly build powerful databases and put them to good use. It provides a step-by-step guide on how to ace an exam. The Old and New Testaments are organized into 52 lessons to help keep learning organized and on track.

This bible comes with 9 copies to allow groups from a variety of backgrounds…. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access has to offer. The companion website features all examples and databases used in the book, plus trial software and a special offer from Database Creations. Start from the beginning for a complete tutorial, or dip in and grab what you need when you need it. Multi-device capabilities smartphones, tablets, and PCs Lifetime access Fresh content, updated whenever something changes All for a lower price.

Create an Account. Gain access to our instructor resources. Review materials online with PDF files. Preview net discounted pricing and view your order history.

Students use this to purchase materials. Save your data for future orders. This category is reserved for bookstore purchasing agents or resellers.

Not for Students. First Name. Last Name. Email Address. Confirm Password. Educators Log in to request review copies and download instructor resources. LMS integration capabilities allow users seamless access to MyLab IT with single sign-on, grade sync, and asset-level deep linking.

Continuing a focus on accessibility, MyLab IT includes an integrated Accessibility Toolbar with translation feature for students with disabilities, as well as a Virtual Keyboard that allows students to complete keyboard actions entirely on screen. MyLab IT badges provide verified evidence that learners have demonstrated specific skills and competencies using Microsoft Office tools in a real project and help distinguish students within the job pool.

Badges include tags with relevant information that allow students to be discoverable by potential employers, as well as search for jobs for which they are qualified.

Students prove this by completing an objective quiz that requires them to critically think about the project, interpret data, and explain why they performed the actions they did in the project. Critical Thinking is a hot button issue at many institutions and is highly sought after in job candidates, allowing students with the Critical Thinking Badge to stand out and prove their skills. Rubrics For Mid-Level Exercises without a definitive solution.

PowerPoints meet accessibility standards for students with disabilities. The gallery does a lot of community outreach to help local artists develop a network of clients and supporters. Local schools are invited to bring students to the gallery for enrichment programs. As the administrative assistant for Spotted Begonia, you are responsible for overseeing the production of documents, spreadsheets, newspaper articles, and presentations that will be used to increase public awareness of the gallery.

Other clerical assistants who are familiar with Microsoft Office will prepare the promotional materials, and you will proofread, make necessary corrections, adjust page layouts, save and print documents, and identify appropriate templates to simplify tasks.

Your experience with Microsoft Office is limited, but you know that certain fundamental tasks that are common to Word, Excel, and PowerPoint will help you accomplish your oversight task. You are excited to get started with your work! Microsoft Office is a productivity software suite that includes a set of software applications, each one specializing in a specific type of output.

There are different versions of Office. Office is purchased as a monthly or annual subscription and is fully installed on your PC, tablet, and phone. With Office , you receive periodic updates of new features and security measures. Office also includes access to OneDrive storage.

Office is a one-time purchase and fully installed on your PC. Periodic upgrades are not available. Both Office and Office have versions that run on a Mac. Some versions of Office also include Access. Microsoft Word Word is a word processing application, used to produce all sorts of documents, including memos, newsletters, reports, and brochures. Microsoft Excel Excel is a financial spreadsheet program, used to organize records, financial transactions, and business information in the form of worksheets.

Microsoft PowerPoint PowerPoint is presentation software, used to create dynamic presentations to inform and persuade audiences. Finally, Microsoft Access Access is a database program, used to record and link data, query databases, and create forms and reports. The choice of which software application to use really depends on what type of output you are producing. Table 1.

TABLE 1. Excel Spreadsheet software used to store quantitative data and to perform accurate and rapid calculations, what-if analyses, and charting, with results ranging from simple budgets to sophisticated financial and statistical analyses. PowerPoint Presentation graphics software used to create slide shows for presentation by a speaker or delivered online, to be published as part of a website, or to run as a stand-alone application on a computer kiosk. Access Relational database software used to store data and convert it into information.

Database software is used primarily for decision making by businesses that compile data from multiple records stored in tables to produce informative reports. These programs are designed to work together, so you can integrate components created in one application into a file created by another application.

For example, you could integrate a chart created in Excel into a Word document or a PowerPoint presentation, or you could export a table created in Access into Excel for further analysis. You can use two or more Office applications to produce your intended output. In addition, Microsoft Office applications share common features. Such commonality gives a similar feel to each software application so that learning and working with each Office software application is easier.

This chapter focuses on many common features that the Office applications share. Although Word is primarily used to illustrate many examples, you are encouraged to open and explore Excel and PowerPoint and to some degree, Access to examine the same features in those applications. As a note, most of the content in this chapter and book are for the Windows-based Office applications. Some basic information about Office for Mac is included in TIP boxes and in the Step boxes when there are significant differences to point out.

You will also learn to identify interface components common to Office software applications, such as the ribbon, Backstage view, and the Quick Access Toolbar. You will experience Live Preview. You will learn how to get help with an application. You will also learn about customizing the ribbon and using Office add-ins.

Select the Start icon to display the Start menu and select the app tile for the application in which you want to work see Figure 1. Note: The Start menu in Figure 1. If the application tile you want is not on the Start menu, you can open the program from the list of all apps on the left side of the Start menu, or alternatively, you can use search on the taskbar. Just type the name of the program in the search box and press Enter.

The program will open automatically. That means any computer can have the same familiar look that you are used to seeing on your home or school computers and devices. Your Microsoft account will automatically sign in to all the apps and services that use a Microsoft account, such as OneDrive and Outlook. If you share your computer with another user, each user can have access to his or her own Microsoft account, and can easily switch between accounts by logging out of one Microsoft account and logging in to another Microsoft account.

You can switch accounts within an application as well. Click the profile name at the top-right of the application. Select Switch account. Select an account from the list, if the account has already been added to the computer, or add a new account. On a Mac, to switch between accounts in an application, complete the following steps: 1. Click the application menu Word, Excel, etc.

Click Sign in again, type your user email, click Next, type password, and then click Sign in. These resources include an Outlook email account and access to OneDrive cloud storage. Cloud storage is a technology used to store files and work with programs that are stored in a central location on the Internet.

OneDrive is a Microsoft app used to store, access, and share files and folders on the Internet. OneDrive is the default storage location when saving Office files. Because OneDrive stores files on the Internet, when a document has been saved in OneDrive the most recent version of the document will be accessible when you log in from any computer connected to the Internet.

Moreover, changes made to any document saved to OneDrive will be automatically updated across all devices, so each device you access with your Windows account will all have the same version of the file. OneDrive enables you to collaborate with others. You can share your documents with others or edit a document on which you are collaborating.

You can even work with others simultaneously on the same document. STEP 1 Working with Files When working with an Office application, you can begin by opening an existing file that has already been saved to a storage medium or you can begin work on a new file or template.

When you are finished with a file, you should save it, so you can retrieve it at another time. Create a New File After opening an Office application, you will be presented with template choices. Use the Blank document workbook, presentation, database, etc. You can also create a new Office file from within an application by selecting New from the File tab.

The File tab is located at the far left of the ribbon. When you select the File tab, you see Backstage view. Backstage view is where you manage your files and the data about them—creating, saving, printing, sharing, inspecting for accessibility, compatibility, and other document issues, and accessing other setting options.

Files are saved to a storage medium such as a hard drive, flash drive, or to OneDrive. The first time you save a file, you indicate where the file will be saved and assign a file name. It is best to save the file in an appropriately named folder so you can find it easily later. Thereafter, you can continue to save the file with the same name and location using the Save command.

If the file is saved in OneDrive, any changes to the file will be automatically saved. You do not have to actively save the document. If you want more control over when changes to your document are saved, you have the option to turn this feature off or back on with the AutoSave feature in the Quick Access Toolbar.

There are instances where you will want to rename the file or save it to a different location. For example, you might reuse a budget saved as an Excel worksheet, modifying it for another year, and want to keep a copy of both the old and revised budgets.

In this instance, you would save the new workbook with a new name, and perhaps save it in a different folder. To do so, use the Save As command, and continue with the same procedure to save a new file: navigating to the new storage location and changing the file name. Figure 1. To navigate to a specific location, use Browse. Click Save As. Select a location or click Browse to navigate to the file storage location.

Type the file name. Click Save. Open a Saved File Often you will need to work on an existing file that has been saved to a storage location. This may be an email attachment that you have downloaded to a storage device, a file that has been shared with you in OneDrive, or a file you have previously created.

To open an existing file, navigate in File Explorer to the folder or drive where the document is stored, and then double-click the file name to open the file.

The application and the file will open. Alternatively, if the application is already open, from Backstage view, click Open, and then click Browse, This PC, or OneDrive to locate and open the file see Figure 1. When opening the application, the Recent list displays in the center pane.

The Recent list changes to reflect only the most recently opened files, so if it has been quite some time since you worked with a particular file, or if you have worked on several other files in between and you do not see your file listed, you can click More documents or Workbooks, Presentations, etc. However, you might want to keep a particular file in the list regardless of how recently it was opened.

In Figure 1. Select the icon to pin the file to the list. Once pinned, you will always have access to the file from the Pinned list. Later, if you want to remove the file from the list, click the pushpin icon. The file will remain on the Recent documents list while it is being used, but will be bumped off the list when other, more recently opened files take its place.

These features enable you to identify the document, provide easy access to frequently used commands, and controls the window in which the document displays. It also includes control buttons that enable you to minimize, restore down, or close the application window. The Quick Access Toolbar, on the left side of the title bar, enables you to turn AutoSave on or off, save the file, undo or redo editing, and customize the Quick Access Toolbar.

Located just below the title bar is the ribbon. If you are working with a large project, you can maximize your workspace by temporarily hiding the ribbon. These controls enable you to not only collapse or expand the ribbon, but also to choose whether you want to see the tabs or no tabs at all.

The tab name indicates the type of commands located on the tab. On each tab, the ribbon displays several task-oriented groups. A group is a subset of a tab that organizes similar commands together. A command is a button or task within a group that you select to perform a task see Figure 1. The ribbon with the tabs and groups of commands is designed to provide efficient functionality. For that reason, the Home tab displays when you first open a file in an Office software application and contains groups with the most commonly used commands for that application.

Similarly, other tabs contain groups of related actions, or commands, many of which are unique to each Office application. The active tab in Figure 1. On a Mac, to display group names on the ribbon, click the application name menu Word, Excel, PowerPoint and select Preferences. Click View and click to select Show group titles in the Ribbon section of the View dialog box. The arrow may be below or to the right of the main command, depending on the command, window size, or screen resolution.

When selected, the arrow brings up additional commands or options associated with the main command. For example, selecting the Paste arrow enables you to access the Paste Options commands, and the Font color arrow displays a set of colors from which to choose. Instructions in the Exploring series use the command name to instruct you to click the main command to perform the default action, such as click Paste.

Instructions include the word arrow when you need to select the arrow to access an additional option, such as click the Paste arrow. Office applications enable you to work with objects such as images, shapes, charts, and tables.

When you include such objects in a project, they are considered separate components that you can manage independently. To work with an object, you must first select it. When an object is selected, the ribbon is modified to include one or more contextual tabs that contain groups of commands related to the selected object.

These tabs are designated as Tool tabs; for example, Picture Tools is the contextual tab that displays when a picture is selected. When the object is no longer selected, the contextual tab disappears.

Word, PowerPoint, Excel, and Access all share a similar ribbon structure. Although the specific tabs, groups, and commands vary among the Office programs, the way in which you use the ribbon and the descriptive nature of tab titles is the same, regardless of which program you are using. For example, if you want to insert a chart in Excel, a header in Word, or a shape in PowerPoint, those commands are found on the Insert tab in those programs. The first thing you should do as you begin to work with an Office application is to study the ribbon.

Look at all tabs and their contents. That way, you will have a good idea of where to find specific commands, and how the ribbon with which you are currently working differs from one that you might have used in another application. For example, you might want to apply a special effect such as Small caps or apply character spacing to some text. Because these effects are not found on the ribbon, they will most likely be found in a dialog box in this case, the Font dialog box.

When you open a dialog box, you gain access to more precise or less frequently used commands. Dialog boxes are accessed by clicking a Dialog Box Launcher , found in the lower right corner of some ribbon groups. Instead, click a menu option such as Format, Edit, or Insert for additional options. Click the Help button that displays as a question mark in the top-right corner of the dialog box.

The subsequent Help window offers suggestions or assistance in implementing the relevant feature. For example, the Styles group displays on the Home tab of the Word ribbon.

Because there are more styles than can easily display at once, the Styles group can be expanded to display a gallery of additional styles. A gallery is an Office feature that displays additional formatting and design options. Galleries in Excel and PowerPoint provide additional choices of chart styles and slide themes, respectively.

The feature that displays a preview of the results of a selection is called Live Preview. For example, you might be considering modifying the color of an image in a document or worksheet. As you place the pointer over a color selection in a ribbon gallery or group, the selected image will temporarily display the color to which you are pointing.

Similarly, you can get a preview of how theme designs would display on PowerPoint slides by pointing to specific themes in the PowerPoint Themes group and noting the effect on a displayed slide. When you click the item, the selection is applied.

Live Preview is available in various ribbon selections among the Office applications. In this case, you can personalize the ribbon by creating your own tabs and group together the commands you want to use. To add a command to a tab, you must first add a custom group. You can create as many new tabs and custom groups with as many commands as you need. You can also create a custom group on any of the default tabs and add commands to the new group or hide any commands you use less often see Figure 1.

Keep in mind that when you customize the ribbon, the customization applies only to the Office program in which you are working at the time. If you want a new tab with the same set of commands in both Word and PowerPoint, for example, the new tab would need to be created in each application. The left side of the Customize the Ribbon window displays popular commands associated with the active application, but all available commands can be displayed by selecting All Commands in the Choose commands from list.

On the right side of the Customize the Ribbon window is a list of the Main Tabs and Groups in the active application. You can also access the contextual Tool tabs by selecting the arrow in the Customize the Ribbon list and selecting Tool Tabs. Click the File tab, click Options, and then select Customize Ribbon.

Alternatively, follow the other steps above to access the Customize the Ribbon window. Click the tab name that you want to add a group to under the Customize the Ribbon 3. Ensure a blue background displays behind the tab name. Note that checking or unchecking the tab is not selecting the tab for this feature. Click New Group. New Group Custom displays as a group on the selected tab. Click Rename and give the new group a meaningful name.

Click the command to be added under the Choose commands from list. Click Add. Repeat as necessary, click OK when you have made all your selections. On a Mac, to customize the ribbon, complete the following steps: 1. Click the Word menu or whichever application you are working in and select 2. Click the plus sign at the bottom of the Main Tabs box and select New Group.

Click the Settings icon and click Rename. Give the new group a meaningful name. Continue using steps 5 and 6 in the PC step box above. To revert all tabs or to reset select tabs to original settings, click Reset, and then click Reset all customizations or Reset only selected Ribbon tab refer to Figure 1. By default, the QAT includes commands for saving a file and for undoing or redoing recent actions.

You can recover from a mistake by clicking Undo on the QAT. If you click the Undo command arrow on the QAT, you can select from a list of previous actions in order of occurrence. The Undo list is not maintained when you close a file or exit the application, so you can only erase an action that took place during the current Office session.

You can also Redo or Replace an action that you have just undone. You can also customize the QAT to include commands you frequently use see Figure 1. One command you may want to add is Quick Print. Other convenient commands can be added, such as Editor to run a spell check of the document.

You customize the QAT by selecting Customize Quick Access Toolbar arrow on the right side of the displayed QAT commands or by right-clicking an empty area on the QAT, and then selecting or deselecting the options from the displayed list of commands.

Alternatively, you can right-click any command on the ribbon and select Add to Quick Access Toolbar from the shortcut menu. Although the ribbon and QAT provide efficient access to commands, in some situations you might find it more convenient to access the same commands on a shortcut menu. A shortcut menu is a context-sensitive menu that displays commands and options relevant to the active object.

Shortcut menus are accessed by selecting text or an object or by placing the insertion point in a document and pressing the right mouse button or pressing the right side of a trackpad.

On a Mac, press the Control key when you tap the mouse or use a two-finger tap on a trackpad. The shortcut menu will always include options to cut, copy, and paste. In addition, a shortcut menu features tasks that are specifically related to the document content where the insertion point is placed.

For example, if your insertion point is on a selected word or group of words, the shortcut menu would include tasks such as to find a synonym or add a comment. If the active object is a picture, the shortcut menu includes options to group objects, provide a caption, or wrap text. As shown in Figure 1. Keyboard shortcuts are created by pressing combinations of two or more keys to initiate a software command. There are many other keyboard shortcuts. To discover a keyboard shortcut for a command, point to a command icon on the ribbon to display the ScreenTip.

If a keyboard shortcut exists, it will display in the ScreenTip. You can use KeyTips to do tasks quickly without using the mouse by pressing a few keys—no matter where you are in an Office program. You can get to every command on the ribbon by using an access key—usually by pressing two to four keys sequentially. To stop displaying KeyTips, press Alt again.

Getting Help No matter whether you are a skilled or a novice user of an Office application, there are times when you need help in either finding a certain ribbon command or need additional assistance or training for a task. Fortunately, there are features included in every Office application to offer you support. Use Tell me to enter words and phrases to search for help and information about a command or task you want to perform. Alternatively, use Tell me for a shortcut to a command or, in some instances like Bold , to complete the action for you.

Tell me can also help you research or define a term you entered. Perhaps you want to find an instance of a word in your document and replace it with another word but cannot locate the Find command on the ribbon. If you click Replace, the Find and Replace dialog box opens without you having to locate the command on the ribbon. Another feature is Smart Lookup on the References tab. This feature opens the Smart Lookup pane that shows results from various online sources based on the search term.

Smart Lookup provides information about tasks or commands in Office and can also be used to search for general information on a topic, such as President George Washington. Smart Lookup is also available on the shortcut menu when you right-click text as well as on the References tab in Word.

Depending on your search, Researcher may display instead of, or in addition to, Smart Lookup. Researcher can be used to find quotes, citable sources, and images. Researcher is shown in Figure 1. Use the Help Tab If you are looking for additional help or training on certain features in any Microsoft Office application, you can access this support on the Help tab see Figure 1.

The Help command opens the Help pane with a list of tutorials on a variety of applicationspecific topics. Show Training displays application-specific training videos in the Help pane. Besides Help and Show Training, the Help tab also includes means to contact Microsoft support and to share your feedback. If you are using Office , you receive periodic updates with new features as they are released. For quick summary information on the name and purpose of a command button, point to the command until an Enhanced ScreenTip displays, with the name and a brief description of the command.

If applicable, a keyboard shortcut is also included. Some ScreenTips include a Tell me more option for additional help.

Use Format Painter to copy all applied formatting from one set of text to another. Format Painter can also be used to copy border styles to shapes. Format Painter is available in Word, Excel, and PowerPoint, and can be extremely useful when applying multiple formats to other text. Using Format Painter also ensures consistency in appearance between sets of text.

To copy formatting to one location, single-click Format Painter, and then click where you want the format applied. To copy formatting to multiple locations, double-click Format Painter. Press Esc or click Format Painter again to turn off the command. Installing Add-ins As complete as the Office applications are, you still might want an additional feature that is not a part of the program.

Fortunately, there are Microsoft and third-party programs called add-ins that you can add to the program. An add-in is a custom program that extends the functionality of a Microsoft Office application see Figure 1. For example, in PowerPoint, you could add capability for creating diagrams, access free images, or obtain assistance with graphic design. In Excel, add-ins could provide additional functionality that can help with statistics and data mining.

In Word, add-ins could provide survey or resume-creating capabilities. Some add-ins will be available for several applications.

For example, the Pickit image app shown in Figure 1. Some templates may come with an add-in associated with it. Some add-ins are available for free, whereas others may have a cost. Explain the benefits of logging in with your Microsoft account. Describe when you would use Save and when you would use Save As when saving a document.

Explain how the ribbon is organized. Describe the Office application features that are available to assist you in getting help with a task. A coworker sent you a letter and asked for your assistance in making a few minor formatting changes. The letter is an invitation to the Discover the Artist in You! To begin, you will open Word and open an existing document. You will use the Shortcut menu to make simple changes to the document. Finally, you will use the Tell me box to apply a style to the first line of text.

You rename the file to preserve the original and to save the changes you will make later. Refer to Figure 1. Open the Word document cf01h1Letter. The event invitation letter opens. This is a security measure to alert a user when there is potentially unsafe content in the file you want to open.

You may be confident of the trustworthiness of the files for this book, and should click Enable Content to begin working on the file. Because you will change the name of an existing file, you use the Save As command to give the file a new name. On a Mac, click the File menu and click Save As. Hands-On Exercise 1 19 c. Navigate to the location where you are saving your files.

If you are saving the file in a different location than that of your data files, then you will also change the location of where the file is saved. You save the document with a different name to preserve the original file. When you save files, use your last and first names. Check the title bar of the document to confirm that the file has been saved with the correct name.

Click File and click Close to close the file. Keep Word open. You use ribbon commands to modify parts of the letter. Click the File tab and click Open from the left menu. The Open window displays. The letter you saved earlier opens and is ready to be modified. Place the insertion point in the left margin just before the first line of text The Spotted Begonia Art Gallery so an angled right-pointing arrow displays and click.

This is an efficient way of selecting an entire line of text. Alternatively, you can drag the pointer across the text while holding down the left mouse button to select the text. With the text still selected, click the Font Size arrow in the Font group and select Click Center in the Paragraph group.

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.