The 2010 Stable

594 Pages·2011·21.499 MB·English

by  Hawking.;McCarthy

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