Microsoft Access 2010 Intermediate Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix, Inc Staff
Publisher:
ISBN: 1936220245
Release Date: 2010-10-30
Genre:

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office Access 2010. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. The following topics are covered: Table Design: Preventing Data Entry Errors, Find and Sort More Quickly With Indexing, Joining Tables to Create Relationships, Deleting a Table Join, Preventing Orphaned Data with Referential Integrity. Query Design: Performing Calculations, Summarizing Selected Data. Form Design: Adding Form Controls, Sorting, Removing Automatic Labels, Modifying Automatic Labels, Modifying Form Controls. Report Design: Summarizing by Group, Printing Options. Table Relationships. Complex Expressions Examples. Form Control. This guide is one of two available titles for Access 2010: Access 2010 Introduction and Access 2010 Intermediate.

Microsoft Excel 2010 Tables PivotTables Sorting and Filtering Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcu

Author: Beezix Software Services, Inc
Publisher:
ISBN: 1936220334
Release Date: 2011-02-18
Genre: Business

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use tables, PivotTables, sorting and filtering features in Microsoft Office Excel 2010. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. The following topics are covered: Excel Tables: Creating an Excel Table, Changing the Table Area, Adding a New Row or Column to the Table, Deleting a Table Row or Column, Turning On/Off the Total Row, Changing the Total Row, Convert a Table to a Normal Range, Using a Normal Range for Sorting, Filtering, Subtotals, and PivotTables, Removing Duplicates, Structured References in Excel Tables. PivotTables: Creating a PivotTable or PivotChart Report, Show/Hide the PivotTable Field List, Adding/Removing a PivotTable Field, Refreshing a PivotTable, Rearranging a PivotTable, Adding a PivotChart to an Existing PivotTable, Changing the Summary Function, Changing How Values are Shown, Sorting in a PivotTable, Grouping by Dates or Time, Filtering PivotTables and Charts with Slicers. Sorting & Filtering: Basic Sorting, Complex Sorting, Re-applying a Sort, Creating a Custom List, Creating a Custom List from Cell Data, Sorting Using a Custom List, Filtering and Advanced Filtering, Show/Hide AutoFilter, Searching for Filter Criteria in AutoFilter, Criteria for Advanced Filters, Using Advanced Filters/Copying Filtered Data to Another Range, Selecting /Ordering Columns, Filter/Copy Unique Rows, Clearing Filtering and Sorting, Subtotals. This guide is one of several titles available for Excel 2010: Excel 2010 Introduction; Excel 2010 Tables, PivotTables, Sorting & Filtering; Advanced & Macros; Charts & Sparklines; Functions & Formulas.

Microsoft Word 2010 Formatting Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix Software Services, Inc
Publisher:
ISBN: 1936220202
Release Date: 2010-06-15
Genre: Microsoft Word

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use formatting features of Microsoft Office Word 2010 at the intermediate level. The following topics are covered: Displaying the Ruler, Changing the Default Font, Settings Tabs, Moving Tab Positions, Removing a Tab Marker, Clearing All Tab Markers from the Ruler, Tab Tips, Setting Tabs with Leaders, Disabling Automatic Formatting, The Indent Markers, Changing Indents, Applying Indents Quickly, Creating Bulleted Lists, Changing Bullet Style, Creating Numbered Lists, Turning off Bullets or Numbering, Creating Multilevel Numbered List. Paragraph Breaks vs. Line Breaks, Changing Paragraph Spacing, Changing Line Spacing, Clearing Formatting, Using Quick Styles, Using Themes to Format the Document. Inserting a Table, Moving a Table, Inserting Rows within a Table, Adding a Row at the End of a Table, Inserting Columns within a Table, Changing Column Widths, Merging Table Cells, Splitting Cells of a Table, Centering a Table within the Margins, Changing Text Direction, Wrapping Text around Tables, Adding Space to Table Rows, Adding Paragraph/ Cell Borders and Shading, Inserting a Pre-Formatted Text Box, Drawing a Text Box, Formatting a Text Box. Finding and Replacing Text, Finding and Replacing Formats, Finding and Replacing Special Characters (Tabs, Spaces, etc.). Also includes: Lists of Table Selection Shortcuts and Formatting Shortcuts. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. This guide is one of several titles available for Word 2010: Word 2010 Introduction, Word 2010 Formatting, Word 2010 Advanced, Word 2010 Mail, Merge & Forms, Word 2010 Templates & Macros, Word 2010 Collaboration Features.

