Microsoft office access 2007 training manual pdf free download.Microsoft Office 2007 Training Manual

Looking for:

Microsoft office access 2007 training manual pdf free download

Quick Links Download this manual. Previous Page. Next Page. Get up to speed with the Office system Menus and toolbars have been Page 5 Lesson 1 The new Office: Made for you With the Ribbon, commands and other tools you need are now exposed and more readily available.

Get up to speed with the The three parts of the Ribbon are tabs, groups, and commands. Tabs sit across the top of the Ribbon. Each one represents core tasks you do in a given program. Groups are sets of related commands.

They remain on display and readily available, giving you rich visual aids. How do you get started? Begin with the first tab. Frequently used core commands no longer have to share space with a range of remotely related commands on a menu or toolbar.

Page 10 More commands, but only when you need them Commands you use most are available on the Ribbon all the time. Others appear only when you need them, in response to an action you take. Page 11 More options if you need them Sometimes an arrow, called the Dialog Box Launcher, appears in the lower-right corner of a group. This means more options are available for the group. Page 12 Preview before you select Are you familiar with the try-undo-try cycle?

Animation: Right-click, and click Play. Now you can see a live preview of your choice before you make a selection, which saves you time and gives you better results. Page 13 Preview before you select Are you familiar with the try-undo-try cycle? Page 14 Quick Access Toolbar. Page 15 You can easily add them to the Quick Access Toolbar. Page 16 Working with different screen resolutions Everything described so far applies if your screen is set to high resolution and the program window is maximized.

If not, things look different. Page 17 Working with different screen resolutions Everything described so far applies if your screen is set to high resolution and the program window is maximized. Find more Excel options. Online practice requires Word and Excel , part of the Microsoft Office system Get up to speed with the Office system Pick one answer. On the last tab. On the first tab. On the Quick Access Toolbar. Page 20 Test 1, question 1: Answer On the first tab.

These commands are used frequently, so they logically appear on the first tab of the Ribbon. Of course, you can add them to the Quick Access Toolbar if you want. Page 21 Test 1, question 2 You move from a computer with a high screen resolution to one with a low resolution. What do you do? Click the View tab. Page 22 Test 1, question 2: Answer Click the arrow on the group button.

Page 23 Lesson 2 Answers to critical questions Page 24 Ribbon and see what else is new. Page 25 What happened to the File menu? The Microsoft Office Button appears in the upper-left corner of the window in several Microsoft Office programs, such as Word and Excel.

But the button offers more commands than the File menu did. Page 26 In previous versions of Office programs you could set options in the Options dialog box, which you opened through the Tools menu. Many of those options can now be found when you click the Microsoft Office Button. Or to jump-start your authoring work, look on the left. Under Microsoft Office Online, click Featured, and choose from the catalog of links to online templates and training courses.

Page 28 What about favorite keyboard shortcuts? Page 29 What about favorite keyboard shortcuts? The new shortcuts also have a new name: Key Tips. The picture shows an example of using Key Tips to remove a heading style in Word. Press H to select the Home tab. Press E to select the Clear Formatting button in the Font group to remove the heading style. Page 30 What about favorite keyboard shortcuts? What about the old keyboard shortcuts?

Keyboard shortcuts of old that begin with CTRL are still intact, and you can use them as you always have. Page 33 What about the new file formats?

Word , Excel , and PowerPoint use new file formats. Page 34 What about the new file formats? For example, in Word, a document is now saved by default with the extension. Page 35 Working with files from earlier versions You may be the first in your group to get the Office system.

Or you may work with departments that need to use Office documents saved in an earlier format. Just open the file as usual. Page 38 What about the new file format in Access? The new file format in Access ,. For example, Access supports the attachment data type—which lets you store documents and files as compressed attachments in your database—and multivalued fields. Page 39 What about the new file format in Access? You can open and work with. Page 40 What about the new file format in Access?

Page 41 Save your Word file as a different version. Check out your options in Excel. Use a keyboard shortcut in Excel. Page 42 Test 2, question 1 Where is the first button that you click to get to the commands to open and save your files? In the upper-left corner. At the bottom of the Ribbon. Page 43 Test 2, question 1: Answer In the upper-left corner.

Page 44 Test 2, question 2 To use a keyboard shortcut to select a tab on the Ribbon, you first press which key on the keyboard? This will display badges showing which key you press to access each tab. Page 47 Test 2, question 3: Answer True. The Office system has many measures in place to help you share documents with people using earlier versions of Office programs.

This manual is also suitable for: Office Print page 1 Print document 48 pages. Cancel Delete. Sign In OR. Don’t have an account? Sign up! Restore password. Upload from disk. Upload from URL.

By using our site, страница agree to our collection of information through the use of cookies. To learn more, view our Privacy Policy. To browse Academia. Remember me on this computer. Enter the email address you signed up with and we’ll email you a reset link. Need an account? Click here to sign up. Download Free PDF.

Microsoft Office Training Manual. A short summary of this paper. This publication, including the student manual, instructor’s по ссылке and exercise files, or any part thereof, may not be reproduced or transmitted in any form or http://replace.me/21860.txt any means, electronic or mechanical, without prior written permission of EZ-REF Courseware. All other products or brand names mentioned are trademarks or registered trademarks of their respective holders.

Any persons or businesses mentioned in the text of this manual are strictly fictitious. Any resemblances to existing or deceased persons, or existing or defunct businesses, is entirely coincidental. This is not a step-by-step microsoft office access 2007 training manual pdf free download. Our feeling is that you did not pay to have someone stand in front of class and read you something that you could do on your own.

Through our own classroom experience we have discovered that students don’t read detailed descriptions and that lengthy text is ignored. They prefer to explore and try things out. In typical tutorials, students often get lost following rote procedures and get caught in error conditions from which they can’t back out of.

Besides, once students leave class, they just want something they can use to look up a subject quickly without having to read through an entire tutorial.

Our design ensures that each course is stimulating and посетить страницу источник yet covers the outlined objectives.

The left page of your manual is designed for note-taking. That way, you won’t have to switch between your notebook and a manual whenever you need to look up how to perform an operation.

Keys and commands that you need to press are displayed as icons such as E or Z. Each topic starts on a new page, making things easy to find and follow. In addition, topics covering actual commands always begin with the USAGE section where we explain the microsoft office access 2007 training manual pdf free download of the command. Although you will usually be using the mouse to make your selections there are also shortcut keys that can udemy – adobe indesign – advanced free used at times so we will also include those.

Any keyboard shortcuts will be displayed with a keyboard icon while mouse shortcuts will include a picture of the mouse icon. The next page shows how взято отсюда typical topic will be discussed and each part found in the book.

Since MS Office applications were all written to be used microsoft office access 2007 training manual pdf free download with a mouse, there will be many tools that will be mentioned which can be used in place of the menu or keyboard. This section lists the keystrokes or function keys the user may press as a shortcut for performing the current command.

NOTE: This box will mention things to watch out for. The writing icon in the left column always indicates an important note to remember. TIP: This box will let you in on a little secret or shortcut. The pointing hand always indicates a “TIP”. If you have assigned a shortcut to your desktop, double-click on ссылка Microsoft Подробнее на этой странице Word icon to run the application.

Although the quickest way of running Word is obviously through the desktop, you can also access the Start menu which allows you to locate any program available on your system. The screen can be quite intimidating the first time you see it as there are so many items displayed on it.

However, if you take a few minutes to familiarize yourself with the various screen elements, the program will become easier to work with. Along the top left corner of the screen is the Office Button which provides quick access for creating, opening, converting, saving, printing, preparing, sending, publishing, and closing files. Recently accessed documents are also listed under this button.

This button provides the only true menu within Word or any other MS Office application. Click on the button to the right of these microsoft office access 2007 training manual pdf free download to customize this Quick Access Toolbar. The name of current document followed by the application name is displayed in the middle.

The second line contains a new feature within Word There are tabs located on this line which are used to access a series of Ribbons to help you quickly find the commands needed to complete a task. Commands are organized in logical groups that are collected together under these tabs.

Each tab on the Ribbon relates to a type of activity, such as inserting an object or laying out a page. To reduce screen clutter, some tabs are shown only when they are needed. There is no way to delete or replace the Ribbon with the toolbars microsoft office access 2007 training manual pdf free download menus from previous versions of Microsoft Office.

However, you can minimize the Ribbon to make more space available on the screen. If you prefer using the mouse, point to an empty space just to the right of the last tab across the top microsoft office access 2007 training manual pdf free download your screen and click the [RIGHT] mouse button.

From the pop-up menu, choose Minimize Ribbon. If you prefer using your mouse, point just to the right of the last tab and click your [RIGHT] mouse button. From the pop-up menu, again choose Minimize Ribbon this time to de-select it.

Use the A key to access the ribbon directly from the keyboard. Each time you press A, Word displays corresponding letters for the ribbon items to help you to continue using keyboard shortcuts to select them. Along the right side of the screen is the scroll bar used to quickly move vertically within your document. Use the arrows located across the top and bottom of the scrollbar to move up and down. To move more quickly, drag the small rectangle located within the scroll bar to the desired location up or down.

