IU Only

Access 2016: Structuring and Relating Data Asset List

Access 2016: Structuring and Relating Data: Pages: 16 total

Review the a database and refine some table properties.

Learn more about database relationships and referential integrity.

Learn about data normalization.

Learn about business rules and how building a Junction table in Access can help make an efficient database.

Learn how to create a relational query in Access.

Explore join properties in tables including join types and ambiguous joins.

Learn about null values in tables.

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: jfickel
  • Asset Indexable: true
  • Asset Publishable: true
    • Last Published Date: Wed Mar 11 08:37:31 EDT 2020
    • Last Published By: tlmason
  • Linked From:

    Learn how to copy a table.

    Learn how to create a new table and modify indexes.

    Learn how to double-check existing functionality, updating and deleting tables as needed.

    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: jfickel
    • Asset Indexable: true
    • Asset Publishable: true
      • Last Published Date: Wed Mar 11 08:37:31 EDT 2020
      • Last Published By: tlmason
    • Linked From:

      Learn how to create a relational form with Form Wizard and edit data.

      Create a number of tables to track students and enrollments in the database.

      Access 2016: Structuring and Relating Data: : 2 total

      Access 2016: Structuring and Relating Data: Files: 0 total

      Access 2016: Structuring and Relating Data Asset List

      Access 2016: Structuring and Relating Data: Pages: 16 total

      Review the a database and refine some table properties.

      Learn more about database relationships and referential integrity.

      Learn about data normalization.

      Learn about business rules and how building a Junction table in Access can help make an efficient database.

      Learn how to create a relational query in Access.

      Explore join properties in tables including join types and ambiguous joins.

      Learn about null values in tables.

      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: jfickel
      • Asset Indexable: true
      • Asset Publishable: true
        • Last Published Date: Wed Mar 11 08:37:31 EDT 2020
        • Last Published By: tlmason
      • Linked From:

        Learn how to copy a table.

        Learn how to create a new table and modify indexes.

        Learn how to double-check existing functionality, updating and deleting tables as needed.

        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: jfickel
        • Asset Indexable: true
        • Asset Publishable: true
          • Last Published Date: Wed Mar 11 08:37:31 EDT 2020
          • Last Published By: tlmason
        • Linked From:

          Learn how to create a relational form with Form Wizard and edit data.

          Create a number of tables to track students and enrollments in the database.

          Access 2016: Structuring and Relating Data: : 2 total

          Access 2016: Structuring and Relating Data: Files: 0 total