Microsoft Excel 2010 Introduction Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix Software Services, Inc
Publisher:
ISBN: 193622013X
Release Date: 2010-05-01
Genre: Business

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office Excel 2010. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. The following topics are covered: Creating Workbooks, Entering and Editing Data, Undo and Redo, Resizing Column Width and Row Height, Inserting and Deleting Rows Columns and Cells, Clearing Cells, Clearing Formatting, Formatting Numbers and Cells, Aligning and Merging Cell Contents, Borders and Grids, Viewing the Worksheet as it will Print, Entering Dates, Entering Sequences. Entering Formulas & Functions, Entering a SUM Function Quickly, Absolute vs. Relative Cell References. Copying and Moving Data: Copying to Adjacent Cells; Cut, Copy, Paste; Drag & Drop. Sheet Features: Renaming, Moving, Copying, Selecting, Inserting, Deleting Sheets. Editing Multiple Worksheets Simultaneously, Copying Data and Formatting to Multiple Worksheets. Previewing, Printing and Page Setup, Printing a Specific Area, Using Page Break Preview to Adjust Page Breaks, Repeating Rows/Columns on Every Page. Working with Previous Versions (Compatibility Mode). Also includes: Lists of Selection and Movement Shortcuts. This guide is one of several titles available for Excel 2010: Excel 2010 Introduction; Excel 2010 Tables, PivotTables, Sorting & Filtering; Advanced & Macros; Charts & Sparklines; Functions & Formulas.

Windows 8 Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Guide

Author: Beezix
Publisher:
ISBN: 1936220687
Release Date: 2012-11-19
Genre:

4-page laminated quick reference guide showing step-by-step instructions and shortcuts for how to use Microsoft Windows 8. Includes touch interface. The following topics are covered: Getting Started: Starting Windows/Login; The Start Screen; Windows Store Apps and Desktop Apps; Accessing the Desktop; Starting a Desktop or Windows Store App; Accessories (Calculator, Notepad, etc.); Switching Between Apps and Desktop Windows - Using the Switch List; Closing a Windows Store App; Closing a Desktop Window or App; Windows Charms, Using the Share Charm; Searching; Working with Multiple Monitors; Opening Files, Folders and Libraries; Saving a Document; Using the Shortcut Menu; Showing Windows Store App Commands and Navigation. Organizing Tiles & Apps: Creating a Tile Group; Naming a Tile Group; Rearranging Start Screen Tiles; Adding an App Tile to the Start Screen; Creating Secondary Tiles; Always Show a Windows Store App (Snapping). Working on the Desktop: Pinning a Desktop App to the Taskbar; Using Taskbar Jump Lists (Recently Used Files, Pinned Files, Common Tasks);Pinning Files to Taskbar Jump Lists; Switching Between Windows Using the Taskbar; Resizing a Desktop Window; Moving a Desktop Window; Making a Desktop Window Large (Maximize); Hiding a Desktop Window (Minimize); Using the Notification Area (Printing, Security, Sound, etc.). File Management: Folders, Libraries & Favorites: Starting File Explorer; Working with the Ribbon; Navigation Pane, Preview Pane & Details Pane; Changing How Items are Displayed, Changing Views, Grouping & Sorting; Navigating Folders in File Explorer; Opening a Second Explorer Window; Creating a Folder; Renaming Files or Folders; Working with Libraries; Selecting Multiple Items, Selecting with Checkboxes; Moving and Copying Files and Folders, Moving and Copying with Cut, Copy & Paste; Creating a Shortcut to a Document, Folder, or Other Item; Zipping Files or Folders; Deleting Files or Folders; Pinning to Start; Adding a Folder or Library to Favorites; Searching in File Explorer; Burning to a CD/DVD. Settings & Troubleshooting: Using the Settings Charm; Using the Control Panel; Setting up WiFi; Using Airplane Mode; What to Try if an App Freezes. Users & Security: Viewing a Password While Typing; Changing Users; Ending your Windows Session; Changing Login Password; Creating a Picture Password; Getting Help.

Microsoft Access 2010 Step by Step

Author: Joan Lambert
Publisher: Microsoft Press
ISBN: 9780735651449
Release Date: 2010-07-15
Genre: Computers

Experience learning made easy-and quickly teach yourself how to build database solutions with Access 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include building an Access database from scratch or from templates; publishing your database to the Web; exchanging data with other databases and Microsoft Office documents; creating data-entry forms; using filters and queries; designing reports; using conditional formatting; preventing data corruption and unauthorized access; and other core topics.

