IU Only

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: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • 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: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

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

• Asset Path: /training/accam/files/pc/using-query-operators-to-combine-data
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/using-query-operators-to-combine-data
• Asset System Name: using-query-operators-to-combine-data
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

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: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

Learn how to summarize data with Totals.

• Asset Path: /training/accam/files/pc/summarizing-data-with-totals
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/summarizing-data-with-totals
• Asset System Name: summarizing-data-with-totals
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

Learn how to create a complex, weighted calculated field.

• Asset Path: /training/accam/files/pc/adding-a-complex-calculated-field
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/adding-a-complex-calculated-field
• Asset System Name: adding-a-complex-calculated-field
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

Learn to summarize data with Crosstab Queries.

• Asset Path: /training/accam/files/pc/summarizing-data-with-cross-tab-queries
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/summarizing-data-with-cross-tab-queries
• Asset System Name: summarizing-data-with-cross-tab-queries
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

Get more practice building a Crosstab query.

• Asset Path: /training/accam/files/pc/challenge-exercise-building-another-crosstab-query
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/challenge-exercise-building-another-crosstab-query
• Asset System Name: challenge-exercise-building-another-crosstab-query
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:
  • challenge-exercise-building-another-crosstab-query

Learn how to change data with Action Queries.

• Asset Path: /training/accam/files/pc/changing-data-with-action-queries
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/changing-data-with-action-queries
• Asset System Name: changing-data-with-action-queries
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

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.

• Asset Path: /training/accam/files/pc/creating-make-table-queries
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/creating-make-table-queries
• Asset System Name: creating-make-table-queries
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

Learn to change data with an Append Query.

• Asset Path: /training/accam/files/pc/creating-an-append-query
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/creating-an-append-query
• Asset System Name: creating-an-append-query
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

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: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

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

• Asset Path: /training/accam/files/pc/creating-an-update-query
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/creating-an-update-query
• Asset System Name: creating-an-update-query
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

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

• Asset Path: /training/accam/files/pc/using-the-find-duplicates-query-wizard
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/using-the-find-duplicates-query-wizard
• Asset System Name: using-the-find-duplicates-query-wizard
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

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

• Asset Path: /training/accam/files/pc/using-the-find-unmatched-query-wizard
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/using-the-find-unmatched-query-wizard
• Asset System Name: using-the-find-unmatched-query-wizard
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

See the solution of the Concatenating Additional Fields exercise.

• Asset Path: /training/accam/files/pc/solution-concatenating-additional-fields
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/solution-concatenating-additional-fields
• Asset System Name: solution-concatenating-additional-fields
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:
  • using-query-operators-to-combine-data

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

• Asset Path: /training/accam/files/pc/solution-adding-parameters-to-a-query
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/solution-adding-parameters-to-a-query
• Asset System Name: solution-adding-parameters-to-a-query
• Asset Data Definition: Page - Content Blob
• Last modified by: jfickel
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:
  • using-parameter-queries

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

• Asset Path: /training/accam/files/pc/solution-challenge-exercise-building-another-crosstab-query
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/solution-challenge-exercise-building-another-crosstab-query
• Asset System Name: solution-challenge-exercise-building-another-crosstab-query
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • 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: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • 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: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

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

• Asset Path: /training/accam/files/pc/using-query-operators-to-combine-data
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/using-query-operators-to-combine-data
• Asset System Name: using-query-operators-to-combine-data
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

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: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

Learn how to summarize data with Totals.

• Asset Path: /training/accam/files/pc/summarizing-data-with-totals
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/summarizing-data-with-totals
• Asset System Name: summarizing-data-with-totals
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

Learn how to create a complex, weighted calculated field.

• Asset Path: /training/accam/files/pc/adding-a-complex-calculated-field
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/adding-a-complex-calculated-field
• Asset System Name: adding-a-complex-calculated-field
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

Learn to summarize data with Crosstab Queries.

• Asset Path: /training/accam/files/pc/summarizing-data-with-cross-tab-queries
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/summarizing-data-with-cross-tab-queries
• Asset System Name: summarizing-data-with-cross-tab-queries
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

Get more practice building a Crosstab query.

• Asset Path: /training/accam/files/pc/challenge-exercise-building-another-crosstab-query
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/challenge-exercise-building-another-crosstab-query
• Asset System Name: challenge-exercise-building-another-crosstab-query
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:
  • challenge-exercise-building-another-crosstab-query

Learn how to change data with Action Queries.

• Asset Path: /training/accam/files/pc/changing-data-with-action-queries
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/changing-data-with-action-queries
• Asset System Name: changing-data-with-action-queries
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

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.

• Asset Path: /training/accam/files/pc/creating-make-table-queries
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/creating-make-table-queries
• Asset System Name: creating-make-table-queries
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

Learn to change data with an Append Query.

• Asset Path: /training/accam/files/pc/creating-an-append-query
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/creating-an-append-query
• Asset System Name: creating-an-append-query
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

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: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

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

• Asset Path: /training/accam/files/pc/creating-an-update-query
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/creating-an-update-query
• Asset System Name: creating-an-update-query
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

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

• Asset Path: /training/accam/files/pc/using-the-find-duplicates-query-wizard
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/using-the-find-duplicates-query-wizard
• Asset System Name: using-the-find-duplicates-query-wizard
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

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

• Asset Path: /training/accam/files/pc/using-the-find-unmatched-query-wizard
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/using-the-find-unmatched-query-wizard
• Asset System Name: using-the-find-unmatched-query-wizard
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:

See the solution of the Concatenating Additional Fields exercise.

• Asset Path: /training/accam/files/pc/solution-concatenating-additional-fields
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/solution-concatenating-additional-fields
• Asset System Name: solution-concatenating-additional-fields
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:
  • using-query-operators-to-combine-data

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

• Asset Path: /training/accam/files/pc/solution-adding-parameters-to-a-query
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/solution-adding-parameters-to-a-query
• Asset System Name: solution-adding-parameters-to-a-query
• Asset Data Definition: Page - Content Blob
• Last modified by: jfickel
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From:
  • using-parameter-queries

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

• Asset Path: /training/accam/files/pc/solution-challenge-exercise-building-another-crosstab-query
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accam/files/pc/solution-challenge-exercise-building-another-crosstab-query
• Asset System Name: solution-challenge-exercise-building-another-crosstab-query
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Mon Sep 19 10:29:19 EDT 2022
  • Last Published By: tlmason
• Linked From: