IU Only

Access 2016: Analyzing and Modifying Data with Queries Asset List

Access 2016: Analyzing and Modifying Data with Queries: Pages: 22 total

Welcome to Analyzing and Modifying Data with Queries.

Just a list of blobs

  • Asset Path: /training/accam/files/pc/index
  • Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/index
  • Asset System Name: index
  • Asset Data Definition: Page - Standard
  • Last modified by: tlmason
  • Asset Indexable: false
  • Asset Publishable: true
    • Last Published Date: Fri Jun 14 14:31:54 EDT 2019
    • Last Published By: tlmason
  • Linked From:

    Open and explore the tables and relationships in an existing database.

    • Asset Path: /training/accam/files/pc/exploring-the-database
    • Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/exploring-the-database
    • Asset System Name: exploring-the-database
    • Asset Data Definition: Page - Content Blob
    • Last modified by: jfickel
    • Asset Indexable: true
    • Asset Publishable: true
      • Last Published Date: Fri Jun 14 14:31:35 EDT 2019
      • Last Published By: tlmason
    • Linked From:

      Learn how to work with criteria in Queries including Boolean terms and wildcard characters.

      • Asset Path: /training/accam/files/pc/working-with-criteria
      • Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/working-with-criteria
      • Asset System Name: working-with-criteria
      • Asset Data Definition: Page - Content Blob
      • Last modified by: jfickel
      • Asset Indexable: true
      • Asset Publishable: true
        • Last Published Date: Fri Jun 14 14:31:35 EDT 2019
        • Last Published By: tlmason
      • Linked From:

        Learn to use Query Operators to create expressions and concatenate data.

        Learn how to create Parameter Queries where a user can enter criteria when they run the query.

        • Asset Path: /training/accam/files/pc/using-parameter-queries
        • Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/using-parameter-queries
        • Asset System Name: using-parameter-queries
        • Asset Data Definition: Page - Content Blob
        • Last modified by: jfickel
        • Asset Indexable: true
        • Asset Publishable: true
          • Last Published Date: Fri Jun 14 14:31:35 EDT 2019
          • Last Published By: tlmason
        • Linked From:

          Learn how to summarize data with Totals.

          Learn how to create a complex, weighted calculated field.

          Learn to summarize data with Crosstab Queries.

          Practice concatenating fields.

          Add more parameters to a query.

          Get more practice building a Crosstab query.

          Learn how to change data with Action Queries.

          Learn to create a Make Table query that selects data, pulls data from a database based on certain criteria, and then saves that data into a new table.

          Learn to change data with an Append Query.

          Learn how to build, test, and run an effective Delete Query.

          • Asset Path: /training/accam/files/pc/using-delete-queries
          • Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/using-delete-queries
          • Asset System Name: using-delete-queries
          • Asset Data Definition: Page - Content Blob
          • Last modified by: jfickel
          • Asset Indexable: true
          • Asset Publishable: true
            • Last Published Date: Fri Jun 14 14:31:35 EDT 2019
            • Last Published By: tlmason
          • Linked From:

            Learn how to create, test, and run an Update Query.

            Clean up your data by using the Find Duplicates Query Wizard to see potentially duplicate entries.

            Clean up your data by using the Find Unmatched Query Wizard to examine issues between related tables.

            See the solution of the Concatenating Additional Fields exercise.

            See the solution to the challenge of adding parameters to a query.

            See the solution to the challenge of building another Crosstab Query.

            Access 2016: Analyzing and Modifying Data with Queries: : 2 total

            Access 2016: Analyzing and Modifying Data with Queries: Files: 0 total