Microsoft Word 2010 Introduction Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix Software Services, Inc
Publisher:
ISBN: 1936220156
Release Date: 2010-06-15
Genre: Microsoft Word

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Microsoft Office Word 2010. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. The following topics are covered: Creating, Opening & Saving Documents; Working with Previous File Versions; Setting up the Page; Inserting/Deleting Text; Spacing between Paragraphs; Undo, Redo, and Repeat; Moving and Copying Text. Formatting: Changing Font, Size, Enhancements, Paragraph Alignment; Copying Formatting; Using the Mini Toolbar; Highlighter. Draft, Print Layout, Reading Views; Going to a Page; Searching Using the Navigation Pane; Creating and Editing Headers and Footers; No Header or Footer on the First Page, Inserting a Page Break. Checking Spelling, Grammar; AutoCorrect; Creating and Inserting Quick Part Building Blocks; Sending the Document as an E-mail Attachment; Saving as PDF; E-mailing a PDF; Printing Envelopes and Labels; Previewing and Printing. Also includes: Lists of Selection and Movement Shortcuts. This guide is one of several titles available for Word 2010: Word 2010 Introduction, Word 2010 Formatting, Word 2010 Advanced, Word 2010 Mail, Merge & Forms, Word 2010 Templates & Macros, Word 2010 Collaboration Features.

Microsoft Word 2010 Mail Merge and Forms Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix, Inc Staff
Publisher:
ISBN: 1936220350
Release Date: 2010-12-31
Genre:

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use mail merge and forms features of Microsoft Office Word 2010. The following topics are covered: Mail Merge: Choosing the Document Type, Recipient Lists: Creating a Recipient List in Word, Selecting an Existing Recipient List, Using Outlook Contacts, Editing an Existing Recipient List, Selecting and Sorting Recipients. Writing the Document: Creating a Label Document, Using an If...Then...Else Rule. Previewing the Merge & Merging, The Mail Merge Wizard, Highlighting Merge Fields. Forms: Showing Macro and Form Controls, Creating a Template Library in Windows 7, Creating the Template File, Inserting Content Controls, Setting Content Control Properties: Add a Title, Format Contents Using a Style, Self Destruct Plain or Rich Text, For Plain Text, For Building Block Gallery, For Combo Box and Drop-Down List, For Date Picker, For Check Box. Turning On/Off Design Mode, Changing Placeholder Text, Protecting a Form from Changes, Unprotecting a Form, Protecting Only Parts of a Form: Preventing Editing of a Control's Content, Prevent Editing Parts of a Document, Preventing Deletions. Accessing the Form to Fill it Out, Changing the Form Template. This guide is one of several titles available for Word 2010: Word 2010 Introduction, Word 2010 Formatting, Word 2010 Advanced, Word 2010 Mail, Merge & Forms, Word 2010 Templates & Macros, Word 2010 Collaboration Features.

Teach Yourself VISUALLY Access 2010

Author: Faithe Wempen
Publisher: John Wiley & Sons
ISBN: 9781118081853
Release Date: 2011-04-06
Genre: Computers

The visual way to get up to speed on Access 2010 It's one thing to gain access to Access. It's another thing entirely to figure out how to do all the things you want to do in Access, because the software is not all that intuitive. This full-color guide clearly shows you how to get the most out of Access 2010, including how to enter new records; create, edit, and design tables and forms; organize, analyze, and share data; generate concise reports; and much more. With pages of step-by-step instructions, graphics, and helpful advice, this is the visual learner's Access book-keep this on your desk and flip to what you need, any time! Explores the very latest features, functions, and tools of Access 2010, a database software tool that is part of the new Microsoft Office 2010 Teaches you how to enter new records and create, edit, and design tables and forms Explains how to organize, analyze, and share data; generate concise reports; add smart tags to tables, save backup copies of your data; and more Demonstrates through step-by-step instructions and numerous, full-color screen shots and graphics, so you can see exactly how to perform tasks This unparalleled book contains everything you need to know to use Access 2010 effectively.

Microsoft Office 2011 for Mac

Author: Steve Schwartz
Publisher: Pearson Education
ISBN: 9780132735155
Release Date: 2011-02-11
Genre: Computers

