Tabla de Contenidos: “…Convert a Formula to a Value by Using Menu CommandsConvert a Formula to a Value by Using a Macro; Make a Long Statement More Readable; Trusting Macro-Enabled Workbooks; Designate a Trusted Location for Macros; Designate a Trusted Publisher for Macros; Key Points; Chapter 2: Make a Macro Do Complex Tasks; Task One: Opening the Report File; Open a Text File; Watch a Macro Run by Stepping Through It; Select a File While Running a Macro; Task Two: Filling In Missing Labels; Select Only the Blank Cells; Fill the Selection with Values; Record Filling In the Missing Values…”

Tabla de Contenidos: “…Teach Yourself Visually Microsoft Office Access 2007; Table of Contents; How to Use This Book; Chapter 1 Getting Started with Access 2007; An Introduction to Access; Start and Exit Access; Create a Blank Database; Close a Database; Create a Database Using a Template; Open a Database File; Understanding the Access 2007 Interface; Change the Navigation Pane View; Open and Close an Object; View an Object; Chapter 2 Entering and Editing Data; Enter New Records; Navigate between Records; Edit Records; Attach Files to Records; Open, Save, and Remove File Attachments; Insert an OLE Object…”

Tabla de Contenidos: “…Creating a canvas app - understanding the why and how -- Hands-on exercise - building your first canvas app -- When to use Power Pages -- When to use a model-driven app -- Summary and comparison -- Exploring the model-driven app -- Summary -- Chapter 5: Data Connections -- Technical requirements -- Using Excel as a data source -- Creating a new Power App by uploading an Excel file -- Creating a blank canvas app with Excel -- Advantages of Excel -- Disadvantages of Excel -- Using SharePoint Lists as a data source -- Creating a Power App from SharePoint -- Creating a new Power App from a SharePoint list -- Advantages of SharePoint Lists -- Disadvantages of SharePoint Lists -- Using Dataverse as a data source -- Overview of Dataverse -- Key features and benefits -- Considerations for using Dataverse -- A step-by-step guide on how to add data via Dataverse -- Comparing Excel, SharePoint Lists, and Dataverse -- Other data connections -- Using dataflows as a data source -- Overview of dataflows in Power Apps -- Key features and benefits -- Considerations for using dataflows -- A step-by-step guide - utilizing dataflows as data sources -- Summary -- Part 2: Advanced Power App Techniques -- Chapter 6: Variables, Collections, and Data Filtering -- Technical requirements -- Variables and variable scope -- Importance of variables -- Types of variables -- Global variables -- Creating global variables -- Accessing global variables -- Examples of global variables -- Context variables -- Creating context variables -- Accessing context variables -- Examples of context variables -- With() function and Named Formulas -- Using the With() function -- Using Named Formulas -- Comparing global variables and Named Formulas -- Collections -- Importance of using collections -- Creating collections -- Removing records with Clear(), Remove(), and RemoveIf()…”

Tabla de Contenidos: “…Creating a Master/Child Form with the Form Wizard -- Generating Multiple Items and Split Forms -- Using Transaction-Processing Forms -- Modifying the Properties of a Form or Control After Testing -- 15 Designing Custom Multitable Forms -- Getting Acquainted with Form Design View's Contextual Ribbons -- Working in Form Design View -- Adding Label and Text Box Controls to a Blank Form -- Adding Group Boxes with the Wizard -- Using the Clipboard to Copy Controls to Another Form -- Adding Combo and List Boxes -- Adding an Attachment Control for Images -- Working with Tab Controls -- Optimizing the Form's Design -- Adding a History Subform to a Tab Control Page -- Adding New Records in the HRActionEntry Form -- Using the New Navigation Control and Application Parts -- Using the Web Browser Control -- Overriding the Field Properties of Tables -- Adding Page Headers and Footers for Printing Forms -- 16 Working with Simple Reports and Mailing Labels -- Categorizing Types of Access Reports -- Autogenerating a Simple Tabular Report -- Creating a Grouped Report with the Report Wizard -- Using Access's Report Ribbons -- The Print Preview Ribbon -- Modifying a Basic Wizard Report -- Adjusting Margins and Printing Conventional Reports -- Preventing Widowed Records with the Group Keep Together Property -- Printing Multicolumn Reports as Mailing Labels -- 17 Preparing Advanced Reports -- Grouping and Sorting Report Data -- Working from a Blank Report -- Incorporating Subreports -- Customizing De Novo Reports -- Mailing Reports as Attachments -- 18 Adding Graphs, PivotCharts, and PivotTables -- Generating Graphs and Charts with Microsoft Graph -- Printing Graphs or Charts in Reports -- Creating a Linked Graph from an Access Crosstab Query -- Working with PivotChart Forms -- Substituting or Adding a PivotTable in a Form -- V: Programming Databases with Macros…”

