UNIT 18 - AS2 - Design, create and populate a DB (P2, P3, P4, P5, P6 , M2, M3, M4, D1)

Design, create and populate a relational
database
Unit 18: Database Design – Assignment 2
Daniel C BTEC Level 3 01/05/2020
in IT

,Contents
First Entity Relationship Diagram................................................................................................................................................................................................... 2
Final Entity Relationship Diagram.................................................................................................................................................................................................. 3
Data dictionary.............................................................................................................................................................................................................................. 4
The relationship between tables................................................................................................................................................................................................... 5
Five Tables - Datasheet and Design View....................................................................................................................................................................................... 6
Five Tables - Forms in Form and Design view................................................................................................................................................................................ 8
Five Queries - Datasheet and Design View.................................................................................................................................................................................. 12
Importing data from Excel........................................................................................................................................................................................................... 15
Importing data from Access......................................................................................................................................................................................................... 18
Exporting data to Excel................................................................................................................................................................................................................ 21
Annotated Screenshots - Exporting data to Access...................................................................................................................................................................... 23
First Macro – Opening ‘tblCustomers’ in Design view................................................................................................................................................................. 25
Second Macro – Opening ‘frmGraphicsCard’ in form view (read-only).......................................................................................................................................27
Third Macro - Opening Query ‘Customers over 25 years that paid using Paypal’ in datasheet view...........................................................................................28
Fourth Macro – Opening ‘tblEmployees’ in Datasheet view (Read-Only)....................................................................................................................................29
Fifth Macro – Opening ‘frmOrders’ in Design view (Edit)............................................................................................................................................................30
Report – how to avoid errors while designing and creating a database......................................................................................................................................32

,First Entity Relationship Diagram

, Final Entity Relationship Diagram




3NF