Use Excel to Create the table ClassInfo with the following fields: ClassID Numbe
ID: 338486 • Letter: U
Question
Use Excel to Create the table ClassInfo with the following fields:
ClassID Number Primary Key
ClassName Text
Enter the following data for each of the fields:
1 Freshman
2 Sophomore
3 Junior
4 Senior
5 N/A
Modify the StudentInfo table and add the ClassID field with the data type Number.
Give each of the people below the following ClassID:
Jones 3
Appleton 5
Towns 5
Brown 1
Create the query TermInfo with the following fields:
LastName
FirstName
Status
ClassName
SemesterCredits
RegistrationFee
Tuition
Total
Make sure you create the correct relationship for the tables.
Create the report TermReport from the query TermInfo
Explanation / Answer
Use Excel to Create the table ClassInfo with the following fields:
ClassID Number Primary Key
ClassName Text
Enter the following data for each of the fields:
1 Freshman
2 Sophomore
3 Junior
4 Senior
5 N/A
Modify the StudentInfo table and add the ClassID field with the data type Number.
Give each of the people below the following ClassID:
Jones 3
Appleton 5
Towns 5
Brown 1
Create the query TermInfo with the following fields:
LastName
FirstName
Status
ClassName
SemesterCredits
RegistrationFee
Tuition
Total
Make sure you create the correct relationship for the tables.
Create the report TermReport from the query TermInfo