Tabla de Contenidos: “…Number/Currency data entry with data validation -- OLE object data entry -- Long Text field data entry -- Navigating Records in a Datasheet -- Moving between records -- Finding a specific value -- Changing Values in a Datasheet -- Manually replacing an existing value -- Changing an existing value -- Using the Undo Feature -- Copying and Pasting Values -- Replacing Values -- Adding New Records -- Deleting Records -- Displaying Records -- Changing the field order -- Changing the field display width -- Changing the record display height -- Changing display fonts -- Displaying cell gridlines and alternate row colors -- Aligning data in columns -- Hiding and unhiding columns -- Freezing columns -- Saving the changed layout -- Saving a record -- Sorting and Filtering Records in a Datasheet -- Sorting your records with QuickSort -- Filtering a selection -- Filtering by form -- Aggregating Data -- Printing Records -- Previewing Records -- Chapter 6: Importing and Exporting Data -- How Access Works with External Data -- Types of external data -- Ways of working with external data -- When to link to external data -- When to import external data -- When to export internal data -- Options for Importing and Exporting -- Importing External Data -- Importing from another Access database -- Importing from an Excel spreadsheet -- Importing a SharePoint list -- Importing data from text files -- Delimited text files -- Fixed-width text files -- Importing and exporting XML documents -- Importing and exporting HTML documents -- Importing Access objects other than tables -- Importing an Outlook folder -- Exporting to External Formats -- Exporting objects to other Access databases -- Exporting through ODBC drivers -- Exporting to Word -- Merging data into Word -- Publishing to PDF or XPS -- Chapter 7: Linking to External Data -- Linking External Data…”

Tabla de Contenidos: “…1.12 Generating Fixed-Width Field Data RecordsProblem; Solution; Discussion; See Also; 1.13 Parsing Fixed-Width Field Data Records; Problem; Solution; Discussion; See Also; 1.14 Taking Strings Apart; Problem; Solution; Discussion; See Also; 1.15 Wrapping Text at a Certain Line Length; Problem; Solution; Discussion; See Also; 1.16 Storing Binary Data in Strings; Problem; Solution; Discussion; See Also; 1.17 Program: Downloadable CSV File; Chapter 2. …”

Tabla de Contenidos: “…Add and Edit Slide Text -- Change the Font, Size, and Color -- Apply a Theme -- Set Line Spacing -- Align Text -- Add a Text Box to a Slide -- Add a Table to a Slide -- Add a Chart to a Slide -- Add a Video Clip to a Slide -- Move a Slide Object -- Resize a Slide Object -- Chapter 15 Assembling and Presenting a Slide Show -- Reorganize Slides -- Reuse a Slide -- Define Slide Transitions -- Add Animation Effects -- Record Narration -- Insert a Background Song -- Create Speaker Notes -- Rehearse a Slide Show -- Run a Slide Show -- Review a Presentation -- Package Your Presentation on a CD -- Present Online -- Part V Access -- Chapter 16 Database Basics -- Understanding Database Basics -- Create a Database Based on a Template -- Create a Blank Database -- Create a New Table -- Change Table Views -- Add a Field to a Table -- Delete a Field from a Table -- Hide a Field in a Table -- Move a Field in a Table -- Create a Form -- Change Form Views -- Move a Field in a Form -- Delete a Field in a Form -- Apply a Database Theme -- Chapter 17 Adding, Finding, and Querying Data -- Add a Record to a Table -- Add a Record to a Form -- Navigate Records in a Form -- Search for a Record Using a Form -- Delete a Record from a Table -- Delete a Record Using a Form -- Sort Records -- Filter Records -- Apply Conditional Formatting -- Perform a Simple Query -- Create a Report -- Part VI Outlook -- Chapter 18 Organizing with Outlook -- Navigate in Outlook -- Schedule an Appointment -- Create a New Contact -- Create a New Task -- Add a Note -- Customize the Navigation Bar -- Peek at Appointments and Tasks -- Search for Outlook Items -- Work with the To‐Do Bar -- Link Contacts -- Chapter 19 Emailing with Outlook -- Compose and Send a Message -- Send a File Attachment -- Read an Incoming Message -- Reply To or Forward a Message -- Add a Sender to Your Outlook Contacts…”

