Create relationships among all three tables using the common key
1. Create a multi-table Query based on Tables Contact and Student.
Choose the following Fields from
Student : StudentID, LastName, FirstName.
Contact : SessionType , Numsessions , Cost.
2. Create a multi-table Query based on Tables Tutor and Student.
Choose the following Fields from
Student :StudentID, LastName, FirstName.
Tutor: Tutor ID ,LastName , YearInSchool , Major
3. Create a multi-table Query based on Tables Contact, Student, and Tutor.
Choose the following Fields from
Student : StudentID, LastName, FirstName.
Contact : SessionType , NumSessions .
Tutor : LastName, Major.
4. Create 3 Reports based on Query from steps 1, 2, and 3.
5. Create three forms based on all the three Tables
6. Create a Crosstab Query
Select Tutor table
Choose Major as a Selected field
Choose School as the Column heading
Choose Count Function
Save the query as ” MajorCollegeData”
7. Save As database with your name and close.
5. Upload access database file. example : firstname.accdb
The post Create relationships among all three tables using the common key
1. Create a mul appeared first on study tools.