If you zoom to a larger size than can fit horizontally within the window, a horizontal scroll bar will appear across the bottom of the screen. Microsoft office access 2007 training manual pdf free download actual typing area is the large interior portion of the window that the program uses to display its data and special symbols. In Word, this working section is referred to as the Text Area. Within the text area you should see a small blinking vertical line, referred to as the Insertion Point or cursor.

It marks the spot where your next typed character will appear. You should also see an I-beam which indicates where the mouse pointer is located. As you move the mouse to the Ribbon area at the top of the screen or along the left or right edges of the document, it will change into the shape of an arrow.

The arrow is used to point to items within the Ribbon or to select lines of text. Just below and to the left of the vertical scroll bar is the Zoom Area.

Notice you can click on the increase or decrease buttons to change the zoom factor. You can also drag the slider horizontally to change the text size as it appears on the screen. Word displays the current percentage just to the left of this пусть birth of the federation windows 10 download этого. To the left of the zoom area are five View Icons. These are used to change the current page for display purposes.

Simply click on the view you want to switch to. The far left side of this line contains the Status Bar. This section indicates the current typing position, how many words have currently been entered in the document, and provides information on proofing tools. To make working with multiple documents less confusing, Word displays all opened documents along the taskbar at the very bottom of the screen.

Rather than having to access the Ribbon labeled View to switch between opened windows, you can simply use your mouse to click on the name of the по этому сообщению you want to access directly on the taskbar. Once selected, that document becomes the active window. Help can be as microsoft office access 2007 training manual pdf free download as explaining how to print within the program or as specific as detailing each item within a dialog box.

To display help in any of the applications, simply microsoft office access 2007 training manual pdf free download on this tool located on the far right side of the tabs and just продолжить чтение the Ribbon. When done, press E. Word will search through its help http://replace.me/536.txt and replace the current list with a group of topics related to the microsoft office access 2007 training manual pdf free download you entered.

There are several buttons across the top of the help window: If you have been moving between help topics, click on the back arrow button to return to the previous help topic. If you have returned to a previous help topic, click on the forward arrow button to display the next topic. If you are viewing a topic online and it is taking a long time to load, click on this button to cancel the help page.

Click on this button to refresh the help window. Click on this button to return to the original help topic list. Click on this button to print the current help topic. A task pane will be opened along the left side of the window, listing all of the help topics and allowing you to scroll through them.

Click on this button a second time to close the task pane. Click on this button to keep the current help topic on top. Click on the down arrow beside this button to select the type of больше на странице topic you would like displayed.

Click on this button to specify whether you want to search for microsoft office access 2007 training manual pdf free download help or display only the offline topics that come with MS Word.

This comes in handy when a screen lists several choices or perhaps lists various keyboard shortcuts. Click on this tool to print the current help topic. A dialog box containing two tabs will be displayed: The first tab labeled General is divided into three main sections, as discussed below: Select Printer This section is used to select the printer.

There is also a checkbox to print the topic to a file.

