Extended National Diploma in IT

Unit 18: Database Design

This session will focus on creating queries and forms to facilitate adding new data to the database. It will also show to create and modify Reports and add automation.

Resources »

Learning Outcomes

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

Assessments

  • November 27th Assessment 1: Database Design and Implementation

    • Task 1: 07th November (P1, M1, D1) Theory
    • Task 2a: 10th November (P2) ERD
    • Task 2b: 11th November (P3) Tables
    • Task 2c: 11th November (M2) Import
    • Task 3a: 11th November (P4) Forms
    • Task 7: 14th November (P7, D2) Testing
    • Task 4: 14th November (P5) Queries
    • Task 5a: 18th November (P6) Reports
    • Task 3b: 27th November (M4) VBA
    • Task 5b: 27th November (P6) Buttons
    • Task 6: 27th November (M3) MailMerge

Week 4 Activities - Creating Access Forms

Week Lesson Activity Learning Assessment Skill Developed

create features in data entry forms to ensure validity and integrity of data

perform queries using multiple tables and multiple criteria

include an advanced feature in a database design

export data to an external source

implement an automated function

test a relational database

evaluate a database against the specified user need

1.1
  • 15 min Demonstrate adding a Navigation Form to your Access Database
  • 15 min Demonstrate how to create simple and multi-table queries
  • 15 min Demonstrate how to create and modify Forms
  • 15 min Demonstrate how to create and modify reports
  • 10 min Demonstrate how to add automation
  • 15 min Demonstrate how to customise forms &Amp; reports
  • 15 min Demonstrate how to add VBA Code
  • 10 min Demonstrate how to setup a Word Mail Merge
  • 1 min Demonstrate how to setup a Word Mail Merge
  • Questions and Answers
  • Access Forms
  • Access Reports
  • Access Queries
  • VBA Code
  • Form Design
  • Report Design
  • Query Design
  • Visual Basic

Useful Resources

Week Index