Small access project

profileKrizes

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.

  • 4 years ago
  • 10
Answer(1)

Purchase the answer to view it

blurred-text
  • attachment
    Krizesstudent-advisingdatabase.accdb
  • attachment
    tables.PNG