July 3rd, 2020 
Assignment Instructions
There are 2 parts to this weeks assignment.
Download the attached instruction details.
The objective is to perform the same tasks; first, by issuing SQL commands, and then by using MS Access (use the graphical interface to perform the tasks).
Part A SQL (70%); by following the detailed instructions you will Create a table, Insert data into that table, and use Select commands to select and display data from the table.
Submit one Word document, which includes the text of the SQL commands, and screen captures of the commands along with the Web sites feedback.
Part B MS Access (30%): use MS Access to create the same tables, load the same content and perform the same Queries.
The MS Access database is submitted.
Two files will be submitted a word document for Part A and an Access database for Part B.
Posted in 