Tabla de Contenidos: “…Using the Cut, Copy, and Paste -- Copying Cells Using Fill Handle -- Dragging Cells -- Math and Trig Functions -- Logical Functions -- Statistical Functions -- Text Functions -- Date and Time Functions -- Page Tab -- Margins Tab -- Header/Footer Tab -- Sheet Tab -- Multiple-choice Questions -- Answers -- Chapter 12: Microsoft Office Power Point 2003 -- Using the Auto Content Wizard -- Using Design Template -- Using Blank Presentation -- Normal View -- Slide Sorter View -- Slide Show View -- Slide Master -- Notes Master -- Handout Master -- Adding Text Using Placeholder -- Adding Text Using Text Box -- Adding Text to an Auto Shape -- Custom Animations -- Multiple-choice Questions -- Answers -- Chapter 13: Data Communication and Computer Networks -- Analog Signal -- Digital Signals -- Guided or Wired Media -- Unguided or Wireless Media -- Amplitude Modulation (AM) -- Frequency Modulation (FM) -- Phase Modulation (PM) -- Asynchronous Transmission -- Synchronous Transmission -- Circuit Switching -- Packet Switching -- Message Switching -- LAN -- MAN -- WAN -- Bus Topology -- Ring Topology -- Star Topology -- Tree Topology -- Mesh Topology -- Multiple-choice Questions -- Answers -- Chapter 14: Internet -- TCP/IP -- FTP -- HTTP -- SMTP -- NNTP -- Electronic Mail -- FTP -- Telnet -- Internet Relay Chat (IRC) -- Chatting and Instant Messaging -- Internet Telephony -- Video Conferencing -- Commerce Through Internet -- Mailing Lists (Listserver) -- Creating an E-mail Account -- Multiple-choice Questions -- Answers -- Chapter 15: Computer Security -- Secret-key Cryptography -- Public-key Cryptography -- Hash Functions -- Packet-filtering Router -- Application-level Gateway -- Circuit-level Gateway -- Multiple-choice Questions -- Answers -- Chapter 16: Database Management Systems -- Data -- Information -- Knowledge -- Entity -- Attribute -- Relationship…”

Tabla de Contenidos: “…Step-by-step example using Sequence and Control flow -- Summary -- Data Manipulation -- Variables and scope -- Collections -- Arguments - Purpose and use -- Data table usage with examples -- Building a data table -- Building a data table using data scraping (dynamically) -- Clipboard management -- File operation with step-by-step example -- Read cell -- Write cell -- Read range -- Write range -- Append range -- CSV/Excel to data table and vice versa (with a step-by-step example) -- Reading an Excel file and creating a data table by using data from the Excel file -- Creating a data table and then writing all its data to an Excel file -- Summary -- Taking Control of the Controls -- Finding and attaching windows -- Implementing the Attach Window activity -- Finding the control -- Anchor base -- Element Exists -- Element scope -- Find children -- Find element -- Find relative element -- Get ancestor -- Indicate on screen -- Techniques for waiting for a control -- Wait Element Vanish -- Wait Image Vanish -- Wait attribute -- Act on controls - mouse and keyboard activities -- Mouse activities -- The Click activity -- The Double-click activity -- The Hover activity -- Keyboard activities -- Send hotkey -- Type into activity -- Type secure text -- Working with UiExplorer -- Handling events -- Element triggering events -- Click trigger -- Key press trigger -- Image triggering events -- System triggering events -- Hotkey trigger -- Mouse trigger -- System trigger -- Revisit recorder -- Basic recording -- Desktop recording -- Web recording -- Citrix -- Screen Scraping -- When to use OCR -- Types of OCR available -- How to use OCR -- Avoiding typical failure points -- Selectors -- Scope of the variable -- Delay activity -- Element Exists -- Try/Catch -- toString -- Summary -- Tame that Application with Plugins and Extensions -- Terminal plugin -- SAP automation…”

Tabla de Contenidos: “…IntroductionMusic therapy workshops; Training music therapists; Making music therapy training videos; Conclusion; Chapter 9Music Therapy Supervision; Introduction; Receiving supervision; Giving individual supervision; A supervision group; Reflections on what supervisees have written; Conclusion; Conclusion; APPENDIX 1BLANK SHEET USED FOR RECORDING ON-GOING MUSIC THERAPY NOTES IN THE CROFT NURSING FOLDER; APPENDIX 2 SUMMARY DESCRIBING DAMIEN'S MUSIC THERAPY SESSION; APPENDIX 3 SUMMARY DESCRIBING NANCY, CLAUDE AND PHOEBE'S MUSIC THERAPY SESSION; APPENDIX 4 DAMIEN'S MUSIC THERAPY REPORT…”

Tabla de Contenidos: “…CLUSTER_INTERCONNECTSCOMMIT_POINT_STRENGTH; COMPATIBLE; COMPLEX_VIEW_MERGING; CONTROL_FILE_RECORD_KEEP_TIME; CONTROL_FILES; CORE_DUMP_DEST; CPU_COUNT; CREATE_BITMAP_AREA_SIZE; CREATE_STORED_OUTLINES; CURSOR_SHARING; CURSOR_SPACE_FOR_TIME; DB_BLOCK_BUFFERS; DB_BLOCK_CHECKING; DB_BLOCK_CHECKSUM; DB_BLOCK_LRU_LATCHES; DB_BLOCK_MAX_DIRTY_TARGET; DB_BLOCK_SIZE; DB_CACHE_ADVICE; DB_CACHE_SIZE; DB_CREATE_FILE_DEST; DB_CREATE_ONLINE_LOG_DEST_n; DB_DOMAIN; DB_FILE_DIRECT_IO_COUNT; DB_FILE_MULTIBLOCK_READ_COUNT; DB_FILE_NAME_CONVERT; DB_FILES; DB_FLASHBACK_RETENTION_TARGET; DB_KEEP_CACHE_SIZE…”