|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|