Extended National Diploma in IT

Unit 18: Database Design

This session will focus on importing data from a Spreadsheet into Access Tables. How to modify and add Tables and form the relationships between the tables in Access 2016.

Resources »

Learning Outcomes

  1. Be able to design, create and populate a relational database

Assessments

Week 3 Activities - Creating Access Tables

Week Lesson Activity Learning Assessment Skill Developed

perform queries using multiple tables and multiple criteria

evaluate a database against the specified user need

1.1
  • 10 min A reminder of the benefits of a relational database using Basic Spreadsheet of Student Enrolments
  • 16 min Video: Explain the principles of a Access Database , four short Microsoft Videos
  • 20 min Demonstrate how to create an Access Database, and import Mia's Pizza Sales into new Access tables
    Video (5min) Importing Spreadsheet data into an Access Table
  • 20 min Demonstrate how to create Make Table or Append Table queries to create the People and Address Tables from the Customers Table
  • 20 min Demonstrate how to create the relationships between People and Addresses
  • 20 min Demonstrate how to add Addresses to People, and Staff to People.
  • 20 min Demonstrate how to add Orders and then create the relationships between Orders and Sandwhiches
  • 20 min Demonstrate how to add a Customer Person to the Order (1:M) and relate Staff to Shops (M:1)
  • Questions and Answers
  • Access Tables
  • Questions and Answers
  • Table Relationships

Useful Resources

Week Index