Microsoft Access 2010 Intermediate Quick Reference Guide Cheat Sheet Of Instructions Tips And Shortcuts Laminated Card

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.

Laminated quick reference guide 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: Working with Database Files, Defining Access Objects, Adding a Record, Editing Fields and Records, Undoing Changes, Deleting Records, The Datasheet Window, Quickly Sorting a Table, Searching for a Record, Creating a Table, Primary Keys and Links, Using Design View to Create or Modify a Table, Creating/Modifying a Query, Creating Reports with a Wizard, Creating and Modifying Reports Manually, Printing a Report, Creating Forms with a Wizard, Creating and Modifying Forms Manually, Working with Forms, Backing Up and Compacting Database Files, Customizing Access. Also includes a list of Movement and Data Entry Shortcuts, Smart Database Design Tips, and Query Grid Criteria Examples. This guide is one of two available titles for Access 2010: Access 2010 Introduction and Access 2010 Intermediate.

Laminated quick reference guide showing step-by-step instructions and shortcuts for how to use Microsoft Office Access 2007. The following topics are covered: Working with Database Files, Definitions of Access Objects, Navigating Tabbed Documents, Adding a Record, Editing Fields and Records, Undoing Changes, The Datasheet Window, Deleting Records and Searching for a Record. Creating a Table - Suggestions, Creating a Table, Using Design View to Create or Modify a Table, Sorting Tables, Optimizing Data Collection Using Masks, Creating a Query, Creating Forms with a Wizard, Working with a Form, Creating Reports with a Wizard, Printing a Report, Grouping Database Objects, Renaming or Deleting Groups, Compacting Database Files, Customizing Access and Backing Up a Database. Also includes a list of Movement Shortcuts, and Data Field Types. 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 two available titles for Access 2007: Access 2007 Introduction and Access 2007 Intermediate.

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use features of Microsoft Office 2010 that are common to Word, Excel & PowerPoint. Great companion product to Word, Excel & PowerPoint Introduction guides. The following topics are covered: Using the Ribbon, Using The File Menu (Backstage View), Using the Quick Access Toolbar, Using the Status Bar, File Formats, Compatibility with Previous Versions, Formatting with the Mini Toolbar, Using Themes to Format a Document, Adding SmartArt, Using Shape Styles, The Research Task Pane, Creating an Embedded Object from Another Office File, Creating an Embedded Object from Another Office File, Creating a Hyperlink, Showing Macro and Form Controls, Inserting Comments, Deleting Comments, Removing Personal Information, Mark as Final, Saving as PDF, E-mailing a PDF, Restricting Distribution, Digital Signatures, Adding a Signature Line (Word, Excel), Signing a Signature Line, Viewing Digital Signatures, Working with Multiple Windows. This guide is suitable as a training handout, or simply an easy to use reference guide, for any type of user.

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.

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use advanced 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: Using Styles, Character, Paragraph, Linked Styles, Applying Character and Paragraph Styles, Creating a Style, Displaying the Styles Pane, Disabling Linked Styles, Changing Styles, Deleting a Style, Selecting All Text with the Same Style, Showing Formatting as Styles to Clean Up a Document, Importing Styles from Another Document, Using Numbered Lists with Styles, Adding Styles to the Default List, Applying Table Styles, Restricting Formatting, Creating a Table of Contents, Updating a Table of Contents, Preparing an Index, Generating an Index, Updating an Index, Section Breaks, Inserting a Section Break, Changing Page Numbering Mid-Document, Changing Headers and Footers, Changing Page Setup in a Section, Displaying the Section Number in the Status Bar, Inserting a Footnote/Endnote, Editing a Footnote/Endnote, Deleting a Footnote/Endnote, Creating a Bookmark, Going to/Selecting Bookmarked Text, Using Bookmarks to Refer to Pages, Outlining, Adding a Watermark, Inserting an Excel Spreadsheet, Comparing Documents Side by Side, Creating a Template Library in Windows 7, Creating a 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.

Laminated quick reference card showing step-by-step instructions and shortcuts for how to use Filler and Designer applications of Microsoft InfoPath 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: InfoPath Filler: Opening a Form to Fill, Filling in a Form, Sending a Form by e-Mail, Replying to a Form in Outlook, Filling in a Form Using a Web Browser. InfoPath Designer: Creating a New Form Template, Opening an Existing Form Template, Creating a Browser Compatible Form Template, Using Data Sources, Inserting Controls, Setting Properties for Controls, Laying Out a Form, Inserting a Scrolling Region, Advanced Layout with Section Controls, Adding Fields/Groups to Data Sources without Adding Form Controls, Deleting a Field or Group, Looking Up Data/Secondary Data Source, Restricting Data Entry Using Validation, Checking Form Design/Compatibility, Previewing a Form, Publishing a Form Template. Also includes: List of Filling and Designing Shortcuts.