Small access project
KrizesUsing 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.
- 4 years ago
- 10
Purchase the answer to view it
- Krizesstudent-advisingdatabase.accdb
- tables.PNG
- ENV 100 Week 2 Learning Team Assignment Ecosystems Paper
- Lab report dynamics
- See Description
- Correlation and Regression
- Using the research question and two variables your learning team developed for the Week 2 Business Research Project Part 1 assignment, create a no more than 350-word inferential statistics (hypothesis test). Include:
- MKT 506 Integrated Marketing Communications Assignment 4 for Professor Ryan
- Global Management
- CRMJ01AD
- PSY 340 Can someone please help?
- need in 4 hours need in moicrosoft visio