Abstract

This project is up to make use of Access Databases for personal records and student academic records only for females.

Introduction

I Created a student database and create tables for student personal records and student academic record. Using SQL query select data from both tables by merging it into one query. I applied different SQL queries of a complex format.

Details of all items used

I used Access, Databases, and Github.

Problem statement

Looking for specific information on the databases, having ID number,GPA, Firs Name, Last Name, age, country, and major of the student.

Methodology

I went to create a new table on Databases.

In Design View I added the data of the students as the first name, last name, taking a date type” long text”. Design View

Looking for the age I selected data type “number.”

Table 2 done with all data.

Started doing table 1 all GPA data. ![](https://i.postimg.cc/1XZN7jhh/5.png Done all with GPA DATA.

QUERY 1 I went to Query design and added criteria. Looking for a GPA Major than 2. (GPA > 2)

QUERY 2: I was looking for someone who lives in Spain. (Country =Spain).

QUERY 3: I was looking for someone who studies Management. (Major =” Management”)

QUERY 4: I was looking for a student major than 21 years. (AGE >21).

QUERY 5: I was looking for a person who was from Colombia and with a GPA major than 3.5. (Colombia >9 + GPA >3.5)

Future work

To make big databases in this format. Access Microsoft

Results

I found the required information from all female students.

Conclusion

There is a platform to create databases that shows the information that you want to look at.

References

Github, Access Databases.