Visual QuickStart Guides, designed in an attractive tutorial and reference format, are the quickest, easiest, and most thorough way to learn applications, tasks, and technologies. The Visual QuickStart Guides are a smart choice and guide the learner in a friendly and respectful tone. Visually presented with copious screenshots, the focused discussions by topic and tasks make learning a breeze and quickly take you to exactly what you want to learn. Microsoft Office 2011 for Macintosh: Visual QuickStart Guide, written by best-selling author Steve Schwartz, has been extensively rewritten to provide expanded coverage of the core Office applications: Word, Excel, PowerPoint, and Outlook, provides in-depth instructions on many of the new features and changes introduced in Office 2011, and offers a thorough introduction to the Office Web Apps. Coverage of each application is jam-packed with information and tips that not only explain HOW to perform a task, but WHY you need this procedure and WHEN it's best to use it. Table of Contents PART I: GETTING STARTED Chapter 1: Introducing Office 2011 Chapter 2: Office Basics Chapter 3: Working with Graphics PART II: MICROSOFT WORD Chapter 4: Introducing Word 2011 Chapter 5: Document Formatting Chapter 6: Text Formatting Chapter 7: Creating Tables Chapter 8: Working in Other Views Chapter 9: Other Word Features PART III: MICROSOFT EXCEL Chapter 10: Spreadsheet Essentials Chapter 11: Modifying Worksheets Chapter 12: Formulas and Functions Chapter 13: Working with Tables Chapter 14: Charts and Graphs Chapter 15: Database Techniques Chapter 16: Sharing Workbooks PART IV: MICROSOFT POWERPOINT Chapter 17: Creating a Presentation Chapter 18: Charts and Tables Chapter 19: Wrapping up a Presentation PART V: MICROSOFT OUTLOOK Chapter 20: Introducing Outlook Chapter 21: Email Chapter 22: Contacts Chapter 23: Calendar Chapter 24: Tasks Chapter 25: Notes Chapter 26: My Day Part VI: ADVANCED TOPICS Chapter 27: Combining Office Data Chapter 28: Office 2011 and the Internet Chapter 29: The Office Web Apps Index

Microsoft Word 2010 Collaboration Features Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix, Inc Staff
Publisher:
ISBN: 193622044X
Release Date: 2012-06-07
Genre:

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use collaboration features of Microsoft Office Word 2010. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. The following topics are covered: Turning On/Off Track Changes, Tracking Table Changes, Show/Hide the Reviewing Pane, Accepting/Rejecting Changes. Inserting Comments, Reviewing Comments, Show/Hide Comments, Deleting Comments, Changing What is Shown, Showing Deletions and Moves in Balloons, Hiding Formatting Changes, Turning Off/On Tracking Formatting. Hide/Show Specific Authors, Changing Author, Forcing Landscape Printing, Comparing Two Documents: Combining Multiple Documents, Comparing with Previous Versions, Comparing Documents Side by Side. Protecting your Document, Removing Personal or Hidden Information from a Document, Restricting Editing, Blocking Others from Editing Part of a Document Stored on SharePoint, Unblocking. Sharing a Document on SkyDrive, Sending a Link to a SkyDrive Folder, Sharing a Document on a SharePoint, Co-Authoring, Using the Navigation Pane While Co-Authoring, Resolving Conflicts. This guide is one of several titles available for Word 2010: Word 2010 Introduction, Word 2010 Formatting, Word 2010 Advanced, Word 2010 Mail, Merge & Forms, Word 2010 Templates & Macros, Word 2010 Collaboration Features.

Microsoft Excel 2010 Charts and Sparklines Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix, Inc Staff
Publisher:
ISBN: 1936220423
Release Date: 2011-08-15
Genre:

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use charts/graphs and Sparklines features of Microsoft Office Excel 2010. The following topics are covered: Charts: Inserting a Chart, Creating a Chart Sheet Using the Default Chart Type, Changing Type, Resizing a Chart in the Worksheet, Changing Chart Type, Charting Non-Adjacent Data, Selecting Chart Objects, Adjusting Scale, Creating a Chart with Two Scales, Add, Move or Remove the Legend, Adding a Data Series, Removing a Data Series, Using Tables as a Data Source, Switching Rows and Columns, Adding or Removing Gridlines, Exploding a Piece of a Pie Chart, Adding Explanatory Text, Adding Visuals, Adding Data Labels, Move, Format, Edit Data Labels, Adding/Removing a Chart Title, Adding an Axis Title, Moving a Title, Using Styles and Layouts, Moving the Chart to Another Worksheet, Adding a Projection or Trendline to a Data Series, Removing a Trendline, Handling Hidden and Empty Cells, Setting the Default Chart, Creating a Chart Template, Applying a Custom Chart Type. Sparklines: Creating a Sparkline, Removing Sparklines, Grouping Sparklines, Changing Sparkline Type. Customizing Sparklines: Adding Text, Highlighting Values (Markers). Changing Marker Color, Change Sparklines Color and Weight, Customizing Axis Settings, Handling Hidden and Empty Cells. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. This guide is one of several titles available for Excel 2010: Excel 2010 Introduction; Excel 2010 Tables, PivotTables, Sorting & Filtering; Advanced & Macros; Charts & Sparklines; Functions & Formulas.

