Microsoft office 2010 access training manual pdf free. MS Access 2010 Tutorial.pdf

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Start now. Download now. Get started. Get started with Tips. Work together. Check it out. Get now. See all. Watch videos. Take training.

Learn how to get more work done, from anywhere on any device with Microsoft and Windows Discover how industry professionals leverage Microsoft to communicate, collaborate, and improve productivity across the team and organization. Start here. Switch from G Suite. Quick Starts. Microsoft Accessibility Help. Office Accessibility Training. Office training. LinkedIn Learning. Learn the basics Get going quickly and easily with Microsoft video training.

Quick Starts Get up to speed in no time with these popular guides. Collaborate Do your best work together. With Microsoft , you can collaborate with anyone, anywhere. Office for the web training Learn how to stay productive in Office from any browser with these brand new courses. Cheat sheets Get up to speed fast with these quick references and keyboard shortcuts. Infographics Get inspired with cool new infographics for your favorite Office apps. For small businesses Watch these short, easy videos to help you set up Microsoft Modern workplace training Learn how to get more work done, from anywhere on any device with Microsoft and Windows More training Office training LinkedIn Learning.

Get support. Join the discussion. Buy Microsoft

 
 

Microsoft office 2010 access training manual pdf free

 

By using our site, you agree to our collection of information through the use of cookies. To learn more, view our Privacy Policy. To browse Academia. Log in with Facebook Log in with Google. 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. PDF Pack.

People also downloaded these PDFs. People also downloaded these free PDFs. Download Download PDF. Translate PDF. This publication, including the student manual, instructor’s guide and exercise files, or any part thereof, may not be reproduced or transmitted in any form or by 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 tutorial. 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 customized 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 purpose of the command. Although you will usually be using the mouse to make your selections there are also shortcut keys that can be 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 a typical topic will be discussed and each part found in the book.

Since MS Office applications were all written to be used interactively 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 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. 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 tools 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 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 just 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 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. The 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 area. 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 file you want to access directly on the taskbar.

Once selected, that document becomes the active window. Help can be as generic 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 click on this tool located on the far right side of the tabs and just above the Ribbon. When done, press E. Word will search through its help database and replace the current list with a group of topics related to the item 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.

 

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

 

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. 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. Inserts the current Page Number. Adds the Total number of pages in the printout. If you have a picture, use this to Format the Picture. If you selected a block before you entered this box, the block will already be displayed.

If not, you may enter the range as A1:B15 to specify that the block from A1 to B15 should be printed. You can enter more than one range if you separate the ranges with a comma – as in A1:B15,DF Print titles This section allows you to specify rows to be printed along the top or the columns to be printed along the left of each page.

To specify a range, click in the row or column section and then type the block. Click on this button to the right of these two sections to return to the worksheet to select the block. When done, reactivate the Page Setup dialog box. Black and white is used to print in black and white for faster printing. Checking the Draft quality option speeds up the printout by printing less graphics and suppresses the gridlines.

Check the Row and column headings box to print the row numbers and column letters around the border of the printout. Depending on your preference, you can choose to print Comments on a separate page at the end of your document or as they are displayed in the worksheet.

Page order Use this section to specify the order pages are to be printed. You can choose to print Down, then Across or Across, then Down. You should notice the button to the right side of each of the tabbed boxes.

You should also notice the button within each of the tabbed dialog boxes. If you want to see how the worksheet will print based on the current settings, click on this button.

Once you have made your selections from the various tabs, click on the button. If you do not specify otherwise, Excel assumes you want to print the entire worksheet. It is possible, though, to specify a print range. 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. Work together. Check it out. Get now. See all. Watch videos. Take training. Learn how to get more work done, from anywhere on any device with Microsoft and Windows Discover how industry professionals leverage Microsoft to communicate, collaborate, and improve productivity across the team and organization.

Our services Business bilingual secretary available to all types of businesses – Special business package November 16, Whatever your need in getting your projet done, or documents, we are experienced enough to provide you with the business communication level suitable to your need. French mother tong and proficient in english for business we are the one skilled solution at This event is unique in our department.

On this occasion, professional and Reunion Island Ideal for sporty, adventurous bon vivants. Wake up with the glow of the first rays of the sun over the mangrove forest. First a hearty breakfast with a view of the islands Nosy Carry out your projects in complete safety June 17, For all your credit or financing needs, we offer our services. The context menu in Word , for example, has been greatly improved, and lets you see changes in real time as you browse through the different options.

You can now add videos to your PowerPoint presentations, remove redundant messages from conversations in Outlook and insert small color charts inside Excel spreadsheets. There are also tools to translate text, take and use screenshots, and apply special effects to the images you use in your documents. Regarding performance, Microsoft Office Professional Academic seems to be fast and light on system resources.

There’s a significant improvement in the time the suite apps take to launch, and how they behave when working on your documents. In all, Microsoft Office Professional Academic is an excellent productivity suite with great new features that make it easier and more comfortable to use.