Overview of Microsoft Access Databases 3 Chapter 1 Guided Exercise 1. Download the textbook data files and double-click the replace.me file to open it in Microsoft Access If you do not have the version of Microsoft Access installed, it may not open the database file. 2. If you have assigned a shortcut to your desktop, double-click on the Microsoft Office Word icon to run the application. Although the quickest way of running Word is obviously through the desktop, you can also access the Start menu which allows you to locate any program available on your system. MS Access 1 Microsoft Access is a Database Management System (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the professional and higher editions.

В «ТРАНСТЕКСТЕ» сбой. – «ТРАНСТЕКСТ» в полном порядке. – Вирус.

This means more options are available for the group. Page 12 Preview before you select Are you familiar with the try-undo-try cycle? Animation: Right-click, and click Play. Now you can see a live preview of your choice before you make a selection, which saves you time and gives you better results. Page 13 Preview before you select Are you familiar with the try-undo-try cycle? Page 14 Quick Access Toolbar. Page 15 You can easily add them to the Quick Access Toolbar.

Page 16 Working with different screen resolutions Everything described so far applies if your screen is set to high resolution and the program window is maximized.

These commands are used frequently, so they logically appear on the first tab of the Ribbon. Of course, you can add them to the Quick Access Toolbar if you want.

Page 21 Test 1, question 2 You move from a computer with a high screen resolution to one with a low resolution. What do you do? Click the View tab. Page 22 Test 1, question 2: Answer Click the arrow on the group button. Page 23 Lesson 2 Answers to critical questions Page 24 Ribbon and see what else is new. Page 25 What happened to the File menu? The Microsoft Office Button appears in the upper-left corner of the window in several Microsoft Office programs, such as Word and Excel.

But the button offers more commands than the File menu did. Page 26 In previous versions of Office programs you could set options in the Options dialog box, which you opened through the Tools menu. Many of those options can now be found when you click the Microsoft Office Button. Or to jump-start your authoring work, look on the left. The far right section displays a preview of the currently selected template.

To preview a template before actually selecting it, click on its name within the middle section of the window and then look to the right side of the window for a preview. Once you decide which template you would like to use, highlight its name and then choose. The new document will be created – based on the template you have selected. Simply click on the document you want to switch to and that file will become the active window. Doe, I am writing on behalf of my company to thank you for the work your accounting firm did for us last month during our audit.

Because of your experience in the matter along with detailed record-keeping on our part, we passed with flying colors. What could have been a stressful situation turned out to be quite simple.

Your firm is largely responsible for that outcome. Thank you again for your assistance. I hope that our companies can continue to do business in the future.

Select Open from the Office menu. The following dialog box will be displayed: Along the left side of the dialog box, Word displays the Navigation Pane. You could then select the folder containing your Word documents. Across the top of the window are the following buttons: Click on this button to access the Organize pull-down menu.

From the resulting pull-down list, select the operation e. To change the display of the files, click on the down arrow beside this button. Click on this button to create a new folder. If you click on the down arrow beside the button, you can choose from a list of options such as opening the file as read- only or in your Web browser. TIP: To open more than one file at a time, select the first file by clicking on its name once to highlight it.

Next, hold the C key down as you click on each additional file to be opened. Once all files have been selected, click on to actually open them. Each file will be placed in its own window. Z Moves one line up. Y Moves one line down. Q Moves one character to the left.

R Moves one character to the right. O Displays the previous screenful. N Displays the next screenful. To scroll through the document using the mouse, click on one of the arrows located on either the horizontal or vertical scroll bar. If you drag the scroll box on the vertical scroll bar up or down, Word will display the current page number to the left of the box.

When you see the desired page, release the mouse button and that page will be displayed. If you are using a mouse with a scroll wheel, roll the rubber wheel located between the [LEFT] and [RIGHT] mouse buttons forward or back to quickly scroll through large documents.

NOTE: If you are using the mouse to move through a document, remember that you must click on the new page before the cursor will move to the new location! The top one moves to the previous page while the bottom icon moves to the next page. Click on this button located between the previous and next page icons to change the method by which the previous and next buttons will navigate through your document.

For example, you can set them to move from one graphic picture to another rather than from page to page. Once you click on the Select Browse Object button, a pop- up box appears: Each icon within this box represents a type of object available within a Word document.

The object you select will be used to browse through the document. For example, if you select the table object, the previous and next buttons will go to the previous or next table within your document. The previous and next buttons change color to blue if you select anything other than page the last icon on the first line of the box as the object.

You can see the description of each icon as your mouse hovers over an icon. If you click on the left side of the status line where the current page number and section are displayed located at the bottom of your screen , Word will ask what page to “Go To”. Works like a correctable backspace on a typewriter. Line Move the Insertion Bar to the left of a line until it changes to an arrow. Click once.

Sentence Hold the F key down and click the mouse button anywhere on the sentence. Paragraph Move the Insertion Bar to the left of a line until it changes to a pointer arrow. Triple-Clicking on a paragraph also selects it. Any Text Move the Insertion Bar to the beginning of the block you want to delete. Click and drag. Entire File Move the Insertion Bar to the left of a line until it changes to a pointer arrow. Hold C down and click once. Triple-Clicking on the left side of the screen also selects the entire file.

You can also use this button located within the Editing section of the Home Ribbon to select items. The pull-down list includes options for selecting everything within the document, graphic objects, or text with similar formatting. Undo instructs the program to disregard the last action whether it was deleting, copying, or applying format changes.

It is important to understand, however, that certain actions such as printing and saving cannot be undone. Word has the capability of remembering not only the last action performed but the last several. Click on the Undo tool to undo the last action. If you click on the down arrow to the right of the tool , you can scroll through the last several actions.

Move your mouse down the list to highlight the number of actions to undo. They must be done in sequence! Click on this button to redo the last undo. The Redo button shown above changes from Redo to Repeat depending on what action was last performed. This is called formatting. Formatting the text means setting the font and size of the letters, and emphasizing words using such attributes as bold, underline or italics.

Click on the down arrow beside the tool to change the style and color. When you select a block of text, Word displays a semitransparent toolbar called the Mini toolbar. The Mini toolbar helps you work with fonts, font styles, font sizing, alignment, text color, indent levels, and bullet features. When you see the transparent toolbar appear, simply point to the attribute you want to set and select it with your mouse.

To change fonts, you select the new font by its name. Notice how Word displays a sample of each font within the pull-down list so that you can see the font before actually selecting it.

Begin typing your text. NOTE: Notice that Word displays the current theme fonts along with the last few selected fonts at the top of the list for easy access. NOTE: To change existing text, be sure to select the text first and then choose the desired font.

If text is selected, as you scroll through the list of available fonts, Word will display the selected text with the currently highlighted font — as a preview. NOTE: As was the case with attributes, to change existing text, be sure to select the text first and then choose the desired font size. You can also use the following tools both of which are located within the Font section on the Home Ribbon to quickly increase or decrease the font size.

Click on this tool to increase the current font size. Click on this tool to decrease the current font size. Select the new margin setting from the list provided. If you need a margin setting that is not included in this pull-down list, click on Customize Margins….

Select the page orientation from the two diagrams provided. Select the paper size you would like to use. Word is capable of aligning paragraphs, as shown below: Word is automatically set for left alignment. To change the alignment, place your cursor anywhere on the paragraph and select one of the following tools located on the Home Ribbon : Left Aligned Centered Right Aligned Full Justification TIP: Typically the last line of a paragraph is shorter than the rest of the paragraph and may not be justified.

However, if the line is very short, there may be large gaps between words. If you have a shortcut on your desktop, double-click on the Microsoft Office Excel icon to run the application. Although the quickest way of running any MS Office application is obviously through the desktop, you can also access the Start menu which allows you to locate any program available on your system.

You will notice that the program window includes many of the standard elements common to other Office applications as well as a few items that are unique to Excel. The screen can be quite intimidating the first time you see it as there are so many items displayed. Along the top left corner of the screen is the Office Button which provides quick access for creating, opening, saving, printing, preparing, sending, publishing, and closing files.

This button provides the only true menu within Excel The name of current workbook followed by the application name is displayed in the middle of this line. A generic name is given to each new workbook you create Book1. The second line contains a new feature within Excel Each time you press A, Excel displays corresponding letters for the Ribbon items to help you to continue using keyboard shortcuts to select them. Along the right side of the screen is the scroll bar used to quickly move vertically within your workbook.

There is also a horizontal scroll bar that you can use to move left and right through your workbook. As mentioned, columns are lettered and rows are numbered. The first 26 columns are lettered A through Z. Excel then begins lettering the 27th column with AA and so on. In a single Excel worksheet there are 16, columns lettered A-XFD and 1,, rows numbered The highlighted borders around the document window indicate the columns and rows and are used to identify where on the worksheet you are located since you obviously cannot see an entire worksheet of this size on the screen at one time.

The worksheet itself is located to the right and beneath the borders. This is where you will actually be working and entering information. The outlined cell the one with the dark borders within the worksheet is referred to as the active cell. Each cell may contain text, numbers or dates. You can enter up to 32, characters in each cell. Towards the bottom of the worksheet is a small Tab that identifies each sheet within the workbook file.

If there are multiple sheets, you can use the tabs to easily identify what data is stored on each sheet. For example, the top sheet could be “Expenses” and the second sheet could be called “Income”. When you begin a new workbook, the tabs default to being labeled Sheet1, Sheet2, etc. Along the bottom of the screen is another bar called the Status Bar.

This bar is used to display various information about the system and current workbook. The left corner of this line lists the Mode Indicator which tells you what mode you are currently working in. Just below and to the left of the vertical scroll bar is the Zoom section. Excel displays the current percentage just to the left of this area. To make working with multiple workbooks less confusing, Excel has included a feature which automatically displays all opened workbooks along the taskbar.

Rather than having to access the Ribbon labeled View to switch between opened files windows , you can simply use your mouse to click on the name of the file you want to access directly on the taskbar. Once selected, that file becomes the active window. R Moves pointer right one column. Z Moves pointer up one row. Y Moves pointer down one row. O Moves one full screen up. N Moves one full screen down.

You must know the cell address. Click in this box and type in the cell address to go to. You must press E when done. You can also use the vertical down the right and the horizontal along the bottom scroll bars to move.

Drag the box in the scroll bar to move more quickly. The pointer does not move until you click in the cell to move to. Remember to look at the formula bar for the current cell address. If you are using a mouse with a scroll wheel, roll the rubber wheel located between the [LEFT] and [RIGHT] mouse buttons forward or back to quickly scroll through large worksheets.

Excel lights up column and row headings as you move from cell to cell. This helps to distinguish the current cell address. This tool displays Page Layout view. This tool displays Page Break Preview. In addition to the three views discussed above, you can create your own custom views discussed in the advanced manual. A small dialog box will open allowing you to choose from a list of saved views.

You can clear the Office menu, tabs and current Ribbon from your screen so that you can see more of your worksheet. To redisplay the screen items, press X. Click in the cell you want to store the data in and then simply begin typing the word s , number or formula. If you make a mistake and want to start over, press X.

Notice as you type, the entry is displayed both in the cell and in the formula bar. A thin, blinking cursor appears to the right of the entry and moves as you type. You cannot use the arrow keys at this time to make corrections! Pressing an arrow key at this point will enter what you have typed in the cell and then automatically move the pointer in the direction of the arrow key you pressed. Two symbols also pop up to the left of the formula bar.

The X is used like the X key to cancel. When entering text, words are automatically left aligned within the cell while numbers are placed to the right. While entering columns of numbers, the column heading may not align correctly with the values. If text is wider than the cell it is stored in, it will appear to “spill” into the adjacent cell s , providing they are empty. R Moves the cursor to the right one character.

Q Moves the cursor to the left one character. In those instances it would make sense to delete the contents of the selected cell s. A single cell may contain one or more of the following: Formats Includes fonts, bold, borders surrounding the cell s , as well as, number formats e. Contents The data stored within the cell numbers or text. Comments Can be attached to a cell to explain the reasoning behind its entry e. These comments are usually not printed.

Choose what you want to clear from the pull-down list provided. Click on this tool located towards the top left corner of your screen to undo the last action. Click on this tool located towards the top left corner of your screen to redo the last undo. While you may not require the entire worksheet, you may need to work on a Block of cells.

A block includes any group of cells in a rectangular format, as shown in the illustration below. Every block of cells has a beginning and ending address. The beginning address is the address of the cell in the top-left corner of the block whereas the ending address is the cell in the lower-right.

Normally, in the English language we use a dash to indicate a block of numbers, as in pages Excel, however, requires that you use the colon between the beginning and ending addresses.

Remember that the dash represents subtraction in spreadsheet programs. For example, the block C3:E14 refers to cells C3 through E There are many commands e. The mouse changes to the thick cross when placed in the middle of a cell. Dragging the pointer when it is this shape simply highlights cells.

If the mouse is in the shape of a diagonal arrow, you can move the contents of the currently selected cell or block of cells to another location within the worksheet. The mouse changes to a pointer only when the tip of the arrow points to one of the outer borders of the cell block.

Dragging the pointer when it is in this shape actually picks up the contents of the cell s and moves them to another location. If the mouse is in the shape of a thin cross-hair, you can fill a formula or other information into adjacent cells within the worksheet. The mouse pointer changes to a thin cross-hair only when the tip of the arrow is placed in the small square located in the bottom right-corner of a cell.

Dragging the pointer when it is in this shape fills data. The pointer’s shape should be a thick cross-hair. Click and drag to highlight. To select an entire column or row, click on the letter of the column or the number of the row. Hold the S key down and press the arrows to select a block. The entire worksheet will be highlighted. Text will appear to “spill” over into adjacent cells as long as those cells are empty. If the adjacent cells are not empty, Excel will truncate the text.

When entering large numbers, however, Excel will display the number in scientific notation if the column is not wide enough to display the entire number. However, if you apply formatting such as dollar signs , Excel will automatically adjust the column to fit the largest entry so that the number remains visible.

Make sure the mouse pointer is on the column margin line. The pointer changes to a cross-hair indicating you are on the margin line. In the example above, column F is being stretched to the right.

Notice the “cross-hair”. When creating formulas, you may use actual values, cell addresses or a combination of the two. This also ensures that formulas beginning with a cell address are not mistaken for text. The formula itself is displayed in the formula bar located in the upper-left of the screen next to the cell address. NOTE: In order to view a formula, you must select the cell in which it is stored. TIP: If you select a group of cells and look at the status bar at bottom of the screen , Excel will display the total sum of the selected cells.

However, Excel provides a mathematical function which is used primarily to add blocks of numbers. The last function you chose will be displayed on the button.

If you simply click on the button that function will be selected. To choose a different function, click on the down arrow to the right of the button and then select a new function from the list.

Once the function has been selected Excel will display the Function Arguments box, as shown below: The box will display a description of the currently selected function and list the arguments required for the function. The next required argument will be displayed in bold. This helps guide you through each step properly.

Notice as you begin entering the arguments, the palette displays the current result. When you are done, click on to actually enter the function and close the box. This is called the AutoSum feature. The second click is used to confirm the selection.

If, by chance, Excel has selected the wrong group of cells, you can highlight the correct block before clicking on the tool a second time.

The pointer should change to a thin cross-hair. When the mouse is released, the formula will be “filled” in all cells. Filling also works for text and numbers without formulas, such as months shown in the example above. Excel’s auto fill feature will fill a block of cells with either numbers or text depending on what is located in the first cell.

As you begin filling the destination cells with months, Excel will display the name of each month as it is being filled so that you know how far to fill. If you only enter a single number and then try to create a fill based on that single cell, Excel will simply copy the number down the worksheet. Once the two cells have been selected, release the mouse button. After selecting the cells to fill, click on this tool located within the Editing section on the Home Ribbon.

A pull-down list of fill options will be displayed: Select the direction of the fill or define the series to use when filling. When you click on this icon, a list of auto fill options is displayed. The default option is Copy Cells which instructs Excel to copy the data and formatting from the original cell to the destination cells. The Fill Formatting Only option is used to copy the format from the original cell to the destination cells.

This does not copy the data from the original cell. Select Fill Without Formatting to copy the data from the original cell to the destination cells without changing the existing format. NOTE: These auto fill options will vary depending on what you have just filled e. Click on the Save tool located on the Quick Access Bar. The first time you save a document, Excel provides a dialog box prompting you to enter a file name, as shown below: Letters, numbers and spaces are allowed.

In this latest version using Windows Vista, the address bar is displayed a bit differently, as shown below: The path is displayed horizontally on the bar instead of vertically as was the case in previous versions. If you want to save the workbook in another format such as another spreadsheet application or any previous version of Excel so that someone else can edit the file who does not have this version , click on the down arrow beside the box labeled Save as type and select the format from the list provided.

Enter a name for the workbook in the box labeled File name and then click on to actually save the file. Select the paper size you would like to use when printing your worksheet. Choose to either set the print area or clear it. Her employees need a robust yet flexible tool for analyzing data to make more informed decisions. Office Excel offers a comprehensive solution. Important features are organized and presented in context.

For example, when you are writing a formula to calculate a value, Office Excel displays the Formulae tab and toolset to help you in your selection. Page 10 Office Excel Some of the designer-quality formatting options include banded rows and columns for identifying key data or highlighting the last column of a table. You can see a live preview of your selection before making the final changes. Page Professional Charting Tools Shared Charting Engine Across the Microsoft Office System The improved charting capabilities in Office Excel are shared across the Microsoft Office system, which means that you can create and interact with charts the same way— Page Custom Data Output Tools Faster Formatting with Cell Styles Cell Styles offer visual previews of how a cell might look with format enhancements, so you can modify the look of a report with fewer clicks.

Page 15 www. Page Improve Spreadsheet Analysis When you apply color scales with one click, Excel uses the lowest, highest, and midpoint values in the range to determine the color scales. You can change the colors or the way Excel determines the values for the highest, lowest, or midpoint values by selecting More Options. Page Rules Manager You can change the icons or the way Excel determines the values for the icon sets, as well as pick from further icon sets, by selecting More Options.

Figure Conditional formatting icon sets Rules Manager Use the Rules Manager to work with conditional formatting when you need to: www. Page 19 Figure Enhanced filtering and sorting www. Page Easy-To-Use Pivottable And Pivotchart Views such as a SQL Server Analysis Services cube , all you need to decide is which fields to display as rows, which fields to display as columns, and which fields to display as values and in what form values can be displayed as sum, averages, or other calculations.

Page 21 PivotTable by using the chart gallery. Local and external filters It is now easier to filter data in PivotTable views.

Microsoft office access 2007 training manual pdf free download.Microsoft Access course

Table Of Contents. Quick Links. Microsoft Office Excel Table of Contents. Previous Page. Next Page. Page 3 Create a Review or Approval Workflow Microsoft office access 2007 training manual pdf free download 4: Overview Of Microsoft Office Excel Excel that is optimized for managing, consuming, and sharing spreadsheets. A microsoft office access 2007 training manual pdf free download and robust file format, Office XML Formats allow for better data integration between documents and back-end systems.

Page 5: Improve Spreadsheet Analysis Improved! Customization with Microsoft Office art, predefined styles, and integrated graphics help you apply a consistent, professional look to your spreadsheets that can easily be placed in other Microsoft Office system documents.

Improve Spreadsheet Analysis New data analysis and visualization tools help you analyze information, spot trends, and access your company information more easily. Her employees need a robust yet microsoft project standard 2019 free tool for analyzing data to make more informed decisions.

Office Excel offers a comprehensive solution. Important features are organized and presented in context. For example, when you are writing a formula to calculate a value, Office Excel displays the Formulae tab and toolset to help you in your selection.

Page 10 Office Excel Some of the designer-quality formatting options include banded rows and columns for identifying key data or highlighting the last column of a table.

You can see a live preview of your selection before making the final changes. Page Professional Charting Tools Shared Charting Engine Across the Microsoft Office System The improved charting capabilities in Office Excel are shared across the Microsoft Office system, which means that you can create and interact with charts the same way— Page Custom Data Output Tools Faster Formatting with Cell Styles Cell Styles offer visual previews of how a cell might look with format enhancements, so you can modify the look of microsoft office access 2007 training manual pdf free download report with fewer clicks.

Page Editing Report Headers And Footers Customization with Microsoft Office Art and Styles Customization with Microsoft Office art, predefined styles, and integrated graphics help you quickly apply a consistent, professional look to your spreadsheets that can easily be placed in other Microsoft Office system documents. You can apply these or other www. Page 15 www. Page Improve Spreadsheet Analysis When you apply color scales with one click, Excel uses microsoft office access 2007 training manual pdf free download lowest, highest, and midpoint values in the range to determine the color scales.

You can change the colors or the way Excel determines the values for the highest, lowest, or midpoint values by selecting More Options. Page Rules Manager You can change the icons or the way Excel determines the values for the icon sets, as well as pick from further icon sets, by selecting More Options. Figure Conditional formatting icon sets Rules Manager Use the Rules Manager to work with conditional formatting when you need to: www.

Page 19 Figure Enhanced filtering and sorting www. Page Easy-To-Use Pivottable And Pivotchart Views such as a SQL Server Analysis Services cubeall you need to decide is which fields to display as rows, which fields to display as columns, and which fields to display as values and in what form values can be displayed as sum, averages, or other calculations.

Page 21 PivotTable by using the chart gallery. Local and external filters It is now easier to filter data in PivotTable views. This is effective in cases where it would be tedious to select the individual items manually. It is also useful when the set is defined by a business rule. For instance, Top Sellers can change on a daily basis.

You can permit others to view the entire spreadsheet or only parts of it. In addition, you can help: www. The file formats have open, published format specifications that any technology provider can microsoft office access 2007 training manual pdf free download to integrate Microsoft Office system documents into their solutions.

Because the file читать статью are compressed, they result in substantially smaller file sizes than with previous versions перейти на источник Excel, Word, and PowerPoint, thereby reducing storage and bandwidth requirements.

A reference to the data connection file is added to the Office Excel spreadsheet. When the spreadsheet is executed in Excel На этой странице, the server checks the connection in the library to see if it has www. Page Report Management Features Report Management Features Office Excelcoupled with Excel Services and Office SharePoint Serveroffers important report microsoft office access 2007 training manual pdf free download features to help ensure people can view the data they need while enhancing protection of the underlying proprietary information.

When you publish a document to Office SharePoint Serveryou can control whether the viewer sees an entire spreadsheet, specific sheets within a spreadsheet, or charts, tables, PivotTable views, and Named Ranges within нажмите чтобы прочитать больше spreadsheet. The workflow creates a task for each participant and notifies them with an e-mail message of a new http://replace.me/10121.txt for review. When participants receive the notification and open the spreadsheet, they can complete their review and indicate their status on a workflow completion form.

Using Office Excelyou can upload documents to this repository directly from the application. As a result, you have greater control and management over your spreadsheets. Page Information Management Policies As a result, you can add an extra layer of security to your spreadsheets by designating access to them. For example, if you only want to allow a certain department access to spreadsheets, you can easily define the spreadsheets to require the correct credentials.

Page Summary Summary Microsoft Office Excel delivers the Office Fluent interface that presents the relevant tools you need when you need them. New formatting tools, new charts, expanded row counts, and Page Layout View will enable you to create better and bigger spreadsheets faster.

Page System Requirements Microsoft Corporation on the issues discussed as of the date of publication. Because Microsoft must respond to changing market conditions, this document should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information presented after the date of publication. This manual is also suitable for: Office excel Print page 1 Print document 37 pages.

Cancel Delete. Sign In OR. Don’t have an account? Sign up! Restore password. Upload from disk. Upload from URL.

Он сел в кровати. – Нуда, конечно… С удовольствием. Беккер достал блокнот.

Задействованная ею программа была написана на языке программирования Лимбо, который не был его специальностью. Но ему хватило одного взгляда, чтобы понять: никакая это не диагностика. Хейл мог понять смысл лишь двух слов. Но этого было достаточно.

Дэвид шутил, что она может стать первой моделью для рекламы купальников, имеющей докторскую степень по прикладной математике и теории чисел. Через несколько месяцев оба начали подозревать, что обрели нечто такое, что может продлиться всю жизнь. Они были вместе уже два года, когда Freee вдруг сделал ей предложение. Это случилось во время http://replace.me/18197.txt на уик-энд в Смоки-Маунтинс.

[PDF] Microsoft Access course.Microsoft office access 2007 training manual pdf free download

MS Access 1 Microsoft Access is a Database Management System (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the professional and higher editions. Microsoft Office Microsoft Access 2. Click the Office Button followed by New to open the Blank Database pane on the right-hand side in the window. 3. Enter a meaningful File Name: for the database. For example Kites [ would make sense as this is the type of information that the database will. If you have assigned a shortcut to your desktop, double-click on the Microsoft Office Word icon to run the application. Although the quickest way of running Word is obviously through the desktop, you can also access the Start menu which allows you to locate any program available on your system. View and Download Microsoft 76H – Office Ultimate training manual online. User Guide. 76H – Office Ultimate software pdf manual download. Also for: Office Download your FREE Microsoft Office Training Manuals Today. Everyone knows the best things in life are free. That’s why we’ve made our entire library of Microsoft Office training manuals available for you to download completely free of charge. Our comprehensive resources include manuals for Word, Excel, PowerPoint, Access, Project & Visio Estimated Reading Time: 40 secs.
Take advantage of this course called Microsoft Access course to improve your Database skills and better understand Access.. This course is adapted to your level as well as all Access pdf courses to better enrich your knowledge.. All you need to do is download the training document, open it and start learning Access for free.. This tutorial has been prepared for the beginners to help them. Overview of Microsoft Access Databases 3 Chapter 1 Guided Exercise 1. Download the textbook data files and double-click the replace.me file to open it in Microsoft Access If you do not have the version of Microsoft Access installed, it may not open the database file. 2. Microsoft Office Microsoft Access 2. Click the Office Button followed by New to open the Blank Database pane on the right-hand side in the window. 3. Enter a meaningful File Name: for the database. For example Kites [ would make sense as this is the type of information that the database will. If you have assigned a shortcut to your desktop, double-click on the Microsoft Office Word icon to run the application. Although the quickest way of running Word is obviously through the desktop, you can also access the Start menu which allows you to locate any program available on your system. Download your FREE Microsoft Office Training Manuals Today. Everyone knows the best things in life are free. That’s why we’ve made our entire library of Microsoft Office training manuals available for you to download completely free of charge. Our comprehensive resources include manuals for Word, Excel, PowerPoint, Access, Project & Visio Estimated Reading Time: 40 secs.

When you publish a document to Office SharePoint Server , you can control whether the viewer sees an entire spreadsheet, specific sheets within a spreadsheet, or charts, tables, PivotTable views, and Named Ranges within a spreadsheet. The workflow creates a task for each participant and notifies them with an e-mail message of a new document for review. When participants receive the notification and open the spreadsheet, they can complete their review and indicate their status on a workflow completion form.

Using Office Excel , you can upload documents to this repository directly from the application. As a result, you have greater control and management over your spreadsheets. Page Information Management Policies As a result, you can add an extra layer of security to your spreadsheets by designating access to them.

For example, if you only want to allow a certain department access to spreadsheets, you can easily define the spreadsheets to require the correct credentials.

This manual is also suitable for: Office excel Print page 1 Print document 37 pages. Cancel Delete. Sign In OR. Don’t have an account? Sign up! Restore password. Upload from disk. Upload from URL. Page 20 Test 1, question 1: Answer On the first tab. These commands are used frequently, so they logically appear on the first tab of the Ribbon. Of course, you can add them to the Quick Access Toolbar if you want. Page 21 Test 1, question 2 You move from a computer with a high screen resolution to one with a low resolution.

What do you do? Click the View tab. Page 22 Test 1, question 2: Answer Click the arrow on the group button. Page 23 Lesson 2 Answers to critical questions Page 24 Ribbon and see what else is new. Page 25 What happened to the File menu? The Microsoft Office Button appears in the upper-left corner of the window in several Microsoft Office programs, such as Word and Excel. But the button offers more commands than the File menu did.

Page 26 In previous versions of Office programs you could set options in the Options dialog box, which you opened through the Tools menu. Many of those options can now be found when you click the Microsoft Office Button. Or to jump-start your authoring work, look on the left. Under Microsoft Office Online, click Featured, and choose from the catalog of links to online templates and training courses. Page 28 What about favorite keyboard shortcuts?

Page 29 What about favorite keyboard shortcuts? The new shortcuts also have a new name: Key Tips. The picture shows an example of using Key Tips to remove a heading style in Word.

Press H to select the Home tab. Press E to select the Clear Formatting button in the Font group to remove the heading style. Page 30 What about favorite keyboard shortcuts? What about the old keyboard shortcuts? Keyboard shortcuts of old that begin with CTRL are still intact, and you can use them as you always have.

Page 33 What about the new file formats? Word , Excel , and PowerPoint use new file formats. Page 34 What about the new file formats? For example, in Word, a document is now saved by default with the extension.

Page 35 Working with files from earlier versions You may be the first in your group to get the Office system. Or you may work with departments that need to use Office documents saved in an earlier format. This button allows you to further specify how the document will be printed. You will be taken to a dialog box where you can define Once all printer options have been set, choose to have Excel begin printing the document.

Create a second formula in cell G2 which calculates the percentage of the objective and then add totals at the bottom of the table for each of the three months. If, however, you are in the midst of working with one file and then decide to create another workbook, you will need to instruct Excel as to what type of new document you want to create. A template is used to determine the basic structure of the workbook and can contain predefined settings, such as formulas, formatting, and macros.

The far left section contains a list of available template categories that you can base your new workbook on. The new workbook will be created – based on the template you have selected. Choosing to open a file will place the requested workbook in another window so that more than one file can be open at the same time.

You can then switch between the opened workbooks using the taskbar across the bottom of your screen or by accessing the View Ribbon. The following dialog box will be displayed: Along the left side of the dialog box, Excel displays the Navigation Pane. You could then select the folder containing your Excel files. If you click on the down arrow beside the button, you can choose from a list of options such as opening the file as read- only or as a copy.

For example, if you have a title in cell A1 that you would like centered across several adjacent columns they must be blank , you can have Excel automatically merge the cells and then center the data in that new cell. Once selected, release the mouse button. If you select this tool a second time, Excel will remove the centering and place the data in the original cell.

This can be useful when trying to label narrow columns. Begin by selecting the cell s to be modified. Click on the Orientation tool which is located within the Alignment section on the Home Ribbon. A list of orientation choices is displayed. Select the one you want to use. If you select the same choice a second time, the cell s will revert back to the normal orientation. This can make numbers difficult to read at times and inconsistent. Excel does, however, allow you to access other built-in formats such as percentage signs, dollar signs, etc.

Select the cells to format and then choose one of the following tools located within the Number section on the Home Ribbon : Formats the current selection for currency with a dollar sign, a comma as a thousand separator and 2 decimal places. Example: 4, Each time this button is selected another decimal place is added to the selection. Decreases the number of decimal places displayed.

Each time this button is selected another decimal place is removed from the selection. Click on the down arrow beside this tool located within the Number section of the Home Ribbon to choose from a list of formats.

These formats include fonts, borders, patterns, alignment, and shading. Notice you can create a new cell style yourself or merge styles contained within another workbook. If you have a shortcut on your desktop, double-click on the Microsoft Office PowerPoint icon. Although the quickest way of running PowerPoint is through the desktop shown above , you can also open the Start menu which is located along the left side of the taskbar at the bottom of the desktop to locate any program available on your system.

You will notice that the program window includes many of the standard elements common to most Office applications as well as a few items that are unique to PowerPoint. Along the top left corner of the screen is the Office Menu Button which provides quick access for creating, opening, converting, saving, printing, preparing, sending, publishing, and closing files. Recently accessed presentations are also listed within this menu. This button provides the only true menu within PowerPoint or the other Office applications.

The name of current presentation is displayed in the middle of the Title Bar. The second line contains a new feature within PowerPoint and is called the Ribbon Bar. Each tab on the ribbon relates to a type of activity, such as inserting an object or designing a slide.

There is no way to delete or replace the ribbon with the toolbars and menus from previous versions of Microsoft Office. However, you can minimize the ribbon to make more space available on the screen. If you prefer using the mouse, point to an empty space to the right of the last tab across the top of your screen and click the [RIGHT] mouse button.

From the pop-up menu, choose Minimize the Ribbon. Each time you press A, PowerPoint displays corresponding letters for the ribbon items to help you to continue using keyboard shortcuts to select them. Below the ribbon are three window panes. Select Outline to include the actual text of each slide within this pane. Select Slide to view thumbnails of each slide within this pane. The large middle pane contains the currently selected slide and is your actual working area.

Directly beneath the working area is yet another pane which can be used to add notes to the current slide. Each presentation is based on a theme which consists of a family of fonts, colors, graphics, etc.

The third icon along the status bar indicates whether PowerPoint has detected any spelling errors. A red X indicates an error has been located. Towards the right side of the status bar are the View Icons. These icons allow you to switch to the various views – depending on what you are currently doing.

For example, normal view is best for adding graphics or editing existing objects while the slide sorter is used to quickly rearrange or delete slides within your presentation. The slide show tool is used to display a visual presentation of all of your slides using various special effects.

Just to the right of the view icons is the Zoom area. PowerPoint displays the current percentage just to the left of this area. To quickly move to the next or previous slide, PowerPoint provides buttons in the lower right side of the vertical scroll bar. The following dialog box will be displayed: Along the left side of the dialog box, PowerPoint displays the Navigation Pane.

You could then select the folder containing your presentation files. However, if you click on you can choose to display other types of files such as templates or Web pages. Once you have located the presentation you want to open, double- click on it or highlight the name of the file and click. If you click on the down arrow beside the button, you can choose from a list of options such as opening the file as read-only or opening a copy of the file.

TIP: To open more than one file at a time, select the first by clicking on its name once to highlight it. Once all required files have been selected, click on to actually open them. TIP: By default, PowerPoint lists your most recently accessed files along the right side of the Office menu so that you can quickly reopen a presentation. You can increase the number of files displayed within the Office menu to a maximum of 50 by clicking on the button within the Office menu and then choosing the Advanced set of options.

Simply click on the presentation file you want to switch to and that file will become the active window. They are most often used when presenting information to an audience. Slide shows can be instrumental in conveying your message to a group of people since graphics can help make it more understandable. You can connect your PC to an overhead projector and display the show to a large group of people or it can be used on the PC in front of a small group i.

It can either be running in the background as you speak to the group or you can add enough special effects and sound that the show itself is sufficient in conveying the point you are trying to make. Rather than simply showing the audience a set of boring slides, including animation and special effects give the presentation added appeal so that the slides hold the audience’s attention while still making a dramatic point.

It is possible to control the flow of the show using either the keyboard or the mouse. It can be a self-running demonstration or can run interactively with the audience depending on your requirements.

You can also change the sequence of the slides in the middle of the show if needed. Running a slide show displays each of the slides contained within a presentation file one at a time on the computer screen. You can determine an automatic time interval between slides being drawn on the screen or you can instruct PowerPoint that you want to manually determine the speed each of the slides is drawn.

If you run it manually, you can use the mouse or keyboard to move between slides. Another nice feature is the ability to Rehearse the times between slides by previewing the show and setting individual times for each slide of the presentation. PowerPoint will immediately begin displaying the slide show – with the first slide taking up the full screen. Click on this button located with the other slide show tools in the bottom left corner of the slide show screen to display the previous slide.

The tools are very light in color so that they do not distract from the slide show. Press Y or N to move to the next slide. Press Z or O to move to the previous slide. Press X to cancel the show. The leftmost pane is most often used to display thumbnails of each slide within your presentation while the large middle pane displays the currently selected slide.

The pane beneath the working area is used for adding and displaying slide notes. To switch between the various views, PowerPoint offers a series of buttons located along the bottom right of the screen, as shown in the diagram below: Each view has its advantages. For example, the normal view is best used to show the outline and current slide simultaneously. The slide sorter view is best used to view the entire presentation at once, rearrange the slides, copy and move slides between presentations and delete slides from the presentation.

The slide show view is best used to preview your presentation to verify the timing and transition methods between slides. Along the status bar just to the right of the viewing icons is the Zoom area.

You can also drag the slider horizontally to change the slide size as it appears on the screen. These miniature slides are spread across several rows on a single screen whenever possible.

This view is the quickest way to move slides around and delete unwanted slides. Click on this button located with the other view buttons along the bottom right side of the screen to access the Slide Sorter view. As you begin dragging a slide, a thin vertical line is displayed to indicate where the slide will be placed when you release the mouse button.

This option is also useful when working in slide view to show you what the slide will look like when printed on a black and white printer. Once you select grayscale or black and white, the ribbon changes to display various grayscale options to further customize your view. Once you have chosen grayscale or black and white, click on this button to return to color view.

These notes can be printed as a reference for the speaker to help them with the presentation as they deliver it or can be left blank and handed out to the audience so that they can write their own comments as the presentation is being delivered.

The screen changes to display the slide with an area at the bottom for notes, as shown in the diagram below: Before entering your notes, you might want to switch to a larger viewing size by clicking on the increase button located just to the right of the current zoom factor along the bottom right side of the screen. Notice along the bottom left side of the screen on the status bar that PowerPoint indicates the current slide number.

Along the bottom right side of the slide on the vertical scroll bar are two buttons which can be used to quickly move to the previous and next slide within the presentation. Click on either of these two buttons to move to the previous or next slide. Along the right side of the slide, PowerPoint displays a vertical scroll bar which can be used to move to specific slides.

PowerPoint allows you to move, copy, resize, delete and change the color of the selected object. If the object contains text, you may also edit the font and size of the text, as well as any attributes that may have been applied. Move to the edge of unfilled objects or to the middle of filled pictures. Once you see the pointer change to a four-way arrow, click the [LEFT] mouse button.

An object is selected when it has the outline of a box with small circular handles. A rotation handle appears at the top of the selected object. NOTE: If you click on an object a second time while holding S down , you will be deselecting that object. TIP: You can also click in an empty area and drag a rectangle around all the objects to select.

PowerPoint selects all objects enclosed within the rectangle. From the pull-down list, choose Select All. To unselect specific objects, hold the S key down and click the objects that you do not want to include in the group. From the pull-down list, choose Selection Pane. The right side of the screen will display a list of all the objects on the slide. You can also rename objects by double- clicking on its current name.

The reorder arrows are used to change the priority of overlapping objects. Be sure that the mouse pointer changes to the four- way arrow. Click and drag the object to its new location. Notice that as you drag the mouse, a transparent version of the object follows your mouse pointer. TIP: You can also move an object by selecting it and then clicking on located within the Clipboard section of the Home Ribbon. To paste it in a new location, click on the tool. Be sure that the mouse pointer changes to the four-way arrow.

Hold down the C key. Continue to hold the C key down while dragging the object to its new location. As you drag the object, notice that a transparent copy of the object is dragged with the mouse pointer. The original object will be copied to its new location. TIP: You can also copy an object by selecting it and then clicking on located within the Clipboard section of the Home Ribbon. To paste it, click on the tool. NOTE: Dragging the handles of a text item only serves to change the left or right margins of the text block.

This may cause the text to wrap within the margins. To undo more than one action, click on the down arrow beside the tool. To modify the default value, click on the Office button and choose located along the bottom right section of the menu. From the resulting Window, choose Advanced. Click on this tool located on the Quick Access toolbar to Redo the last action.

You can change the color of the lines surrounding an object, the fill color or pattern within the object, add shading or even apply 3D effects to some objects.

If you do not see the desired color from the list, select More Outline Colors Notice as you move your mouse over each of the options within the list, PowerPoint provides a preview of the selected object using the option you are currently pointing to.

If you do not see the desired color from the list, select More Fill Colors A gradient typically consists of two colors gradually blending from one color to the other. You can select the colors to be used as well as the intensity and the direction in which the gradient will be generated.

Textures are basically small patches of patterns that resemble real- life textures such as marble, cloth, grass, paper, wood, etc. Rather than using one of the built-in textures or patterns, you can also choose to fill an object with a custom picture. First, select the text to be edited by clicking the pointer on the text item that you want to edit. You can also select a single word or group of characters from within a text object.

To select an entire text object, click on it once. The first time you click, you will be able to edit the text or highlight just a portion of the text to be modified. If you click a second time this time on the border surrounding the text , you will select the entire text object. Do not click the second time until you see the pointer change shape to a four-way arrow. Notice that PowerPoint automatically displays a preview of each font in the list so you can see how the font looks before selecting it.

You can either create a presentation from scratch or use one of your own existing files to base the new presentation on. Using a template can save you a great deal of preparation time. The following window will be displayed: The window is divided into three sections.

The far left section contains a list of available template categories that you can base your new presentation on. Some of the templates require Internet access. The new presentation will be created – based on the template you have selected. Simply click on the presentation you want to switch to and that file will become the active window. If you click on the button, you will notice two options for saving a presentation: Save and Save As. Click on the Save button located on the Quick Access Bar.

The first time you save a presentation, PowerPoint provides a dialog box prompting you to enter a file name, as shown below: Enter a name for the presentation in the box labeled File name and then click on to actually save the file.

Click on the down arrow beside the current printer to choose from a list of available printers. Click on the button to access a second dialog box where you can customize the settings for the selected printer.

This section also contains a check box, allowing you to save the print settings to a file which can then be accessed at a later time. This can be useful when you are working on a laptop and are not connected to a printer. Print range Use this section to specify which slides are to be printed. You can print All the slides, or just the Current slide. If you had selected several slides while in the Slide Sorter View, you could choose to print the current Selection.

You can also select a Custom Show or specify a list of Slides by typing in the slide numbers to print. Enter the slide numbers separated by commas 4,7,9. If you want to print a range of slides, use a dash to indicate a continuous range for example, Slides This is the default option and is used to print the slides. Handouts Prints the slides for audience handouts. Notes Pages Also known as “speaker notes”.

Each slide is printed across the top of a page, leaving the bottom half blank for “notes”. This can be useful for jotting down notes along with the picture so that you know what you want to say. Outline View This option prints the outline which you can use to give your presentation or to hand out.

Handouts If you plan on presenting the audience with some form of handouts, consider using this section. Slides are printed 2, 3, 4, 6 or 9 per page.

This makes it easy for them to follow the presentation and to take notes. There is also an area where you can choose whether the slides are printed horizontally or vertically. Grayscale Converts all colors to shades of gray for a black and white printer. At the bottom of the Print dialog box are a series of check boxes, as discussed below: Scale to fit paper This option reduces or enlarges the printout to match the selected paper size.

This option does not affect the dimension of the slide within the presentation itself, only the print-out. Frame slides Check this box to add a thin frame around the print-outs. Include comment pages Check this box to include any comment pages you may have added. Print hidden slides If you have created hidden slides within the presentation so that they don’t appear during a slide show , use this option to print them now.

High Quality Check this box to print in the highest quality. Once you have made your selections, click. Before you add a slide, be sure the slide you want the new slide to come after is displayed. For example, if you want a new slide number 5, the current slide number 4 should be displayed on the screen. If you click on the top portion of the button you will be creating a new blank slide.

If you want to specify the layout for the new slide, be sure to click on the bottom half of the button. TIP: Notice once you are in the new slide that PowerPoint displays a series of objects in the middle of the slide which can be selected and therefore added to the new slide. Objects include tables, charts, Smart Art graphics, pictures, clip art, and media clips.

NOTE: You will not be asked to confirm the deletion! However, if you change your mind after deleting a slide, click on the button located on the Quick Access toolbar at the top of your screen.

Notice the pointer has changed to a cross-hair. Release the mouse button when you are done drawing. Use this box to specify which clip art collections should be included in your search. Use this box to specify what type of media file you are searching for. Choices include clip art, photographs, movies and sound.

This can be useful for speeding up and limiting the search for only those file types that are required. At the bottom of the task pane are some additional clip art items: Select this option to access a dialog box where you will be able to catalogue your clip art and other media into collections for easy access.

Select this option to access additional help on how to locate clip art. These icons indicate that the clip is not stored directly on your computer and is being retrieved from a different location. This icon indicates the clip comes from a Microsoft partner web site and is free to use. This icon indicates the clip comes from a Microsoft partner web site and is available for purchase.

This icon indicates the clip is unavailable. This icon will appear in the lower right corner to indicate the clip is an animated gif file. The object will be added. Once the clip art object has been placed in the file, you can manipulate it e. When you choose to cut data from any of the Office applications it is removed from the current document and placed it in the Windows Clipboard a temporary storage area.

Only the last item that was cut or copied is stored within the clipboard. The item is temporarily removed from the screen and placed in the clipboard. Click on this icon to select from a list of options that defines how the item should be pasted. These options depend on the type of content you are pasting, the application you are pasting from and the format of the text where you are pasting.

When you click on the clipboard icon from within your document, a pull-down list appears offering several formatting options. Choose from one of the following options: Keep Source Formatting Select this option to retain the original format of the item. Match Destination Formatting Choose this option to reformat the pasted item to match the format at the current location. Keep Text Only Select this option to paste the text without any format.

Set Default Paste Choose this option to access a dialog box where you can set the default format options for pasting future items within your document. This leaves the item in its original location while taking a copy of it to the new location.

The item is temporarily copied to the clipboard. The standard Windows clipboard is only able to store one item at a time. However, the Office Clipboard can store up to 24 items at a time, making it easy to collect multiple items to be pasted. If you copy a 25th item, the first item in your clipboard will automatically be removed to make room for the latest entry.

If the task pane is not automatically displayed, you can manually display it by accessing the following tool: Click on the Clipboard Task Pane Launcher located along the far left side of the Home Ribbon. If you have cut or copied several entries, a scroll bar will be placed along the right side so that you can quickly move through the items. A small icon is placed to the left of each object to indicate what application the cut or copied item was originally created in.

Move to the location to which the item s should be pasted. Click on the clipboard item to be pasted. Click on this button to clear the contents of the Office Clipboard.

А потом раздался нечеловеческий крик. Это был протяжный вопль ужаса, издаваемый умирающим зверем. Сьюзан замерла возле вентиляционного люка.

Many of those options can now be found when you click the Microsoft Office Button. Or to jump-start your authoring work, look on the left. Under Microsoft Office Online, click Featured, and choose from the catalog of links to online templates and training courses.

What about the old keyboard shortcuts? Keyboard shortcuts of old that begin with CTRL are still intact, and you can use them as you always have. Page 33 What about the new file formats? Word , Excel , and PowerPoint use new file formats. Page 34 What about the new file formats? For example, in Word, a document is now saved by default with the extension. Page 35 Working with files from earlier versions You may be the first in your group to get the Office system.

For example, Access supports the attachment data type—which lets you store documents and files as compressed attachments in your database—and multivalued fields. Page 39 What about the new file format in Access? You can open and work with. Page 40 What about the new file format in Access? Page 41 Save your Word file as a different version.

Check out your options in Excel. Use a keyboard shortcut in Excel. Page 42 Test 2, question 1 Where is the first button that you click to get to the commands to open and save your files?

In the upper-left corner. At the bottom of the Ribbon. From the resulting pull-down list, select the operation e. To change the display of the files, click on the down arrow beside this button. Click on this button to create a new folder. If you click on the down arrow beside the button, you can choose from a list of options such as opening the file as read- only or in your Web browser.

TIP: To open more than one file at a time, select the first file by clicking on its name once to highlight it. Next, hold the C key down as you click on each additional file to be opened. Once all files have been selected, click on to actually open them. Each file will be placed in its own window. Z Moves one line up. Y Moves one line down. Q Moves one character to the left.

If you drag the scroll box on the vertical scroll bar up or down, Word will display the current page number to the left of the box. When you see the desired page, release the mouse button and that page will be displayed.

If you are using a mouse with a scroll wheel, roll the rubber wheel located between the [LEFT] and [RIGHT] mouse buttons forward or back to quickly scroll through large documents. NOTE: If you are using the mouse to move through a document, remember that you must click on the new page before the cursor will move to the new location! The top one moves to the previous page while the bottom icon moves to the next page.

Click on this button located between the previous and next page icons to change the method by which the previous and next buttons will navigate through your document. For example, you can set them to move from one graphic picture to another rather than from page to page. Once you click on the Select Browse Object button, a pop- up box appears: Each icon within this box represents a type of object available within a Word document.

Click once. Sentence Hold the F key down and click the mouse button anywhere on the sentence. Paragraph Move the Insertion Bar to the left of a line until it changes to a pointer arrow.

Triple-Clicking on a paragraph also selects it. Any Text Move the Insertion Bar to the beginning of the block you want to delete. Click and drag. Entire File Move the Insertion Bar to the left of a line until it changes to a pointer arrow. Hold C down and click once. Triple-Clicking on the left side of the screen also selects the entire file.

Word has the capability of remembering not only the last action performed but the last several. Click on the Undo tool to undo the last action. If you click on the down arrow to the right of the tool , you can scroll through the last several actions.

This is called formatting. Formatting the text means setting the font and size of the letters, and emphasizing words using such attributes as bold, underline or italics.

To format characters you can either use the keyboard or the Home Ribbon. Before typing, turn on the attribute and then begin entering text. When you want to turn the attribute off you press the same key. Click on this tool to turn bold on and off. Click on this button to turn italics on and off. Click on this tool to turn underline on or off. Click on the down arrow beside the tool to change the style and color. When you select a block of text, Word displays a semitransparent toolbar called the Mini toolbar.

The Mini toolbar helps you work with fonts, font styles, font sizing, alignment, text color, indent levels, and bullet features. When you see the transparent toolbar appear, simply point to the attribute you want to set and select it with your mouse. To change fonts, you select the new font by its name. Notice how Word displays a sample of each font within the pull-down list so that you can see the font before actually selecting it. Begin typing your text. NOTE: Notice that Word displays the current theme fonts along with the last few selected fonts at the top of the list for easy access.

NOTE: To change existing text, be sure to select the text first and then choose the desired font. If text is selected, as you scroll through the list of available fonts, Word will display the selected text with the currently highlighted font — as a preview. NOTE: As was the case with attributes, to change existing text, be sure to select the text first and then choose the desired font size. You can also use the following tools both of which are located within the Font section on the Home Ribbon to quickly increase or decrease the font size.

Select the paper size you would like to use. Word is capable of aligning paragraphs, as shown below: Word is automatically set for left alignment. To change the alignment, place your cursor anywhere on the paragraph and select one of the following tools located on the Home Ribbon : Left Aligned Centered Right Aligned Full Justification TIP: Typically the last line of a paragraph is shorter than the rest of the paragraph and may not be justified.

The screen can be quite intimidating the first time you see it as there are so many items displayed. Along the top left corner of the screen is the Office Button which provides quick access for creating, opening, saving, printing, preparing, sending, publishing, and closing files. This button provides the only true menu within Excel The name of current workbook followed by the application name is displayed in the middle of this line. A generic name is given to each new workbook you create Book1.

The second line contains a new feature within Excel Each time you press A, Excel displays corresponding letters for the Ribbon items to help you to continue using keyboard shortcuts to select them. Along the right side of the screen is the scroll bar used to quickly move vertically within your workbook.

Towards the bottom of the worksheet is a small Tab that identifies each sheet within the workbook file. If there are multiple sheets, you can use the tabs to easily identify what data is stored on each sheet. For example, the top sheet could be “Expenses” and the second sheet could be called “Income”. When you begin a new workbook, the tabs default to being labeled Sheet1, Sheet2, etc.

Along the bottom of the screen is another bar called the Status Bar. This bar is used to display various information about the system and current workbook. The left corner of this line lists the Mode Indicator which tells you what mode you are currently working in.

Just below and to the left of the vertical scroll bar is the Zoom section. Excel displays the current percentage just to the left of this area. To make working with multiple workbooks less confusing, Excel has included a feature which automatically displays all opened workbooks along the taskbar. Rather than having to access the Ribbon labeled View to switch between opened files windows , you can simply use your mouse to click on the name of the file you want to access directly on the taskbar.

Once selected, that file becomes the active window. R Moves pointer right one column. Z Moves pointer up one row. Y Moves pointer down one row. O Moves one full screen up.

N Moves one full screen down. You must know the cell address. Click in this box and type in the cell address to go to. You must press E when done. You can also use the vertical down the right and the horizontal along the bottom scroll bars to move. Drag the box in the scroll bar to move more quickly. The pointer does not move until you click in the cell to move to. Remember to look at the formula bar for the current cell address. If you are using a mouse with a scroll wheel, roll the rubber wheel located between the [LEFT] and [RIGHT] mouse buttons forward or back to quickly scroll through large worksheets.

A small dialog box will open allowing you to choose from a list of saved views. You can clear the Office menu, tabs and current Ribbon from your screen so that you can see more of your worksheet. To redisplay the screen items, press X. Click in the cell you want to store the data in and then simply begin typing the word s , number or formula. If you make a mistake and want to start over, press X. Notice as you type, the entry is displayed both in the cell and in the formula bar.

A thin, blinking cursor appears to the right of the entry and moves as you type. You cannot use the arrow keys at this time to make corrections! Pressing an arrow key at this point will enter what you have typed in the cell and then automatically move the pointer in the direction of the arrow key you pressed.

Two symbols also pop up to the left of the formula bar. The X is used like the X key to cancel. When entering text, words are automatically left aligned within the cell while numbers are placed to the right. While entering columns of numbers, the column heading may not align correctly with the values. If text is wider than the cell it is stored in, it will appear to “spill” into the adjacent cell s , providing they are empty.

R Moves the cursor to the right one character. Q Moves the cursor to the left one character. In those instances it would make sense to delete the contents of the selected cell s. A single cell may contain one or more of the following: Formats Includes fonts, bold, borders surrounding the cell s , as well as, number formats e. Contents The data stored within the cell numbers or text. Comments Can be attached to a cell to explain the reasoning behind its entry e.

These comments are usually not printed. Choose what you want to clear from the pull-down list provided. Click on this tool located towards the top left corner of your screen to undo the last action. Click on this tool located towards the top left corner of your screen to redo the last undo. While you may not require the entire worksheet, you may need to work on a Block of cells. A block includes any group of cells in a rectangular format, as shown in the illustration below.

Every block of cells has a beginning and ending address. The beginning address is the address of the cell in the top-left corner of the block whereas the ending address is the cell in the lower-right. Normally, in the English language we use a dash to indicate a block of numbers, as in pages Excel, however, requires that you use the colon between the beginning and ending addresses. Remember that the dash represents subtraction in spreadsheet programs. For example, the block C3:E14 refers to cells C3 through E There are many commands e.

The mouse changes to the thick cross when placed in the middle of a cell. Dragging the pointer when it is this shape simply highlights cells. If the mouse is in the shape of a diagonal arrow, you can move the contents of the currently selected cell or block of cells to another location within the worksheet.

The mouse changes to a pointer only when the tip of the arrow points to one of the outer borders of the cell block. Dragging the pointer when it is in this shape actually picks up the contents of the cell s and moves them to another location.

If the mouse is in the shape of a thin cross-hair, you can fill a formula or other information into adjacent cells within the worksheet. The mouse pointer changes to a thin cross-hair only when the tip of the arrow is placed in the small square located in the bottom right-corner of a cell.

The pointer changes to a cross-hair indicating you are on the margin line. In the example above, column F is being stretched to the right.

TIP: If you select a group of cells and look at the status bar at bottom of the screen , Excel will display the total sum of the selected cells. However, Excel provides a mathematical function which is used primarily to add blocks of numbers. The last function you chose will be displayed on the button. If you simply click on the button that function will be selected. To choose a different function, click on the down arrow to the right of the button and then select a new function from the list.

The next required argument will be displayed in bold. This helps guide you through each step properly. Notice as you begin entering the arguments, the palette displays the current result. When you are done, click on to actually enter the function and close the box. This is called the AutoSum feature. The second click is used to confirm the selection. If, by chance, Excel has selected the wrong group of cells, you can highlight the correct block before clicking on the tool a second time.

After selecting the cells to fill, click on this tool located within the Editing section on the Home Ribbon. A pull-down list of fill options will be displayed: Select the direction of the fill or define the series to use when filling. When you click on this icon, a list of auto fill options is displayed. The default option is Copy Cells which instructs Excel to copy the data and formatting from the original cell to the destination cells.

The Fill Formatting Only option is used to copy the format from the original cell to the destination cells. This does not copy the data from the original cell. Select Fill Without Formatting to copy the data from the original cell to the destination cells without changing the existing format.

NOTE: These auto fill options will vary depending on what you have just filled e. Click on the Save tool located on the Quick Access Bar. The first time you save a document, Excel provides a dialog box prompting you to enter a file name, as shown below: Letters, numbers and spaces are allowed. In this latest version using Windows Vista, the address bar is displayed a bit differently, as shown below: The path is displayed horizontally on the bar instead of vertically as was the case in previous versions.

If you want to save the workbook in another format such as another spreadsheet application or any previous version of Excel so that someone else can edit the file who does not have this version , click on the down arrow beside the box labeled Save as type and select the format from the list provided.

Enter a name for the workbook in the box labeled File name and then click on to actually save the file. Select the paper size you would like to use when printing your worksheet. Choose to either set the print area or clear it. Choose whether you want to insert a page break, remove one, or rest all page breaks within the worksheet. Scaling This section allows you to enlarge or reduce the printout.

Not all printers will be able to use this feature. Use the Adjust to: option to reduce or enlarge the output from 10 to percent of the original size. Use the Fit to: option to specify exactly how many pages wide or tall you want the final printout to be. Paper size Provides various paper sizes to choose from. Available sizes will vary from printer to printer. Print quality Allows you to specify the resolution dots per inch for printing.

The higher the number, the better the quality – but it also takes longer. First page number Leave this option at Auto to start page numbering at the next sequential number or enter a number with which the first page should begin. In the section called Header is a pull-down list of predefined headers.

Simply click on the down arrow and choose from the list of available headers. In the section called Footer is a pull-down list of predefined footers. Simply click on the down arrow and choose from the list of available footers.

Use the following buttons to add special options: Allows you to customize the font. Some of the designer-quality formatting options include banded rows and columns for identifying key data or highlighting the last column of a table. You can see a live preview of your selection before making the final changes. Page Professional Charting Tools Shared Charting Engine Across the Microsoft Office System The improved charting capabilities in Office Excel are shared across the Microsoft Office system, which means that you can create and interact with charts the same way— Page Custom Data Output Tools Faster Formatting with Cell Styles Cell Styles offer visual previews of how a cell might look with format enhancements, so you can modify the look of a report with fewer clicks.

Page Editing Report Headers And Footers Customization with Microsoft Office Art and Styles Customization with Microsoft Office art, predefined styles, and integrated graphics help you quickly apply a consistent, professional look to your spreadsheets that can easily be placed in other Microsoft Office system documents. You can apply these or other www. Page 15 www. Page Improve Spreadsheet Analysis When you apply color scales with one click, Excel uses the lowest, highest, and midpoint values in the range to determine the color scales.

Page 19 Figure Enhanced filtering and sorting www. Page Easy-To-Use Pivottable And Pivotchart Views such as a SQL Server Analysis Services cube , all you need to decide is which fields to display as rows, which fields to display as columns, and which fields to display as values and in what form values can be displayed as sum, averages, or other calculations.

Не несет ответственности? – Глаза Стратмора расширились от изумления. – Некто шантажирует АНБ и через несколько дней умирает – и мы не несем ответственности. Готов поспорить на любую сумму, что у партнера Танкадо будет иное мнение. Что бы ни произошло на самом деле, мы все равно выглядим виновными.

– Попробуем еще… Кухня. – Спальня, – без колебаний отозвался. Сьюзан смутилась.

Download your FREE Microsoft Office Training Manuals Today. Everyone knows the best things in life are free. That’s why we’ve made our entire library of Microsoft Office training manuals available for you to download completely free of charge. Our comprehensive resources include manuals for Word, Excel, PowerPoint, Access, Project & Visio Estimated Reading Time: 40 secs. MS Access 1 Microsoft Access is a Database Management System (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the professional and higher editions. Microsoft Office Microsoft Access 2. Click the Office Button followed by New to open the Blank Database pane on the right-hand side in the window. 3. Enter a meaningful File Name: for the database. For example Kites [ would make sense as this is the type of information that the database will. Take advantage of this course called Microsoft Access course to improve your Database skills and better understand Access.. This course is adapted to your level as well as all Access pdf courses to better enrich your knowledge.. All you need to do is download the training document, open it and start learning Access for free.. This tutorial has been prepared for the beginners to help them.

Looking for:

Microsoft office access 2007 training manual pdf free download.Microsoft Access course

[PDF] Microsoft Access course.Microsoft office access 2007 training manual pdf free download

You Might Also Like

Free download sony acid pro 7.0 full free download.Interesting tutorials

Canon PRINT Inkjet/SELPHY for PC.Canon print inkjet selphy for windows 10

Download Boom 3D Desktop for Mac and Windows full version for free – ISORIVER.Experience Immersive Audio

Leave a Reply Cancel reply