Using Microsoft Access You Will Define A Student Advising Da

Using Microsoft Access You Will Define A Student Advising Database Th

Using Microsoft Access, you will define a student-advising database that will consist of two tables: Students and Faculty. The Student Table has the following fields with the following properties: • Student ID data type is Text, field size is 4 and Caption is ID #. It is also the primary key. • Last Name data type is Text, s, field size is 15 • First Name data type is Text, field size is 15 • Major data type is Text, field size is 30 • Advisor ID data type is Text, field size is 4 • Credits data type is Number, field size is Integer The Faculty Table has the following fields with the following properties: • Faculty ID data type is Text, the field size is 4, the Caption is Fac. ID and it is the primary key. • Last Name data type is Text and the field size is 15 • First Name data type is Text, field size is 15 • Office Phone data type is Text, field size is 4 and the Caption is Phone Additionally, you will create two queries for Students . 1. List every students' First Name, Last Name, Major and Credits (in that order). 2. List the First Name, Last Name, Credits for every student whose advisor's ID is 2222 .

Paper For Above instruction

Introduction

Creating a comprehensive student advising database in Microsoft Access is fundamental for managing academic records efficiently. This project entails designing two interrelated tables—Students and Faculty—defining their respective fields and properties, and constructing queries to extract pertinent information. Such a database streamlines the process of tracking student progress and advising relationships, ultimately supporting academic advising and administrative decision-making.

Database Design and Table Creation

The initial phase involves designing the two essential tables: Students and Faculty. Each table's fields are meticulously selected to ensure data integrity, consistency, and ease of use.

Students Table

The Students table includes six fields:

• Student ID: A text field with a length of four characters; designated as the primary key for unique student identification. The caption is set as "ID #".
• Last Name: Text field, size 15, to store the student's last name.
• First Name: Text field, size 15, for the student's first name.
• Major: Text field, size 30, indicating the student's major area of study.
• Advisor ID: Text field, size 4, linking to the Faculty table to denote the student's academic advisor.
• Credits: Number field, integer size, tracking the number of credits the student has accumulated.

Faculty Table

The Faculty table consists of five fields:

• Faculty ID: Text field, size 4, acting as the primary key, with caption "Fac. ID".
• Last Name: Text, size 15, storing faculty member's last name.
• First Name: Text, size 15, for the faculty member's first name.
• Office Phone: Text, size 4, with caption "Phone", to record the faculty's office contact number.

Query Development

Once the tables are established, two queries serve to extract meaningful data.

Query 1: List All Students

This query retrieves the First Name, Last Name, Major, and Credits for every student. It provides a straightforward overview of all students' basic academic information, useful for reports and assessments.

Query 2: Students with a Specific Advisor

This query focuses on students whose Advisor ID is 2222, displaying their First Name, Last Name, and Credits. It facilitates targeted advising by identifying students under a specific academic advisor, enabling advisors to monitor and support their advisees effectively.

Implementation Considerations

Proper primary key designation and data type selection are critical to data integrity. Maintaining consistent field sizes ensures uniformity across records. Establishing relationships between tables through the Advisor ID, which references Faculty ID, enhances referential integrity.

The queries can be created using Microsoft Access's Query Design tool, with the selection and filter criteria specified accordingly.

Conclusion

The creation of a Student Advising Database in Microsoft Access involves meticulous table design and query formulation. The structured approach outlined ensures efficient data management and retrieval, essential for academic oversight. By integrating student and faculty data and facilitating targeted queries, educational institutions can improve advising processes and data-driven decision making.

References

1. Hart, D. (2017). Access 2016 Programming by Example. Pearson Education.
2. Ramsey, E. (2019). Mastering Microsoft Access 2019. Packt Publishing.
3. Gaskin, J. (2020). Microsoft Access 2019 Programming Cookbook. Packt Publishing.
4. Greenberg, J. (2018). Beginning Database Design. Apress.
5. Harrington, J. L. (2016). Relational Database Design and Implementation. Morgan Kaufmann.
6. Blaha, M. (2018). Learning Microsoft Access 2019. Microsoft Press.
7. Hoffer, J. A., George, J. F., & Valacich, J. S. (2016). Modern Database Management. Pearson.
8. Jin, X. (2019). Data Modeling Fundamentals. O'Reilly Media.
9. Kroenke, D. M. (2019). Database Processing: Fundamentals, Design, and Implementation. Pearson.
10. Rob, P., & Coronel, C. (2018). Database Systems. Cengage Learning.