1. Microsoft Access creating a database.

2. Create unique fields for the database.

3. Create the relationships between tables for the database.

4. Question what would be the disadvantage of having all the information in one table? Waste memory and time for fields that do not pertain to the field, you want to reduce redundancy

5. Create NEW project, Enter your fields, Save your work.

6. Choose to create Primary Key.

7. Primary Key is unique, and will identify all fields of a table.

8. Question what is a good Primary Key for a Football player? Let Access choose unique numbers for the Primary Key

9. To create a relationship between tables, you need to make a foreign key to relate to the Primary Key.

10. Go to Relationship Icon on toolbar. Click and build the relationship

11. Question How to build realtionships on other Database Management Programs besides Access?

12. Three different types of Database Network, Hiearchal, Relational.

13. Question What is a many to many types of relationship?

14. Question What is the phases of the Normal Forms 1,2,3 BCNF?

15. Place foreign key in the many relationship table.