ebook img

The 2010 Stable PDF

594 Pages·2011·21.499 MB·English
Save to my drive
Quick download
Download
Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.

Preview The 2010 Stable

T h e 2010 Stable Microsoft® An IntroductIon to O f f i c e 2010 Microsoft® Word 2010 • Microsoft® Excel 2010 Microsoft® Access 2010 • Microsoft® PowerPoint® 2010 HAWKING MCCARTHY • NikAkis Copyright © Pearson Australia (a division of Pearson Australia Group Pty Ltd) 2011 – 9781442540194 - Hawking/The 2010 Stable 1st edition Hawking cover.indd 1 1/6/11 2:49:57 PM Copyright © Pearson Australia (a division of Pearson Australia Group Pty Ltd) 2011 – 9781442540194 - Hawking/The 2010 Stable 1st edition TTiittllee ppaaggee..iinndddd 11 2277//55//1111 1111::1111::4455 AAMM Copyright © 2011 Pearson Australia (a division of Pearson Australia Group Pty Ltd) Pearson Australia Unit 4, Level 3 14 Aqua c Drive Frenchs Forest NSW 2086 Ph: 02 9454 2200 www.pearson.com.au All rights reserved. Except under the condi ons described in the Copyright Act 1968 of Australia and subsequent amendments, no part of this publica on may be reproduced, stored in a retrieval system or transmi ed in any form or by any means, electronic, mechanical, photocopying, recording or otherwise, without the prior permission of the copyright owner. Microso , Windows, Word, PowerPoint, Excel, Access and/or other Microso products referenced herein are either registered trademarks or registered trademarks of the Microso Corpora on in the U.S.A. and other countries. Screen shots and icons reprinted with permission from the Microso Corpora on. This book is not sponsored or endorsed by or affi liated with the Microso Corpora on. Acquisi ons Editor: Elise Carney Development Editor: Helen Doran Produc on Controller: Barbara Honor Cover Design: Judy Elias Printed in China 1 2 3 4 5 15 14 13 12 11 ISBN: 978 1 4425 4019 4 VitalSource ISBN: 9781442540187 Every eff ort has been made to trace and acknowledge copyright. However, should any infringement have occurred, the publishers tender their apologies and invite copyright owners to contact them. Due to copyright restrictions, we may have been unable to include material from the print edition of the book in this digital edition, although every effort has been made to minimise instances of missing content. An imprint of Pearson Australia Copyright © Pearson Australia (a division of Pearson Australia Group Pty Ltd) 2011 – 9781442540194 - Hawking/The 2010 Stable 1st edition Title page.indd 2 27/5/11 11:11:49 AM C O N T E N T S Part 1 Microsoft ® Word 2010 1 Introducti on to Microsoft Word ....................................................................1 A word about Windows, Conventi ons used in this book 2 Getti ng Started ...............................................................................................3 Loading Word 2010, Elements of the screen, Entering text 3 Basic Editi ng Operati ons .................................................................................7 Moving around, Adding text, Deleti ng text 4 Saving, Opening and Printi ng ........................................................................11 Saving a document, Closing a document, Opening a document, Printi ng a document, Starti ng a new document, Exiti ng Word 2010 5 Basic Formatti ng ...........................................................................................21 Selecti ng text, Changing font, Changing font size, Formatti ng eff ects, Bolding text, Underlining text, Italicising text, Font dialog box, Aligning text, Centre-aligned text, Right-aligned text, Justi fi ed text, Line spacing, Paragraph spacing, Borders, Print preview 6 Manipulati ng Text .........................................................................................45 Cut, copy and paste, Moving text between documents, Drag and drop editi ng, Building Blocks, Deleti ng text, Undoing mistakes 7 Using Document Proofi ng Tools ....................................................................57 Spelling and Grammar Checker, AutoCorrect, Replace command, Thesaurus 8 Margins, Indents and Tabs ............................................................................69 Margins, Changing margins, Increase Indent, Decrease Indent, Bulleted list, Numbered list, Hanging indent, Tab stops, Using default tab stops, Using custom tab stops, Setti ng tab stops, Using dot leaders 9 Working with Multi ple Page Documents ......................................................89 Page breaks, Inserti ng a page break, Removing page breaks, Go To command, Find command, Print Layout view, Styles, Applying a style, Headers and footers, Inserti ng a footnote, Inserti ng a graphic, Full Screen Reading view 10 Tables .........................................................................................................115 Creati ng a table, Merging cells, Changing cell width, Formatti ng table cells, Changing table borders, Adding shading, Changing row height, Verti cally centre text, Performing calculati ons, Sorti ng a table 11 Using Mail Merge .......................................................................................129 Creati ng an address list (data source), Creati ng a main document, Performing the Mail Merge 12 Working with Templates .............................................................................147 Installed templates, Content controls, Creati ng a template 13 Document Management ............................................................................157 Displaying documents, Backing up your work, Deleti ng fi les Copyright © Pearson Australia (a division of Pearson Australia Group Pty Ltd) 2011 – 9781442540194 - Hawking/The 2010 Stable 1st edition CCoonntteennttss..iinndddd 11 2277//55//1111 1111::1122::1100 AAMM C O N T E N T S Part 2 Microsoft ® Excel 2010 1 Introducti on to Microsoft Excel .................................................................163 A Word about Windows, Conventi ons used in this book 2 Getti ng Started ..........................................................................................165 Loading Excel 2010, Elements of the screen, Workbook, Moving around, File tab, Ribbon, Getti ng help, Closing a workbook, Exiti ng Excel 3 Basic Editi ng Operati ons ............................................................................175 Entering text, Entering numbers, Cell range, Quick data entry, Editi ng data, Saving a workbook, Opening and closing workbooks, Printi ng a worksheet, Starti ng a new workbook 4 Creati ng a Formula ....................................................................................189 Formula components, Creati ng a formula, What if, AutoSum, AutoCalculate, Functi ons, Functi on wizard 5 Formatti ng Data .........................................................................................207 Cut, copy and paste, Drag and drop editi ng, Formatti ng data, Formatti ng fonts, Applying font style att ributes, Aligning data, Applying number formats, Applying date formats, Conditi onal formatti ng, Changing row heights, Applying borders, lines and shading, Format styles 6 Spreadsheet Enhancements ......................................................................225 AutoFill, Naming worksheets, Working with multi ple worksheets, Creati ng a new worksheet, Linking worksheets, Range names, Relati ve and absolute cell addressing, VLookup functi on 7 Organising Data .........................................................................................249 Formatti ng a table, Sorti ng data, Filtering data, Adding data to a table, Formulas and tables, PivotTables, Updati ng a PivotTable 8 Creati ng Charts ..........................................................................................267 Components of a chart, Creati ng a chart, Moving a chart, Resizing a chart, Updati ng a chart, Adding ti tles, Formatti ng a chart, Changing chart types, Creati ng a chart in a chart sheet, Inserti ng a data table 9 Excel Web App ...........................................................................................289 Creati ng an Excel Web App, Adding existi ng workbooks to the SkyDrive, Opening a workbook, Sharing a workbook, Workbook version history 10 Printi ng Your Worksheet ............................................................................299 Print Preview, Page orientati on, Headers and footers, Inserti ng page numbers, Inserti ng the date, Inserti ng text, Page breaks, Repeati ng ti tles, Fitti ng your worksheet on pages 11 Working With Templates ...........................................................................309 Creati ng a template, Saving your template, Opening a fi le based on a template, Editi ng a template, Using Excel supplied templates 12 Working With Macros .................................................................................319 Developer Ribbon, Macro recorder, Running a macro, Assigning a macro to a butt on Copyright © Pearson Australia (a division of Pearson Australia Group Pty Ltd) 2011 – 9781442540194 - Hawking/The 2010 Stable 1st edition CCoonntteennttss..iinndddd 22 2277//55//1111 1111::1122::1100 AAMM C O N T E N T S Part 3 Microsoft ® Access 2010 1 Introducti on to Microsoft Access 2010 .......................................................329 A Word about Windows, Conventi ons used in this book 2 Getti ng Started ...........................................................................................331 Loading Access 2010, Navigati ng around a database, A example applicati on: DVD Wizz!, Table design using table templates, Entering data, Creati ng a simple form, Creati ng a simple report 3 Tables .........................................................................................................363 Editi ng an existi ng table design, Saving the table design, Replacing data, Entering a table from scratch, Entering fi eld descripti ons, Primary Key, Adding new records, Deleti ng records, Printi ng table data, Sorti ng, searching and fi ltering 4 Relati ng Tables ............................................................................................393 Why separate tables?, The relati onal model approach, A third table: RENTALS, Relati onship types, Adding relati onships, Referenti al integrity 5 Queries .......................................................................................................409 What are queries?, A simple Select Query using a Wizard, A simple Select Query by design, Running a query, Sorti ng data using queries, Displaying fi elds in a query, Using criteria, Multi ple criteria, Queries involving more than one table, Queries involving calculated fi elds, Parameter queries, Totalling queries 6 Forms .........................................................................................................441 Building a form from scratch, Adding fi elds to a form, Multi ple editi ng of properti es, Creati ng Main/Subform forms, Query-based forms 7 Reports .......................................................................................................471 Group reports, Designing reports, Mailing label reports, Query-based reports 8 Automati ng Your Applicati ons ....................................................................489 Switchboard Manager, Adding Command butt ons Copyright © Pearson Australia (a division of Pearson Australia Group Pty Ltd) 2011 – 9781442540194 - Hawking/The 2010 Stable 1st edition CCoonntteennttss..iinndddd 33 2277//55//1111 1111::1122::1100 AAMM C O N T E N T S Part 4 Microsoft ® PowerPoint® 2010 1 Introducti on to Microsoft PowerPoint 2010 ..............................................501 A Word about Windows, Conventi ons used in this book 2 Getti ng Started ..........................................................................................503 Loading PowerPoint 2010, Elements of the screen, Saving a presentati on, Viewing a presentati on, Getti ng Help, Closing a presentati on, Opening a presentati on, Exiti ng a presentati on 3 Going It Alone ............................................................................................513 Creati ng a blank presentati on, Adding a new slide, Demoti ng and promoti ng points, Outline view, Changing the order of slides, Adding notes to slides 4 Enhancing a Presentati on ..........................................................................525 Inserti ng clip art, Resizing and moving Clip Art, AutoShapes, Design Templates, Slide Sorter 5 Displaying a Presentati on ..........................................................................537 Printi ng a presentati on, Slide Show, Slide Show transiti on, Slide Builds Copyright © Pearson Australia (a division of Pearson Australia Group Pty Ltd) 2011 – 9781442540194 - Hawking/The 2010 Stable 1st edition CCoonntteennttss..iinndddd 44 2277//55//1111 1111::1122::1100 AAMM C O N T E N T S Part 5 Integrati ng Applicati ons 1 Integrati ng Applicati ons ..............................................................................545 Building the “Sales” database, Creati ng an integrated Word memo, Mail merging the Microsoft Access data, Creati ng the Microsoft PowerPoint slide show, Adding the integrated chart Index ..................................................................................................573-575 Copyright © Pearson Australia (a division of Pearson Australia Group Pty Ltd) 2011 – 9781442540194 - Hawking/The 2010 Stable 1st edition CCoonntteennttss..iinndddd 55 2277//55//1111 1111::1122::1111 AAMM Copyright © Pearson Australia (a division of Pearson Australia Group Pty Ltd) 2011 – 9781442540194 - Hawking/The 2010 Stable 1st edition CCoonntteennttss..iinndddd 66 2277//55//1111 1111::1122::1111 AAMM Microsoft ® Word 2010 Copyright © Pearson Australia (a division of Pearson Australia Group Pty Ltd) 2011 – 9781442540194 - Hawking/The 2010 Stable 1st edition 22001100 SSttaabbllee--CChhaapptteerr OOppeenneerrss..iinndddd 11 11//66//1111 1111::1166::3344 AAMM

See more

The list of books you might like

Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.