tbl Design 3 tables including properties for appropriate fields. Enter at least 5 records in each table.
tbl Set relationships (joins) between tables
qry1 Create a query showing all fields from one table
qry2 Create a query showing fields from more than 1 table
qry3 Create a query using a sort (ascending or descending).
qry4 Create a query contain a function such as Count or Sum
frm1 Create a form for one table (shows one record at a time)
frm2 Create a form with a subform (the subform shows data from another table)
rpt1 Create a report using grouping (by one field), a page header, & page footer
Type in a separate MS Word file the following:
SQL Code type out the code you would use. It is optional to include in the MS Access database file.
SQL code to display all fields in one of your tables.
SQL code to display a few fields and use a sort on one of the fields.
SQL code using the COUNT function.
SQL code (that could be used) to create (from scratch) one of your tables.
SQL code to insert a new record into one of your tables.
Database Security Plan explain in detail 3 ways to secure your database management system from cyberattacks or breeches.
List 3 future improvements (enhancements) for your system such as modifications to tables, forms, queries, and/or reports.	Using database fundamentals