• International IT University

• ICT 11  Lab_week6.

Laboratory work №6
Working with databases
The aim of the laboratory work is the development of a database: creating tables for storing
information, keys and links between tables, creating and executing queries
Tasks for implementation:
Task 1. Creating tables and keys
Task 2. Creating links
Task 3. Creating a query
As a development tool, use: Microsoft Access.
1. Selection of the variant of the task:
Variants of assignments on question 3
Option Inquiries
1. a) Display the SQL code for the query, the films in which Clint Eastwood
played.
b) Create a request for the films in which the director played, too. Sort by
name. Display the SQL code.
2. a) Create a query named "Movies and Directors by Score", which displays only
the movie titles, the results of the views, and the director for each movie sorted by
the results of the views from the highest to the lowest.
b) Display the SQL code for the query, which shows the films where Tim
Robbins played. Sort by name in reverse order.
3. a) What tables do you need to create a query that shows the names of the films
and actors that have played in the films?
b) Display the SQL code for the query, in which the actors played together with
Kevin Costner in the movie Dances with Wolves.
4. a) Create a query that shows a list of all the actors having the first ordinal
position of the actor in the casting list. Sort by name. Display the SQL code.
b) Display the SQL code for the query in which the actors played together with
Clint Eastwood in the film Unforgiven.
5. a) Display the SQL code for the query, which lists the movies created in the
90's. Sort by year of release in reverse order.
b) Display the SQL code for the query, which shows the films where Robin
Williams played.

2. Methodical instructions for implementation
2.1. The theoretical part
One of the most common database management systems is MS Access. The Access database is
part of the MS Office group and represents a collection of data and objects.
MS Access supports the following objects:
• Table - relation in relational terminology;
• Query - the saved text (model) of the SQL query to the database tables;
• Forms - the design of the user interface;
• Reports - design of output information of the database;
• Macros - groups of macros;
• Modules - program modules in VBA language that can be used in queries, forms,
reports,