[Solved]Goals Download Complete Ms Word File Individual Case Study Requirements Point Values Sure Q37255550
Goals
Download and complete the MS Word file for ‘IndividualCase Study Requirements and Point Values’.
Be sure to add at least 5 records for each table.
Enter the points you give yourself for each task in the firstcolumn of above document.
Click on the above hyperlink to submit work.
NOTE: Create a zip file (folder) containingall required files and submit only the onecompressed zip file folder.
There are step-by-step instructions under ‘Our Classroom’ /’Reference Area’.
Include: 1. MS Access .accdb file, 2. MS Word documentwith answers to questions, and 3. your Self-Grading MS Wordfile.
Only one submission attempt is allowed.
To verify contents of your created zip file folder, double click onfile folder name before submission.
Specification Document – GradingRubric PlaceYour Name HERE
Individual Case Study Requirements & Point Values
Student Instructions:
Self Grade. Under the ‘Done’ column, enter thepoints you give yourself for completing the task.
Attach this MS Word file, alongwith other required files to your gradebook.
Self
Grade
Points
Points
Possible
Object
Name
to Use
Requirement(s)
2
tbl Design 3 tables includingproperties for appropriate fields.
Enterat least 5 records in each table.
3
tbl Set relationships (joins)between tables
2
qry1
qry1 Create a query showing all fields from onetable
2
qry2
qry2 Create a query showing fields from more than 1table
2
qry3
qry3 Create a query using a sort (ascending ordescending).
2
qry4
qry4 Create a query contain a function such as Countor Sum
2
frm1
frm1 Create a form for one table (shows one recordat a time)
2
frm2
frm2 Create a form with a subform (the subform showsdata from another table)
2
rpt1
rpt1 Create a report using grouping (by one field),adjust placeholder in report design (if need be) to display entirefield
Type in a separate MS Word file thefollowing:
SQL Code – type out the code you woulduse.
It is optional to include in the MS Access database file.
2
SQL_1
SQL code to display all fields in one of your tables.
2
SQL_2
SQL code to display a few fields and use a sort on one of thefields.
3
SQL_3
SQL code using the COUNT function.
3
SQL_4
SQL code (that could be used) to create (from scratch) one ofyour tables.
3
SQL_5
SQL code to insert a new record into one of your tables.
3.5
Database Security Plan – explain in detail 3ways to secure your database management system from cyberattacks orbreeches.
3.5
List 3 future improvements (enhancements) foryour system such as modifications to tables, forms, queries, and/orreports.
1
Create a zip file folder to hold required files for submissionto gradebook.
40
Grand Total of Points
In one to three sentences explain what business processyour database system automates.
What total point value do you feel yourdatabase system should be awarded and why?
Expert Answer
Answer to Goals Download and complete the MS Word file for ‘Individual Case Study Requirements and Point Values’. Be sure to add a… . . .
OR
