Question

make an assignment on ms access.

Answer 1

Using Microsoft Access, we are going to define a database called Student Advising consisting 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 is Text, field size is 15
First Name is Text, field size is 15
Major is Text, field size is 30
Advisor ID os Text, field size is 4
Credits is Number and and its field size is Integer
The Faculty table has the following fields with the following properties:
Faculty ID - is Text, the field size is 4, the Caption is Fac. ID and it is the primary key.
Last Name - is Text and the field size is 15
First Name is Text, field size is 15
Office Phone is Text, field size is 4 and the Caption is Phone