Kindson Write on Introduction to Databases for Beginners

Introduction to Databases for Beginners

In this presentation, you will learn the basics of how databases work and how to create and manage databases I Microsoft Access. You will learn how to write SQL Queries including

• SELECT Queries
• INSERT Queries
• UPDATE Queries
• DELETE Queries

You will also learn how to Create Primary Key and Foreign Key as well as how to create relationships between the two tables

What you will need.

• Microsoft Access
• Basic Computer literacy
• Knowledge of Windows (the demo is done on windows)

Steps to Follow

• Open Microsoft Access
• Create a database and give it a name
• Create a table and rename it to tblStudents. This table would hold the student information
• Create a second table and rename it to tblFaculties. This table would hold information about the faculties.
• Create a Primary Key RegistrationNumber in the tblStudents table
• Create a Primary Key FacultyCode in the tblFaculties table
• Add three records to each of the table
• Add a foreign key FacultyCode to the tblStudents table. 
• Create a relationship between the two tables using the FacultyCode Foreign key. To do that, follow the instructions below
• Click on Database Tools tab in the Ribbon
• Click on the Create and choose relationships
• Select the two tables in the dialog box that appears and click on ADD
• Close the dialog box
• Drag the Primary Key column (FacultyCode) from the tblFaculties table to the corresponding Foreign key in the tblStudents table 
• Click ok in the dialog box that appears
• If you have successfully created the relationship, then open the tblFaculties table and make sure that the relationships is properly created

I hope you have learned how to create databases as a beginner. You can leave a comment to let me know how helpful this was to you