Use Excel to Create the table ClassInfo with the following fields: ClassID Numbe

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

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.