Creating a table in Access

1. Creating a table in Access

2. If database is completely new, the table creation process will start automatically when you open the database • Otherwise you use Create / Table on Ribbon

4. Change to Design View • Click on Home • Click on the Design View menu choice - far left end of the Ribbon with grid box on it

5. Enter field names and types

6. Enter data in fields • Click on the Design view button to change to Datasheet view • Begin entering data, hitting Enter or tab after each field

7. To make a relationship between tables • Start by clicking on the Database Tools menu on the Ribbon

8. Add the tables that you want

9. Adding relationships • Decide which fields in which tables you want to relate • Drag the arrows from one of the fields you want to relate to the other – not just the TABLES but the specific fields

10. Types of Relationships • One to one • Person to Driver’s License, Country to President • One to many • Mother to Child, Division to Department, Supervisor to Employees, Owner to Car • Many to many • Parent to child, student to professor, nurse to patient

11. Referential Integrity violation