IU Only

Learn about the basics of databases, including database elements, relationships between tables, and primary and foreign keys.

• Asset Path: /training/accba/files/pc/an-introduction-to-databases
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/an-introduction-to-databases
• Asset System Name: an-introduction-to-databases
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to open an existing Access database and explore its features.

• Asset Path: /training/accba/files/pc/opening-an-existing-database
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/opening-an-existing-database
• Asset System Name: opening-an-existing-database
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to import records from an Excel file and fix errors for successful import results.

• Asset Path: /training/accba/files/pc/importing-records-from-an-excel-file
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/importing-records-from-an-excel-file
• Asset System Name: importing-records-from-an-excel-file
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to navigate through records in an Access table.

• Asset Path: /training/accba/files/pc/navigating-through-records-in-a-table
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/navigating-through-records-in-a-table
• Asset System Name: navigating-through-records-in-a-table
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to add an Attachment field, such as an image field. in an Access table.

• Asset Path: /training/accba/files/pc/adding-an-attachment
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/adding-an-attachment
• Asset System Name: adding-an-attachment
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to create a new table in Access, with a primary key and input mask -- plus learn how to import from Excel.

• Asset Path: /training/accba/files/pc/creating-a-new-table
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/creating-a-new-table
• Asset System Name: creating-a-new-table
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to create and define database relationships in Access.

• Asset Path: /training/accba/files/pc/creating-relationships
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/creating-relationships
• Asset System Name: creating-relationships
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to create single-table and relational queries in Access, plus sort and filter the query results.

• Asset Path: /training/accba/files/pc/creating-queries
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/creating-queries
• Asset System Name: creating-queries
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to create one-table and relational forms in Access and edit data using those forms.

• Asset Path: /training/accba/files/pc/creating-forms
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/creating-forms
• Asset System Name: creating-forms
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to create simple reports in Access using the report designer and Report Wizard.

• Asset Path: /training/accba/files/pc/generating-reports
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/generating-reports
• Asset System Name: generating-reports
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn about the basics of databases, including database elements, relationships between tables, and primary and foreign keys.

• Asset Path: /training/accba/files/pc/an-introduction-to-databases
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/an-introduction-to-databases
• Asset System Name: an-introduction-to-databases
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to open an existing Access database and explore its features.

• Asset Path: /training/accba/files/pc/opening-an-existing-database
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/opening-an-existing-database
• Asset System Name: opening-an-existing-database
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to import records from an Excel file and fix errors for successful import results.

• Asset Path: /training/accba/files/pc/importing-records-from-an-excel-file
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/importing-records-from-an-excel-file
• Asset System Name: importing-records-from-an-excel-file
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to navigate through records in an Access table.

• Asset Path: /training/accba/files/pc/navigating-through-records-in-a-table
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/navigating-through-records-in-a-table
• Asset System Name: navigating-through-records-in-a-table
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to add an Attachment field, such as an image field. in an Access table.

• Asset Path: /training/accba/files/pc/adding-an-attachment
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/adding-an-attachment
• Asset System Name: adding-an-attachment
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to create a new table in Access, with a primary key and input mask -- plus learn how to import from Excel.

• Asset Path: /training/accba/files/pc/creating-a-new-table
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/creating-a-new-table
• Asset System Name: creating-a-new-table
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to create and define database relationships in Access.

• Asset Path: /training/accba/files/pc/creating-relationships
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/creating-relationships
• Asset System Name: creating-relationships
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to create single-table and relational queries in Access, plus sort and filter the query results.

• Asset Path: /training/accba/files/pc/creating-queries
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/creating-queries
• Asset System Name: creating-queries
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to create one-table and relational forms in Access and edit data using those forms.

• Asset Path: /training/accba/files/pc/creating-forms
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/creating-forms
• Asset System Name: creating-forms
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From:

Learn how to create simple reports in Access using the report designer and Report Wizard.

• Asset Path: /training/accba/files/pc/generating-reports
• Asset Link: site://IU-UITS-ITTRAIN.content/training/accba/files/pc/generating-reports
• Asset System Name: generating-reports
• Asset Data Definition: Page - Content Blob
• Last modified by: blnolen
• Asset Indexable: true
• Asset Publishable: true
  • Last Published Date: Wed Jul 24 17:08:17 EDT 2024
  • Last Published By: jloakes
• Linked From: