Access: Research Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

Determine the Right Table

The data is related this way:

[NewFamilyMoviesSQ]![ID] = [tblMovieTitles]![ID]

 

[tblMovieTitles]![RentalID] = [tblRental]![RentalID]

 

Add the following fields to the grid:

From tblMovieTItles: ID, Movie, Year and Rating.

From tblRental: Price, Description.

 

Determine the Right Table:

There are three tables/queries that have a Movie field. Which table should you use? Choose the table that has the primary key. TblMovieTitles has the Primary Key and all things related to that Primary Key.

Query Tools-> Design
 
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 4.  Creating and modifying queries 

  4.1.2. Create queries based on more than one table

  Identify which table to draw a field from when two tables have fields with the same name