Abstract: Timothy and Linda O'Leary and the Computer Information Technology Team at McGraw-Hill Higher Education offer your students a fully integrated learning program with time-tested quality and reliability. It’s theme of “Making Office Relevant” helps students understand why they need this course and these skills. Student success is assured through clear step-by-step instruction, plentiful screen captures and conceptual explanations. Each Lab, designed to be covered in 1 hour of class time, combines conceptual coverage with detailed software-specific instructions. Each Lab opens with a running case study that highlights real-world applications of each software program and leads students from problem to solution. The O'Leary Series helps students learn specific applications skills along with those that cross all Office applications, which is espeicially important in mastering this version of Office. The O'Leary Series also correlates with SimNet Online, our online training and assesment program for Office 2007.
Table of contents
Full ContentsIntroduction to Computer Essentials ObjectivesIntroductionInformation SystemsPeople SoftwareHardwareDataConnectivity, the Wireless Revolution, and the InternetIntroduction to Microsoft Office 2007ObjectivesWhat Is the 2007 Microsoft Office System?Common Office 2007 Interface FeaturesOffice Word 2007Overview of Microsoft Office Word 2007Lab 1: Creating and Editing a DocumentIntroducing Office Word 2007Viewing and Zooming a DocumentCreating New DocumentsEntering TextMoving through TextIdentifying and Correcting Errors AutomaticallySpecifying Document PropertiesSaving, Closing, and Opening FilesNavigating a DocumentEditing DocumentsFormatting a DocumentWorking with GraphicsEnhancing the PagePrinting a DocumentExiting WordFocus on CareersLab 2: Revising and Refining a DocumentRevising a DocumentMoving and Copying SelectionsControlling Document PagingFinding and Replacing TextInserting the Current DateModifying Page LayoutMore Character FormattingCreating ListsUsing Quick PartsAdding and Modifying ShapesPreviewing and Editing Multiple PagesSetting Page MarginsPrinting the DocumentFocus on CareersLab 3: Creating Reports and TablesCreating and Modifying an OutlineSaving to a New FolderHiding Spelling and Grammar ErrorsCreating a Cover PageUsing Document ThemesInserting a Blank PageApplying a Quick StyleCreating a Table of ContentsNavigating a DocumentIncluding Source ReferencesIncluding FootnotesFormatting Picture LayoutReferencing FiguresCreating a Simple TableIncluding a Table of FiguresCreating a BibliographyCreating Headers and FootersRedisplaying Spelling and Grammar ErrorsUpdating a Table of ContentsPrinting Selected PagesFocus on CareersWorking Together 1: Word 2007 and Your Web BrowserCase StudySaving a Word Document as a Web PageMaking Text ChangesChanging the Picture LayoutApplying Page ColorChanging Bullet StylesCreating a HyperlinkPreviewing the PageMaking a Web Page PublicOffice Excel 2007 Overview of Microsoft Office Excel 2007Lab 1: Creating and Editing a WorksheetIntroducting Office Excel 2007Starting Excel 2007Creating New WorksheetsEntering and Editing DataEntering TextChanging Column WidthsSaving, Closing, and Opening WorkbooksUsing Proofing ToolsDuplicating Cell ContentsWorking with FormulasInserting and Deleting Rows and ColumnsFormatting the WorksheetEntering the DatePreviewing and Printing a WorksheetExiting Excel 2007Focus on CareersLab 2: Charting Worksheet Data Improving the Appearance of the WorksheetWorking with ChartsCreating and Formatting a Pie ChartSetting File PropertiesPreparing the Worksheet and Charts for PrintingFocus on CareersLab 3: Managing and Analyzing a WorkbookCorrecting Worksheet ErrorsWorking with SheetsFinding and Replacing InformationSaving to a New FolderManaging Large WorksheetsForecasting ValuesUsing Conditional FormattingCustomizing Print SettingsFocus on CareersWorking Together 1: Linking and Embedding Between Word 2007 and Excel 2007Case StudySharing Information Between ApplicationsLinking Between ApplicationsDeciding When to Link or Embed ObjectsOffice Access 2007 Overview of Microsoft Office Access 2007Lab 1: Creating a DatabaseDesigning a New DatabaseCreating and Naming the Database FileUsing Datasheet ViewUsing Design ViewEntering and Editing DataChanging Column WidthDeleting RecordsCreating a Second TablePreviewing and Printing a TableClosing and Opening a Table and DatabaseExiting AccessFocus on CareersLab 2: Modifying and Filtering a Table and Creating a FormNavigating a Large TableCustomizing and Inserting FieldsHiding and Redisplaying FieldsCreating a Lookup FieldFinding and Replacing DataSorting RecordsFormatting the DatasheetFiltering a TableCreating and Using FormsOrganizing the Navigation PanePreviewing and Printing a FormIdentifying Object DependenciesSetting Database and Object PropertiesFocus on CareersLab 3: Querying Tables and Creating ReportsRefining the Database DesignDefining and Modifying RelationshipsCreating a FilterQuerying a DatabaseDisplaying a Totals RowCreating ReportsPreparing Records for PrintingCompacting and Backing Up the DatabaseFocus on CareersWorking Together 1: Exporting DataCase StudyExporting DataOffice PowerPoint 2007Overview of Microsoft Office PowerPoint 2007Lab 1: Creating a PresentationIntroducing Office PowerPoint 2007Developing New PresentationsViewing the PresentationEditing a PresentationSaving, Closing, and Opening a PresentationChecking SpellingWorking with SlidesRehearsing a PresentationFormatting Slide TextWorking with GraphicsPreviewing and Priinting the PresentationExiting PowerPointFocus on CareersLab 2: Modifying and Refining a PresentationReplacing TextCreating a Simple TableModifying and Creating Graphic ObjectsWorking with Text BoxesChanging the Presentation DesignWorking with Master SlidesAdding Animation EffectsControlling the Slide ShowAdding Speaker NotesDocumenting a FileCustomizing Print SettingsFocus on CareersLab 3: Using Advanced Presenation FeaturesCreating a Presentation from Multiple SourcesCreating a Chart SlideCreating an Organization ChartAdding Interest to the PresentationDelivering PresentationsPublishing a PresentationFocus on CareersWorking Together 1: Copying, Embedding, and Linking Between ApplicationsCase StudyReviewing a PresentationCopying Between ApplicationsEmbedding a PresentationCommand Summary Glossary of Key Terms Appendix: More about Office 2007 Reference 1 Reference 2 Index Word Command Summary Excel Command Summary Access Command Summary PP Command Summary Word Glossary Excel Glossary Access Glossary PP Glossary Word Appendix – More About Word Excel Appendix – More About Excel Access Appendix – More About Access Word Reference 1 – Data File List Excel Reference 1– Data File List Access Reference 1– Data File List PP Reference 1– Data File List Word Reference 2 – MCAS Objectives Excel Reference 2– MCAS Objectives Access Reference 2– MCAS Objectives
Publication Year: 2007
Publication Date: 2007-01-01
Language: en
Type: book
Access and Citation
Cited By Count: 11
AI Researcher Chatbot
Get quick answers to your questions about the article from our AI researcher chatbot