Week $14-$ Access Practice

Download the database file 'Movies DB$.$accsdb.$\text{'}$ Review the content of the file.

Create a new table 'Films' and import data from Excel file 'Films.xlsx$.\text{'}$

Create relationships between tables according to the ERD in Figure $1$ below.

Figure $1.$ Movies DB ERD

Create queries to extract information from the 'Movies DB$.$ accsdb' database:

$4\mathrm{.}1.$ How many Steven Spielberg movies are there in the database?

$4\mathrm{.}2.$ How many movies in Mandarin are there in the database?

$4\mathrm{.}3.$ What is the total length of movies in Japanese?

$4\mathrm{.}4.$ What is the total profit of the movies released by the Universal Pictures studio?

$4\mathrm{.}5.$ What director generated the highest profits for the Universal Pictures studio?

$4\mathrm{.}6.$ How many PG films were released between $1991-2000?$

$4\mathrm{.}7.$ How many different actors played James Bond character?

$1$

$4\mathrm{.}8.$ What is the mane of the actor who played James Bond character the most number of times?