Microsoft Word 2007 Templates and Macros Quick Reference Guide Cheat Sheet of Instructions Tips and Shortcuts Laminated Card

Author: Beezix, Inc Staff
Publisher:
ISBN: 1934433594
Release Date: 2007-08-01
Genre:

Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use macros and template features of Microsoft Office Word 2007. The following topics are covered: Templates: Templates vs. Documents, Using Existing Templates, Creating New Templates, Changing which Template is Attached, Changing Defaults in the Attached Template, Changing Elements in the Attached Template, Changing the Normal Template, Making Elements Available in All Documents: Using Global Templates, Removing a Global Template, Organizing Macros and Styles in Templates and Documents, Inserting Fields with Options, Including Building Blocks in a Template, Copying Building Blocks Between Templates, Moving Building Blocks Between Templates, Creating a Custom Building Block, Creating Building Block Libraries. Macros: Recording a Macro, Naming a Macro, Renaming a Macro, Creating a Macro without Recording, Editing Macros, Running Macros, Documenting Macros, Assigning Macros to Toolbars, Shortcut keys and Menu Commands, Auto Macros, Calling Another Macro, Organizing Macros in Templates and Documents, Deleting Macros, Setting Macro Security, Getting Help on Visual Basic. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user. This guide is one of several titles available for Word 2007: Word 2007 Introduction, Word 2007 Formatting, Word 2007 Advanced, Word 2007 Mail Merge & Forms, Word 2007 Templates & Macros.

Access 2013 For Dummies

Author: Laurie Ulrich Fuller
Publisher: John Wiley & Sons
ISBN: 9781118568507
Release Date: 2013-03-14
Genre: Computers

The easy guide to Microsoft Access returns with updates on the latest version! Microsoft Access allows you to store, organize, view, analyze, and share data; the new Access 2013 release enables you to build even more powerful, custom database solutions that integrate with the web and enterprise data sources. Access 2013 For Dummies covers all the new features of the latest version of Accessand serves as an ideal reference, combining the latest Access features with the basics of building usable databases. You'll learn how to create an app from the Welcome screen, get support for your desktop databases, and much more. Includes coverage of all the new features of Access 2013, including the updated interface Shows you how to create and share reports Features special videos and materials created by the authors to help reinforce the lessons included in the book Helps you build data analysis and interface tools for your specific needs Offers plenty of techniques and tips for solving common problems Access 2013 For Dummies provides you with access to the latest version of this database tool.

Microsoft Access 2010 In Depth

Author: Roger Jennings
Publisher: Pearson Education
ISBN: 0768695236
Release Date: 2010-12-28
Genre: Computers

Access 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Access 2010, and get more done in less time. Legendary Access expert Roger Jennings provides specific, tested, proven solutions to the problems Access database users and developers run into every day: challenges other books ignore or oversimplify. Jennings thoroughly covers all facets of working with Access 2010, and adds new chapters on integration and collaboration with Microsoft SharePoint and emulating Table Triggers with Access Data Macros. New coverage also includes: customizable Ribbon and Themes; the revamped Macro Designer; Quick Start Fields; IntelliSense support in Expression Builder; Application Parts and Navigation Forms; conditional formatting and data bars in reports; and new web database publishing techniques. As with all In Depth books, Access 2010 In Depth presents comprehensive coverage, breakthrough techniques, exclusive shortcuts, quick access to information, troubleshooting help for tough problems, and real-world examples with nothing glossed over or left out. Step-by-step instructions with icons guide readers through essential tasks such as designing tables, entering data, importing external data, designing and executing queries, and designing data entry forms and printed reports. Additional chapters on advanced form and report design emphasize data entry efficiency and presentation clarity. By Roger Jennings, a world-renowned Access expert who has sold more than 1.25 million books! Covers all aspects of working with Access 2010, from the customizable Ribbon and Themes to conditional formatting, advanced web database publishing to SharePoint collaboration For everyone who wants to get the most out of Access 2010, from hobbyists to power users to corporate developers