4) a. Load a database application b. Create a database labelled as MOVIE_LIBRARY in the created fokder with the following fiekls: MovieID, Movie Name, Date Released, Movie Category, Quantity Delivered. MovieID Movie Name Date Released Movie Quantity Category Action Delivered MV01 Transformer 3 04/02/2021 52 MV02 Girl Next Door 15/06/2020 Horror 100 MV03 Blended 12/05/2014 Comedy 250 MV04 Fast and Furious 7 16/10/2018 Action 300 MV05 Noah 07/08/2021 Adventure 85 MV06 Gifted Hands 30/09/2015 Drama 300 MV07 The Legend of 15/03/2018 Action 150 Hercules MV08 Son of Batman 14/12/2019 Adventure 50 MV09 RoboCop 17/02/2017 Action 100 MV10 Frankenstein 08/01/2018 Horror 120 c. Save the table as tbIMovies. d. Fill tbIMovies with the given data as shown in 2 (b).
4) a. Load a database application b. Create a database labelled as MOVIE_LIBRARY in the created fokder with the following fiekls: MovieID, Movie Name, Date Released, Movie Category, Quantity Delivered. MovieID Movie Name Date Released Movie Quantity Category Action Delivered MV01 Transformer 3 04/02/2021 52 MV02 Girl Next Door 15/06/2020 Horror 100 MV03 Blended 12/05/2014 Comedy 250 MV04 Fast and Furious 7 16/10/2018 Action 300 MV05 Noah 07/08/2021 Adventure 85 MV06 Gifted Hands 30/09/2015 Drama 300 MV07 The Legend of 15/03/2018 Action 150 Hercules MV08 Son of Batman 14/12/2019 Adventure 50 MV09 RoboCop 17/02/2017 Action 100 MV10 Frankenstein 08/01/2018 Horror 120 c. Save the table as tbIMovies. d. Fill tbIMovies with the given data as shown in 2 (b).
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
100%
a. Load a
b. Create a database labelled as MOVIE_LIBRARY in the created folder with the following fields:MovieID, Movie Name, Date Released, Movie Category, Quantity Delivered (table in image attachment)
c. Save the table as tblMovies.
d. Fill tblMovies with the given data as shown in 2 (b).
e. Create a form for the records and name it frmMovies
f. Query the table to look out for movies released in the year
2014 and name it as qryMovies
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY