Access: Structuring and Relating Data Asset List
- Current folder path within the WCMS: /training/accsd/files/pc
- Title Code: accsd
- Title Description Page: https://ittraining.iu.edu/explore-topics/titles/accsd
- Expand Course URL: http://expand.iu.edu/browse/ittraining/single/courses/accsd
Expand the accordions to see the lists of assets and their properties.
Access: Structuring and Relating Data: Pages: 16 total
Review the a database and refine some table properties.
- Asset Path: /training/accsd/files/pc/getting-started-with-structuring-and-relating-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/getting-started-with-structuring-and-relating-data
- Asset System Name: getting-started-with-structuring-and-relating-data
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn more about database relationships and referential integrity.
- Asset Path: /training/accsd/files/pc/reviewing-database-relationships
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/reviewing-database-relationships
- Asset System Name: reviewing-database-relationships
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn about data normalization.
- Asset Path: /training/accsd/files/pc/normalizing-database-tables
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/normalizing-database-tables
- Asset System Name: normalizing-database-tables
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn about business rules and how building a Junction table in Access can help make an efficient database.
- Asset Path: /training/accsd/files/pc/building-a-junction-table
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/building-a-junction-table
- Asset System Name: building-a-junction-table
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn how to create a relational query in Access.
- Asset Path: /training/accsd/files/pc/creating-relational-queries
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/creating-relational-queries
- Asset System Name: creating-relational-queries
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Explore join properties in tables including join types and ambiguous joins.
- Asset Path: /training/accsd/files/pc/understanding-join-properties
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/understanding-join-properties
- Asset System Name: understanding-join-properties
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn about null values in tables.
- Asset Path: /training/accsd/files/pc/working-with-null-values
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/working-with-null-values
- Asset System Name: working-with-null-values
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn more about junction tables and creating a composite key.
- Asset Path: /training/accsd/files/pc/using-junction-tables
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/using-junction-tables
- Asset System Name: using-junction-tables
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn how to copy a table.
- Asset Path: /training/accsd/files/pc/copying-a-table-to-build-new-functionality
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/copying-a-table-to-build-new-functionality
- Asset System Name: copying-a-table-to-build-new-functionality
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn how to create a new table and modify indexes.
- Asset Path: /training/accsd/files/pc/creating-tblsectionsinstructors
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/creating-tblsectionsinstructors
- Asset System Name: creating-tblsectionsinstructors
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn how to double-check existing functionality, updating and deleting tables as needed.
- Asset Path: /training/accsd/files/pc/double-checking-existing-functionality
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/double-checking-existing-functionality
- Asset System Name: double-checking-existing-functionality
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn how to add a lookup field and lookup table using Lookup Wizard.
- Asset Path: /training/accsd/files/pc/creating-a-lookup-table
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/creating-a-lookup-table
- Asset System Name: creating-a-lookup-table
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn how to create a relational form with Form Wizard and edit data.
- Asset Path: /training/accsd/files/pc/entering-data-with-relational-forms
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/entering-data-with-relational-forms
- Asset System Name: entering-data-with-relational-forms
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Create a number of tables to track students and enrollments in the database.
- Asset Path: /training/accsd/files/pc/tracking-students-and-enrollments
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/tracking-students-and-enrollments
- Asset System Name: tracking-students-and-enrollments
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Access: Structuring and Relating Data: : 2 total
Access: Structuring and Relating Data: Files: 0 total
Access: Structuring and Relating Data Asset List
- Current folder path within the WCMS: /training/accsd/files/pc
- Title Code: accsd
- Title Description Page: https://ittraining.iu.edu/explore-topics/titles/accsd
- Expand Course URL: http://expand.iu.edu/browse/ittraining/single/courses/accsd
Expand the accordions to see the lists of assets and their properties.
Access: Structuring and Relating Data: Pages: 16 total
Review the a database and refine some table properties.
- Asset Path: /training/accsd/files/pc/getting-started-with-structuring-and-relating-data
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/getting-started-with-structuring-and-relating-data
- Asset System Name: getting-started-with-structuring-and-relating-data
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn more about database relationships and referential integrity.
- Asset Path: /training/accsd/files/pc/reviewing-database-relationships
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/reviewing-database-relationships
- Asset System Name: reviewing-database-relationships
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn about data normalization.
- Asset Path: /training/accsd/files/pc/normalizing-database-tables
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/normalizing-database-tables
- Asset System Name: normalizing-database-tables
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn about business rules and how building a Junction table in Access can help make an efficient database.
- Asset Path: /training/accsd/files/pc/building-a-junction-table
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/building-a-junction-table
- Asset System Name: building-a-junction-table
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn how to create a relational query in Access.
- Asset Path: /training/accsd/files/pc/creating-relational-queries
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/creating-relational-queries
- Asset System Name: creating-relational-queries
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Explore join properties in tables including join types and ambiguous joins.
- Asset Path: /training/accsd/files/pc/understanding-join-properties
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/understanding-join-properties
- Asset System Name: understanding-join-properties
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn about null values in tables.
- Asset Path: /training/accsd/files/pc/working-with-null-values
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/working-with-null-values
- Asset System Name: working-with-null-values
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn more about junction tables and creating a composite key.
- Asset Path: /training/accsd/files/pc/using-junction-tables
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/using-junction-tables
- Asset System Name: using-junction-tables
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn how to copy a table.
- Asset Path: /training/accsd/files/pc/copying-a-table-to-build-new-functionality
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/copying-a-table-to-build-new-functionality
- Asset System Name: copying-a-table-to-build-new-functionality
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn how to create a new table and modify indexes.
- Asset Path: /training/accsd/files/pc/creating-tblsectionsinstructors
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/creating-tblsectionsinstructors
- Asset System Name: creating-tblsectionsinstructors
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn how to double-check existing functionality, updating and deleting tables as needed.
- Asset Path: /training/accsd/files/pc/double-checking-existing-functionality
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/double-checking-existing-functionality
- Asset System Name: double-checking-existing-functionality
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn how to add a lookup field and lookup table using Lookup Wizard.
- Asset Path: /training/accsd/files/pc/creating-a-lookup-table
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/creating-a-lookup-table
- Asset System Name: creating-a-lookup-table
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Learn how to create a relational form with Form Wizard and edit data.
- Asset Path: /training/accsd/files/pc/entering-data-with-relational-forms
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/entering-data-with-relational-forms
- Asset System Name: entering-data-with-relational-forms
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From:
Create a number of tables to track students and enrollments in the database.
- Asset Path: /training/accsd/files/pc/tracking-students-and-enrollments
- Asset Link: site://IU-UITS-ITTRAIN.content/training/accsd/files/pc/tracking-students-and-enrollments
- Asset System Name: tracking-students-and-enrollments
- Asset Data Definition: Page - Content Blob
- Last modified by: blnolen
- Asset Indexable: true
- Asset Publishable: true
- Last Published Date: Mon Sep 19 10:37:57 EDT 2022
- Last Published By: tlmason
- Linked From: